How can you find out if a rollback segment is private or public
Printable View
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]
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.