Rollback segments: maxextents changed during create?
Hello guys,
I'm creating a new TS that holds my rollback segments: LMT with uniform size of 512K. (db : oracle 8.1.7.1.1)
I'm recreating the rbs's because I want to remove the optimal-clause (I detected a lot of shrinking actions in v$rollstat) and the original TS was DD.
When creating the rollback segment, I issue a MAXEXTENT 505
Code:
CREATE PUBLIC ROLLBACK SEGMENT RBS01
TABLESPACE "RBS2"
STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 10 MAXEXTENTS 505)
When I checked it afterwards, the rbs is created okay, the initial extents are there (checked with "dba_extents"), but the maxextent-item in DBA Studio has changed to 32765, not 505.
Why did the maxextent-value change? Is this a fault of DBA Studio?
Can someone clarify this behaviour?
Thanks in advance!
Erik
Last edited by efrijters; 12-04-2003 at 10:24 AM.
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
Reply With Quote