I personally believe that monitoring the SQLArea for any poor performing SQL
should also be done on a regular basis (*as well as monitoring the "OWI"
(:P)*).. The end result should be to build as complete a picture as possible
as to what is running through the system, where users are waiting, and the
response times that they are getting.
By and large - 80% of performance problems seen with Oracle databases are
caused by poorly performing SQL. With that in mind - my feeling is that this
is one of the main areas that a DBA should be monitoring over a period of
time, archiving any "offenders" (whether this be by DISK_READS, BUFFER_GETS,
BUFFER_GETS/EXECUTIONS etc..) to a table or flat file or whatever "floats
your boat", and return to that "archive" once in a while to see if they can
make any improvement to the "dogs" that are hounding the system..
V$VIEWS are your friends.. Just because somebody recommends monitoring by
wait events, doesn't mean you can't go on to monitor by some other criteria,
and build a more comprehensive view of what's happening.
Just my 0.02 pence
Mark
===================================================
Mark Leith | T: +44 (0)1905 330 281
Sales & Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
===================================================
http://www.cool-tools.co.uk
Maximising throughput & performance
-----Original Message-----
Sent: 24 April 2002 13:59
To: Multiple recipients of list ORACLE-L
There's something I don't understand. Why use the wait interface to
investigate "db file scattered read" or "db file sequential read"?
The end result is finding an SQL statement that does a lot of reads.
There's no guarantee it's a poorly tuned SQL statement, just that it does a
lot of reads.
If that's what you want, why not just query v$sql and order by physical
reads? Doing this is a whole lot easier. Also, unlike the hit and miss
results from v$session_wait, v$sql provides a comprehensive picture.
Thanks for your input. Cheers!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
