| increasing size of RBS..? [message #139149] |
Mon, 26 September 2005 12:31  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai,
we are getting ora-01555 snapshot too old error.
we are using 8i under linux.
we need to get resolved from the error and for that the RBS size needs to be increased.so how to increase the size of already existing RBS..?plz help out.
regards
bala
|
|
|
|
|
|
|
|
| Re: increasing size of RBS..? [message #139475 is a reply to message #139194] |
Wed, 28 September 2005 03:56  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
balavignesh .. mahesh had given u link of document so that you can study and clear your concept related to RBS & u can understand why this 0ra-01555 occurs...
but if you want to increase the size of your rollback segment .. then first of all you have to find rollback segment whose size you have to increase ....
The following statement alters the maximum number of extents that the RBS_01 rollback segment can allocate.
SQL>ALTER ROLLBACK SEGMENT rbs_01 STORAGE (MAXEXTENTS 120);
note :- rbs_01 is rollback segment name.
Regards
Always Friend Sunilkumar
[Updated on: Wed, 28 September 2005 03:57] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
