Run this:
select s.sid, s.serial#, s.username, s.osuser osuser, w.event event, p2 latch#,

w.seconds_in_wait secswait
from v$session_wait w,
v$session s
where s.sid = w.sid
and ((event not like '%SQL*Net%'
and event not like '%timer%'
and event not like '%ipc%') or
(event like '%dblink%'))
order by 1
/

And you will see what oracle is doing right now.


Run this:

set linesize 600
col rbs format a10
col horario format a25
col "OS User" format a15
col "Oracle User" format a15
col "Undo size(K)" format 9999,999

select r.name rbs, l.sid Sid, s.serial#, p.spid spid,
nvl (s.osuser, p.username) "OS User",
s.username "Oracle User",
(used_ublk * par.value) / 1024 "Undo size(K)",
s.module module,
to_char(s.logon_time, 'yyyy.mm.dd=hh24:mi:ss') horario
from v$lock l,
v$process p,
v$rollname r,
v$session s,
v$transaction t,
v$parameter par
where l.sid = s.sid (+)
and s.paddr = p.addr
and trunc(l.id1(+)/65536) = r.usn
and l.type(+) = 'TX'
and l.lmode(+) = '6'
and s.saddr = t.ses_ADDR
and par.name = 'db_block_size'
order by 6,r.name
/

to get some info about which rollbacks are being used, and the amount of undo
info generated. If you see a transaction with the undo size decreasing, you can
be sure that a rollback is going on.

HTH
Fabio

_______________________________________________________________________________________________
Yahoo! GeoCities
Tenha seu lugar na Web. Construa hoje mesmo sua home page no Yahoo! GeoCities. É fácil e grátis!
http://br.geocities.yahoo.com/
Oracle LazyDBA home page