Home » RDBMS Server » Server Utilities » determining rollback segment
determining rollback segment [message #72697] Sat, 20 September 2003 03:07 Go to next message
M. Khaled
Messages: 67
Registered: April 2002
Member
HOW COULD I DETERMINE WHICH TABLSPACE IS USED FOR ROLLBACK SEGMENTS.PLS GIVE ME A GOOD QUERY FOR THIS.

THANKS IN ADVANCE....

Report message to a moderator

Re: determining rollback segment [message #72698 is a reply to message #72697] Sat, 20 September 2003 08:53 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
select distinct tablespace_name from dba_Segments where segment_type='ROLLBACK';

and

show parameter undo_tablespace

Hth
Thiru

Report message to a moderator

Previous Topic: Trigger problem
Next Topic: Turn off Oracle Replication during sqlload
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 22:22:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.