Re: how to dump and comprehend a rollback block

From: Yong Huang <yong321_at_yahoo.com>
Date: 2 Jul 2003 14:15:26 -0700
Message-ID: <b3cb12d6.0307021315.5faedf6@posting.google.com>

Pete Finnigan <pete_at_petefinnigan.com> wrote in message news:<iZfQlYBgirA$EwxS_at_peterfinnigan.demon.co.uk>...

> alter session set events 'immediate trace name blockdump level {address
> from above}';
>
> I am not sure that this will work on later versions of Oracle but you
> can try it. It should create a trace in user_dump_dest. Remember that

That's not available after Oracle 7. Beginning with Oracle 8, you have to alter system to dump a block.

Yong Huang Received on Wed Jul 02 2003 - 16:15:26 CDT