enq: TS - contention
From: Hameed Amir <"Hameed>
Date: Wed, 8 Nov 2023 18:00:51 +0000
Message-ID: <SN7PR14MB6470D41DF43F49D0BCB7CF5FE0A8A_at_SN7PR14MB6470.namprd14.prod.outlook.com>
Hi,
The database version is 19.17.0.0, running on OEL8. In our Oracle E-Business Suite production database, a batch job (A) runs and spawns another job (B). Intermittently, job A runs longer and ends up getting terminated by the user. ASH data shows that the process running job A awaited the event "enq: TS - contention".
Date: Wed, 8 Nov 2023 18:00:51 +0000
Message-ID: <SN7PR14MB6470D41DF43F49D0BCB7CF5FE0A8A_at_SN7PR14MB6470.namprd14.prod.outlook.com>
Hi,
The database version is 19.17.0.0, running on OEL8. In our Oracle E-Business Suite production database, a batch job (A) runs and spawns another job (B). Intermittently, job A runs longer and ends up getting terminated by the user. ASH data shows that the process running job A awaited the event "enq: TS - contention".
Based on the limited information I have found, this event seems related to the TEMP tablespace. There is no SQL_ID associated with the session ID waiting on the event. There is a TOP_LEVEL_SQL_ID, which shows the following SQL statement:
select directory_name from all_directories where directory_path = :1
Has anyone run into this issue? Any feedback will be greatly appreciated.
Thank you,
Amir
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 08 2023 - 19:00:51 CET