Re: how to dump and comprehend a rollback block

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 01 Jul 2003 22:46:34 +0200
Message-ID: <sbr3gv01d4ial2jf7bhsn8s9vcaokr7hsh@4ax.com>

On Tue, 01 Jul 2003 17:57:07 GMT, andreyNSPAM_at_bookexchange.net (NetComrade) wrote:

>Can somebody point to official or unofficial documentation on how to
>dump and read info of a rollback segment block? (based on info in
>v$transaction)
>I have some transactions that stay open for too long (usually
>transactions last <1 second, it's a web app). They have TX
>locks/transaction slots open. I have a suspicion it's due to sql over
>the link.
>Any other help would be appreciated as well.
>
>Thanks.
>.......
>We use Oracle 8.1.7.4 on Solaris 2.7 boxes
>remove NSPAM to email

If you suspect it is sql, you can easily identify the sql by linking the addr column of v$transaction back to the taddr column of v$session. The sql_address and the sql_hash_value of v$session point to the offending statement.
I have to look up the info to dump blocks, but I'm not sure it is really useful. The lock info is maintained in data blocks.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jul 01 2003 - 15:46:34 CDT