|
-
use bot of these and check how many records are used and
How much more time it will take ..
check whether you have space for rollback space ...
select l.sid sid,p.spid PID,NVL ( s.username, 'NO TRANSACTION' ) USERNAME,
NVL ( s.osuser, '----' ) osuser,
substr(r.name,1,10)"RBS NAME",
s.terminal TERMINAL ,
USED_UREC,
START_TIME
FROM v$lock l, v$process p, v$session s, v$rollname r ,V$TRANSACTION T
WHERE l.sid = s.sid(+) AND TRUNC (l.id1(+)/65536) = r.usn
AND l.type(+) = 'TX' AND l.lmode(+) = 6 AND s.paddr = p.addr
and s.taddr=t.addr ORDER BY r.name
select SID,SERIAL#,TARGET,SOFAR,TOTALWORK,TIME_REMAINING,
to_char(START_TIME,'DD-MON-YYYY HH:MI:SS PM')"START_TIME",
to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS PM')"SYSDATE",message
from v$session_longops where TIME_REMAINING>0
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|