My Oracle Support Banner

LSH Profile Option "LSH: Tablespace for Workarea schema objects" (Doc ID 1518355.1)

Last updated on MARCH 27, 2017

Applies to:

Oracle Life Sciences Data Hub - Version to [Release 2.1.0 to 2.2.0]
Information in this document applies to any platform.


The LSH Tables are created in a tablespace called ‘APPS_TS_TX_DATA’. By default, all WA installations create data tables in this tablespace.  As the data grows or when there are huge data loads in progress, there is a potential issue with buffer cache here. There is a cache contention between the DML’s coming from LSH User Interface and the DML’s from the backend jobs as they are both using the same block sized tablespace.

To resolve this, we need to create a new tablespace with a different blocksize and assign that tablespace for Work Area schema objects. Tablespaces with different block sizes do not use the same buffer cache and hence the cache contention is eliminated.

In LSH we released a new profile option called:

LSH: Tablespace for Workarea schema objects



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.