Is there any significant overhead to leaving tables in monitoring mode? For example, if I left them as such for a few days or two, and then gathered the stats on them?
Thanks again, -- Dan On Fri, 19 Dec 2003, Goulet, Dick wrote: > Alter table <table_name> monitoring; > > then look in DBA_TAB_MODIFICATIONS > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -----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 > ======================================================================== > -- ======================================================================== 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).