V$segstat statistics meaning
Hi,
I am working on a project to find all the segments growth pattern in database and for that I am using V$SEGSTAT to get the stats about segments.
In my environment, for 1 LOB object, the stats in V$SEGSTAT looks like:
space used ==> 953767766114
space allocated ==> 67108864
And I want to know what is the meaning of 'space used' here? How and when it can be more that actual space allocated??
I know when it can go negative (from shrink and reorg) but in order to get my project done, I need the clear definition of 'space used' and 'space allocated' stats.
I am working on a project to find all the segments growth pattern in database and for that I am using V$SEGSTAT to get the stats about segments.
In my environment, for 1 LOB object, the stats in V$SEGSTAT looks like:
space used ==> 953767766114
space allocated ==> 67108864
And I want to know what is the meaning of 'space used' here? How and when it can be more that actual space allocated??
I know when it can go negative (from shrink and reorg) but in order to get my project done, I need the clear definition of 'space used' and 'space allocated' stats.
1