-
How can you find out if a rollback segment is private or public
-
Try this command. If it is the public then it will give you in the
owner field. Good Luck.
SELECT segment_name, tablespace_name, owner
FROM sys.dba_rollback_segs;
[Edited by sree_sri on 05-09-2001 at 07:25 PM]
sree
-
sys.undo$
select name, user# from sys.undo$
user# = 1 -> segment public
user# <> 1 -> segment nonpublic
Maybe I mistake?
-
Difference holds good in Oracle Parallel Server Configuration. Both same in normal configuration.
Reddy,Sam
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
|