Re: Operations in huge transaction slow down suddenly. Why?

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Fri, 17 Dec 2004 21:31:30 +0100
Message-ID: <7eg6s01a19cojeejpjorhsn67bl57i37b7@4ax.com>

On Fri, 17 Dec 2004 17:01:12 +0100, "Bernhard Graeuler" <fuerspam_at_gmx.de> wrote:

>Ok, that's it. If anyone has any suggestions what we could try next, or has
>an idea, what could be the reason for this, please answer this.

set event 10046 level 8 in the affected session and you'll know what it is waiting for. Likely the disk, as most time is wasted in the execute phase

alter session set events='10046 trace name context forever, level 8'; alter session set max_dump_file_size=unlimited

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Dec 17 2004 - 14:31:30 CST