Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Sunny.

Asked: September 27, 2019 - 5:33 pm UTC

Last updated: September 30, 2019 - 9:52 am UTC

Version: 12c

Viewed 1000+ times

You Asked

As a DBA, what is the best practices for a
Columns that contain Clob ,blob data should store at separate tablespace or same tablespace for performance of query.

If clob or blob data also store in same tablespace could decrease the database performance?

If clob or blob data should be store in the separate tablespace so have any issue while import the database using logical backup?

and Chris said...

Assuming the tablespaces use the same underlying disks, whether you store them in the same or separate tablespaces doesn't matter for performance.

Splitting into separate tablespaces may make some maintenance easier (e.g. backup, recovery, export, etc.). But it depends on what you're trying to do. You can remap tablespaces on import, so this is a non-issue for import.

If you want to knwo more about tuning LOB access, there's a big section of performance guidelines for them in the docs:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/adlob/performance-guidelines.html#GUID-8505852E-936B-477F-B958-14574BB6EDA4

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

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database