it may be helpful if u take the stats from V$SEGMENT_STATISTICS and compare them over a period of time. I believe this view might be available only from 9i upwards.
regards ratnesh -----Original Message----- Sent: Friday, December 19, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Is it possible to find how many DML operations have ocurred on a given table in a given time period? I'd like to be able to rank the tables in a database based on the number of DML actions performed on them in a given time period. It would be interesting to see which are the 'hot spots' so to speak, and either a) tune access to those tables accordingly, or b) put out the fires. Granted, this strays somewhat from the Millsapian/Holtian doctrine of focusing on the user action with the largest business impact, but I still think it would be interesting to see. Thanks for any help, -- Dan ======================================================================== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division ======================================================================== -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Singh, Ratnesh (GEI, GEFA, Contractor) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).