V$rollstat

[learn]

Can any one explain what shriks, Aveshrink, extends means after querying v$rollstat ?

[arshiah]

Extends: How many times the rollback segment went beyond the optimal size (or SHRINK TO size).
Shrinks: How many times it was shrunk back to optimal size (or SHRINK TO size)
Aveshrink: The average of the shinks

[omegamark]

extends --The current number of extends for the rollback segments

[learn]

thanks.
I have one more question.What does
rssize,optsize,wraps,aveactive,urblk stand for in when you query v$rollstat

thanks

[thedba]

Oracle needs to come out wit a documentation on what all the columns on the v$ and daba views mean.
I hope somebody else who knows these can answer your questions.
Sorry I can't help.

[sreddy]

[url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/ch3128.htm#9013[/url]