OraFAQ Forum: Server Administration » Which transaction is using which ROLLBACK SEGMENT

Home » RDBMS Server » Server Administration » Which transaction is using which ROLLBACK SEGMENT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Which transaction is using which ROLLBACK SEGMENT [message #51961]

Mon, 24 June 2002 04:14

Nagesh
Messages: 18
Registered: April 2002

Junior Member

Hi,

How do we know, which transaction is using which rollback segment. Any script please...

Nagesh.

Report message to a moderator

Re: Which transaction is using which ROLLBACK SEGMENT [message #51973 is a reply to message #51961]

Mon, 24 June 2002 12:43

andrew again
Messages: 2577
Registered: March 2000

Senior Member

SELECT r.NAME, s.sid, s.serial#, s.username, s.machine, t.status, t.cr_get, t.phy_io, t.used_ublk,
t.noundo, s.program, t.start_time, sq.sql_text
FROM sys.v_$session s, sys.v_$transaction t, sys.v_$rollname r, v$sqltext_with_newlines sq
WHERE t.addr = s.taddr AND t.xidusn = r.usn AND sq.hash_value = s.sql_hash_value
ORDER BY t.start_time

Report message to a moderator

Previous Topic:	Standby database implemenation
Next Topic:	how to change the exiting filedname to new filedname

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 20:29:06 CDT 2024