-
rollback segs
Hello Guys,
From the following reading of v$rollstat, wat are the things to be noticed ??
extents 20
rssize 10641408
WAITS 195
OPTSIZE 10485760
HWMSIZE 10641408
SHRINKS 0
WRAPS 912
Thanks for ur suggestions
[Edited by prasy on 10-15-2001 at 02:16 PM]
with regards
Prasanna S
-
High Waits/wraps indicate that you have fewer rbs.
-
Since waits and wraps are more, u may need to increase the number of rollback segments, also check v$waitstat to confirm this.
-
Thanks for the replies.
Is there anything to do with the size ??
with regards
Prasanna S
-
u need to divulge , avg active size , extsnd and avg shrink.
-
Originally posted by Prasy
Thanks for the replies.
Is there anything to do with the size ??
Size is probably OK, you might go however to 1M extents on the RBSs depending on your transactions. But you need more RBSs. You should carefully estimate their number.
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
|