You Asked

Hi Tom,

is there any performance impact if a table columns shares different tablespaces?

e.g.

CREATE TABLE DATA (
  DATA_ID NUMBER,
  PROPERTY_DATA CLOB,
  PROPERTY_DATA_BIN BLOB,
  BIN_TYPE        VARCHAR2(10 BYTE),
  SOURCE_INSTANCE VARCHAR2(100 BYTE) 
   )
   TABLESPACE TBS_DATA
   LOB (
  PROPERTY_DATA
   )
   STORE AS BASICFILE DATA_LOB_COMPRESSED (
  TABLESPACE TBS_BLOB DISABLE STORAGE IN ROW CHUNK 2048 PCTVERSION 0 CACHE
   )
   LOB (
  PROPERTY_DATA_BIN
   )
   STORE AS BASICFILE DATA_LOB_BIN_COMPRESSED (
  TABLESPACE TBS_BLOB DISABLE STORAGE IN ROW CHUNK 2048 PCTVERSION 0 CACHE
   )

and Connor said...

I would say *extremely* unlikely unless that tablespace itself has different performance characteristics (eg its datafiles were placed on slow disks etc).

Rating

(1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Although

A reader, March 18, 2017 - 6:29 am UTC

Although cannot see different tbs in the posted example!

March 19, 2017 - 5:12 am UTC

TBS_DATA and TBS_BLOB

More to Explore

CLOB/BLOB/etc

Complete documentation on Securefiles and Large Objects here

Breadcrumb

Question and Answer