LSH Profile Option "LSH: Tablespace for Workarea schema objects"
Last updated on MARCH 27, 2017
Applies to:Oracle Life Sciences Data Hub - Version 220.127.116.11 to 18.104.22.168 [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 22.214.171.124 we released a new profile option called:
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