RE: Finding the most actively DML'd table

From: Singh, Ratnesh (GEI, GEFA, Contractor) <Ratnesh.Singh_at_ge.com>
Date: Fri, 19 Dec 2003 14:09:25 -0800
Message-ID: <F001.005DA740.20031219140925@fatcity.com>

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: hanksdc_at_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_at_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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Singh, Ratnesh (GEI, GEFA, Contractor)   INET: Ratnesh.Singh_at_ge.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_at_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). Received on Fri Dec 19 2003 - 16:09:25 CST