Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.

Oracle DB: Seperate LOB Column to a sperate tablespace

Idea ID 2747395

Oracle DB: Seperate LOB Column to a sperate tablespace

Status: Declined Submitted by Micro Focus Expert on ‎2019-11-22 04:35

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.

Labels
2 Comments
guanyun_yuan
Micro Focus Contributor
Micro Focus Contributor
‎2019-11-25 04:22
‎2019-11-25 04:22
Pls add this feature,thank you.
daniel_crisan
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
‎2019-12-02 08:50
‎2019-12-02 08:50
Status changed to: Declined

I will move this idea to "declined" as from what I understand from the above statement this procedure is not specifically related to the OO product.

Most "Liked" Contributors
View All ≫
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.