Oracle-L: RE: Database tracking

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 15 Jan 2003 11:09:57 -0800
Message-ID: <F001.005307D2.20030115110957@fatcity.com>

Tom - I'll provide an example of what we do and maybe it will give you some ideas. On one database, the users have identified a certain process that has marginal performance at best, and when anything gets out of whack it gets bad real fast. So the developers have added a logging feature in the application. When the user hits "submit", that is logged, along with the username and other relevant data. When the results are returned to the user, that is also logged. Now we have a measurement from the user's perspective. This has allowed us to detect problems a number of times before they were serious. When the users have complained about intolerable performance it has given us some actual numbers to review (rather than opinions or impressions).

I think you have a good idea, but if possible you should go end-to-end, rather than just the database. I would go with STATSPACK snapshots if you just want to look at the server. That gives you an overall server status, while a single query may not detect a lot of severe problems.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, January 15, 2003 11:54 AM To: Multiple recipients of list ORACLE-L

All, I would like to track the performance of my production databases by running the same SQL statement against each database every 5 minutes or so and recording the results. For example: sql> set timing on;
sql> select count(*) from dba_tables;

That was I would know if they are getting faster or slower over time. As anyone already done this? Would there be a good SQL statement to use?

Thanks,
Tom Terrian

--

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

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.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 Wed Jan 15 2003 - 13:09:57 CST