Empty extent

[epappila]

How to find out is variable lenght database extent empty or used?

Thanks, Esa

 

[TomBascom]

If it is very small and the time stamp is old it is unused.

 

[cj_brandt]

depends how you want to do this -
from a command line you can try proutil <dbname> -C iostats or look at VST _ActIOFile.
You can also look at the _AreaStatus VST -

there are a few ways.