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 2.1.4.2 to 2.2.0.4 [Release 2.1.0 to 2.2.0]
Information in this document applies to any platform.

Goal

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 2.1.4.2 we released a new profile option called:

LSH: Tablespace for Workarea schema objects

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms