MONITORING

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Thu, 24 Jan 2002 17:02:13 GMT
Message-ID: <3c503dc8.1416730407@news.alt.net>

When is an item considered stale, so that GATHER STALE collects recollects statistics?

Also, I hacked this together:

SELECT UT.Table_Name, UT.Num_Rows,

       UTM.Inserts, UTM.Updates, UTM.Deletes,
       ROUND((UTM.Inserts + UTM.Deletes) / DECODE(UT.Num_Rows, 0, 100,
UT.Num_Rows) * 100, 2) || '%' "Percent Added/Deleted",
       ROUND((UTM.Inserts + UTM.Updates + UTM.Deletes) /

DECODE(UT.Num_Rows, 0, 100, UT.Num_Rows) * 100, 2) || '%' "Percent Changed",

       UT.Last_Analyzed, UTM.Timestamp "Modification time" FROM User_Tables UT, User_Tab_Modifications UTM WHERE UT.Table_Name = UTM.Table_Name
ORDER BY (UTM.Inserts + UTM.Updates + UTM.Deletes) / DECODE(UT.Num_Rows, 0, 100, UT.Num_Rows) DESC

Does it make sense?

Brian Received on Thu Jan 24 2002 - 11:02:13 CST