Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id hBJK6nV28917 for ; Fri, 19 Dec 2003 14:06:49 -0600 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id hBJK6no28912 for ; Fri, 19 Dec 2003 14:06:49 -0600 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id hBJK16207132 for oracle-l@orafaq.com; Fri, 19 Dec 2003 12:01:06 -0800 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005DA73A; Fri, 19 Dec 2003 12:04:26 -0800 Message-ID: Date: Fri, 19 Dec 2003 12:04:26 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Daniel Hanks Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Daniel Hanks Subject: Finding the most actively DML'd table Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Content-Transfer-Encoding: 7bit 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: hanksdc@about-inc.com 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: ListGuru@fatcity.com (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).