|
-
______________________________________________
originally posted by ronnie:
Following is the Extents Storage Parameter for each one of them. (I am using DBA Studio to look at them)
Initial Size = 256 KB
Next Size = 256 KB
Optimal Size = 512 KB
Minimum Number = 2 (not editable)
Maximum Number = 2147483645
The RBS Tablespace has the following Extent Storage paramater
Initial Size = 1024 KB
Next Size = 1024 KB
Minimum Number = 2 (editable)
Maximum Number = 2147483645
____________________________________________________________
Your RBS Tablespace storage parameter will only take effect
to your rollback segments storage definition if you did not explicitly define the storage parameter of your rbs.
Let's say:
create public rollback segment rbs1 tablespace RBS;
rbs1 will have automatic storage def of:
initial size 1024 kb
next size 1024 kb
mininum extents 2
maximum extents 2147483645
Though it could perform much better, but I believe it's still not enough. So you have to make it much bigger, follow what tamilselvan says about number minimum and maximum extents and if you have a lot of concurrent users that makes a lot of DMLs to your system which leads to exhaust your rbs then you have to add more numbers of rbs.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|