Re: enq: TS - contention

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 8 Nov 2023 19:10:30 -0500
Message-ID: <bed3e91e-c69e-4f11-9bb3-08ee31345f60_at_gmail.com>

On 11/8/23 13:00, Hameed Amir (amir.hameed) wrote:
>
> 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*"
>
Long, long time ago, in a company far, far away, I've encountered a bug with enq: TS contention. The problem was deferred segment creation, regulated by parameter. I was instructed by Oracle Support to change the corresponding parameter to FALSE and the problems with TEMP space were gone.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 09 2023 - 01:10:30 CET

This message: [ Message body ]
Next message: yudhi s: "Re: Estimations are as good as it can be, what else can be done here?"
Previous message: yudhi s: "Re: Estimations are as good as it can be, what else can be done here?"
Maybe in reply to: Hameed Amir: "enq: TS - contention"
In reply to Hameed Amir: "RE: [EXTERNAL] enq: TS - contention"
Next in thread: yudhi s: "Re: Estimations are as good as it can be, what else can be done here?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message