Re: how to dump and comprehend a rollback block

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Fri, 11 Jul 2003 18:19:08 GMT
Message-ID: <3f0eff25.343291487@nyc.news.speakeasy.net>

Thanks,

I used a bit modified version:

set linesize 120
set pagesize 100
column username format a30
column sid format 9999
column name format a10
column used_ublk format 999,999,999
column used_urec format 999,999,999

   select s.username||'@'||machine username, s.sid,rn.name, t.xidslot,t.xidsqn,t.used_ublk, t.used_urec, (sysdate- to_date(t.start_time,'mm/dd/yy hh24:mi:ss'))*24*60*60 secs

    from    v$transaction   t
           ,v$session       s
           ,v$rollname      rn
    where  t.addr     = s.taddr

    and t.xidusn = rn.usn
order by secs desc
/

On 2 Jul 2003 14:36:37 -0700, joel-garry_at_home.com (Joel Garry) wrote:

>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

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Jul 11 2003 - 13:19:08 CDT