Dear DBA Gurus,
I have given below the procedure as how we are creating the tables,
preference and indexing for the same. Could you please check if there is any
other preference need to be set for CLOB Datatypes which I missed?
1) To create category table.
CREATE TABLE CATEGORY
Ranganath,
You've defaulted to in-line storage of CLOBs. You could
specify "Disable Storage In Row" and point the CLOBs to
different tablespaces, thus spreading your I/O out over more
drives. You can also define a custom Basic_Storage
interMedia parameter, by which you spread out the 5 or 6