Re: Database tracking

[Anjo Kolk]

Title: Message

If it runs slower, then what? And if it automagically fixes it self again? Is that considered a problem or not?   Anjo. ----- Original Message ----- From: Terrian, Tom (Contractor) (DAASC) To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 15, 2003 6:53 PM Subject: Database tracking 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