hi experts,

i just see that some rollback segment belong to user SYS (see below).
Do those rollback (rs_01,rs_02,rs_03,rs_04,rs_05) must be in offline
status..? at the moment they are online.
when i run a query those rollback are used but the user is not SYS user.
any idea..?
thank a lots

david..

SEGMENT_NAME OWNER Tablespace
------------------------------ -------------- -------------
SYSTEM SYS SYSTEM
RS_01 SYS ROLLBACK
RS_02 SYS ROLLBACK
RS_03 SYS ROLLBACK
RS_04 SYS ROLLBACK
RS_05 SYS ROLLBACK
RS_06 PUBLIC ROLLBACK
RS_07 PUBLIC ROLLBACK
RS_08 PUBLIC ROLLBACK
BIG_RBS PUBLIC BIG_ROLLBACK

Oracle LazyDBA home page