Gurus
I've applied many of the things I've learnt from this list over the years
and today I tried a 10046 trace for the first time on a reported slow
transaction. From what I can tell the biggest offender is a wait seemingly
associated with rollback (see below) called 'direct path write'. Is this
So, when you look for the segment_type,segment_name,owner in dba_extents,
what do you see for file_id=1026 and block_id's as listed in p2?
On 10/30/2003 09:44:25 AM, Tim Onions wrote:
Gurus
I've applied many of the things I've learnt from this list over the years
and today I tried a 10046