Re: Objects with blocks inside undo

On Tue, 21 Jun 2005 10:52:12 -0700, JLchiappa wrote:

> b) what objects (tables, indexes, etc) contains blocks in the undo seg
> _SYSnn being read : with this I can check the execution log and
> (hopefully) find the culprits.

You can find out which transaction have blocks in the particular segment by querying V$TRANSACTION. You can see what objects are being accessed by particular SID from V$ACCESS (this gives you parse locks and is rather unreliable)
For finding out which objects are protected by the particular UNDO segment, you'd probably have to dump it. How to dump blocks is explained in detail on Julian Dyke's web site.

-- 
I either want less corruption, or more chance to participate in it.