busy extent.

[AbhayShukla]

Hi All,

Do we have any commnd in progress/OE similar to below

rfutil <DB_NAME> -C aimage list

where i can get to know the busy extent of a particular Storage Area( data ).

Thanks

Abhay

 

[TomBascom]

Data extents do not work like AI extents. There is no "BUSY". They can all be active simultaneously.

I'm guessing that you are really asking about finding the "high water mark" probably so that you can determine if it is time to add a new extent.

The following code was posted by Dmitri Levin on PEG in answer to that question last week:

for each _AreaStatus where
   ( not _AreaStatus-Areaname matches "*After Image Area*" )
  no-lock:

  display
    _AreaStatus-Areanum  format ">>>" column-label "Num"
    _AreaStatus-Areaname format "x(20)" column-label "Area Name"
    _AreaStatus-Totblocks format ">>,>>>,>>>" column-label "Tot blocks"
    _AreaStatus-Hiwater column-label "H watermark" format ">>,>>>,>>9"
    _AreaStatus-Hiwater / _AreaStatus-Totblocks * 100 format ">99.99" column-label "% use"
    _AreaStatus-Extents  format ">>>" column-label "Ext"
     with down width 130 overlay.
end.

But the better answer is "enable large files and make all of your storage areas variable length" (unless your database is very large or growing by gigabytes per hour).