Re: enq: TS - contention

  Amir,    

If relevant/applicable, look into any temporary  

tablespace issues and/or dropping any temp  

 extents not released and see if it helps ?      

Rajeev    

>
> On Nov 8, 2023 at 1:03 PM, <Hameed Amir (mailto:dmarc-noreply_at_freelists.org)> wrote:
>
>
>
>
>
> 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-l