Idea ID 2747395
It is a best practice for the Oracle DB to have seperate for LOBs for performance and maintaince:
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.