DB Extent Size Monitor

[sbetcher]

Has anyone written a script for Linux that will monitor the size of extents against the sizes specified in the .st file? I would like something to run and send me an email showing where the actual extents are in size to how they were defined in the structure file.

If there is a better way to monitor this please let me know.

Thanks!

 

[TomBascom]

For a quick, interactive (and free) tool use ProTop. In particular the Storage Area Status display:

Area Statistics
 A# Area Name                Alloc       Var  Hi Water      Free  %Alloc Note
--- -------------------- --------- --------- --------- --------- ------- -------
 68 order_idx                   16      1998      1927        87  12044% i(3)
 67 order                      256     14670     14860        66   5805% t(1)
  6 Schema Area                256      1454      1391       319    543% i(25) *
  3 Primary Recovery Are     32000     13070     45056        14    141%
 13 customer                512000     55565    567515        50    111% t(15)
 92 After Image Area 3           0      5199      5191         8    100% Busy
 49 order-line               32000         2     25164      6838     79% t(1)
 61 inventory               128000         2     94897     33105     74% t(1)
 55 discount               1024000         0    755885    268114     74% t(1)
 57 employee               2048000         0   1442919    605076     70% t(1)

For a more comprehensive full time monitoring solution check out DBAppraise.