Re: how to dump and comprehend a rollback block

andreyNSPAM_at_bookexchange.net (NetComrade) wrote in message news:<3f01ca60.2257970810_at_nyc.news.speakeasy.net>...
> 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.

I find Note:1039126.6 from metalink pretty helpful.

jg

--
@home.com is bogus.  Remember pencil drops?
http://www.signonsandiego.com/news/computing/20030702-1059-hackerwarnings.html