| Rollback Segments Parameter [message #58784] |
Tue, 30 September 2003 09:47  |
Rodrigo
Messages: 8
Registered: September 2002
|
Junior Member |
|
|
Hi All !
I'm using Oracle 8.1.6 with SunOS 5.8.
I have 10 small segments and added 5 bigs segments. When I change theses 10 small segments from online to offline and shutdown the instance, theses back to online when starting the instance.
Where and what is the paramenter that I need configure to do not start theses 10 small segments ?
Thanks in advanced !
Rodrigo
|
|
|
|
|
|
|
|
|
|
| Re: Rollback Segments Parameter [message #58796 is a reply to message #58790] |
Tue, 30 September 2003 19:11  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Rodrigo,
do a
Select segment_name,owner,status from dba_rollback_segs;
If the OWNER=PUBLIC ( ie you created public rollback segments via CREATE PUBLIC ROLLBACK SEGMENT..) they will come ONLINE even if you made them OFFLINE before shutting down the instance. Its becos they are meant to be accessed by multiple instances in a Parallel Server environment and is not controlled by just 1 instance config.
ROLLBACK_SEGMENTS parameter usually specifies private rollback segments that need to be brought online for that instance.
So you can either recreate those small rollback segments as private(just Create rollback segment ..statement) and control them using the init.ora parameter or drop them if you dont need them.You can create them when necessary.
Hope this helps
Thiru
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
