| Create Rollback Segment [message #26723] |
Wed, 23 July 2003 08:54  |
Muzzammil
Messages: 99
Registered: February 2003
|
Member |
|
|
The below is the Public Rollback Segment
CREATE PUBLIC ROLLBACK SEGMENT rbs_01
TABLESPACE rbsspace
STORAGE (
INITIAL 100K
NEXT 100K
OPTIMAL 4M
MINEXTENTS 20
MAXEXTENTS 100 );
How to create a rollback segment for perticular user and perticular tablespace with.
Please specify the good Store like Initial,Next,Optimal,Minextents,Maxtents) configuration to run successfull.
Thank you,
Syed Muzzammil
|
|
|
|
| Re: Create Rollback Segment [message #26781 is a reply to message #26723] |
Fri, 25 July 2003 13:14  |
oraboy
Messages: 97
Registered: October 2001
|
Member |
|
|
Rollback segments are created for database and not for users.. if you want an user session to use any specific rollback segnment you should use alter session set rollback segment commnad
Create rollback segments with same initial & next values and preferable in multiples of DB_BLOCK_SIZE.
congfiguring Shrinks & wraps of rollback segments depends on your env. and transactions nature.
Oraboy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
