Idea ID 2747395
Oracle DB: Seperate LOB Column to a sperate tablespace
It is a best practice for the Oracle DB to have seperate for LOBs for performance and maintaince:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_tables.htm#i1006434
"
Best performance for LOBs can be achieved by specifying storage for LOBs in a tablespace different from the one used for the table that contains the LOB. If many different LOBs will be accessed frequently, then it may also be useful to specify a separate tablespace for each LOB column or attribute in order to reduce device contention.
"
I suggest we offer "how to do this" documentation and DB scripts for Seperate LOB Column to a sperate tablespace in Oracle DB.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.