Home » SQL & PL/SQL » SQL & PL/SQL » Identifying Rollback Segment for a transaction
Identifying Rollback Segment for a transaction [message #20043] Fri, 26 April 2002 03:43 Go to next message
Sushil Chopra
Messages: 3
Registered: October 2001
Junior Member
I have a transaction for which I have assigned rollback segment explicitly using "SET TRANSACTION USE ROLLBACK SEGMENT RBS_BIG". My question is - How can I know whether it is using the desired Rollback Segment or not?

Thanks
Sushil

Report message to a moderator

Re: Identifying Rollback Segment for a transaction [message #20068 is a reply to message #20043] Sat, 27 April 2002 11:14 Go to previous message
Susan
Messages: 102
Registered: October 2001
Senior Member
Some dynamic performance views and data dictionay views should help u in this. Query v$rollname,v$transaction,v$session and dba_rollback_segs should help u in this.

Report message to a moderator

Previous Topic: Running a procedure every 10 minutes
Next Topic: Multiple rows SQL query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 18:29:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.