Jared, What do you think of those values, what should I pay attention ?
tia Ramon EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT ---------------------------------------- ----------- -------------- ----------- ------------ db file sequential read 113400 0 277.22 .244462081 db file scattered read 67216 0 302.23 .449639967 smon timer 4618 4610 1416823.33 30680.4532 pmon timer 461116 460357 1416861.73 307.267961 rdbms ipc message 1464153 1390637 8499583.86 580.512 SQL*Net message from client 7010003 0 17798435.8 253.900545 control file parallel write 460820 0 2.01 .000436179 control file sequential read 3959 0 7.95 .200808285 log file sync 19345 0 16.43 .084931507 log file sequential read 2427 0 17.56 .723526988 direct path write 145205 0 112.74 .077641954 direct path read 251233 0 190.41 .075790203 ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 4:13 PM > What does this tell you? > > select > event, > total_waits, > total_timeouts, > time_waited/100 time_waited, > average_wait > from v$system_event > order by time_waited > / > > > > > > Johnson Poovathummoottil <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/31/2002 01:24 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject: extremely high number of executions > > > Hi All, > > We have an application which executes one sql > statement more than 10 million times a day. Everything > is good about the sql, well tuned, uses indexes, parse > only once, etc. The number of concurrent users in this > database seems to around 60, but we see an average > 1500 executions/sec. > > We questioned the developers about the sql as we had > seen 80% to 95% latch sleeps on library cache > constantly. They seem to be hitting the database every > time a page is refreshed instead of storing the > retrieved data some where for later use. > > The developers are of the opinion that cookies and > session variables are considered "the much > detested and reviled Satan and Lucifer of all > "stateful" web apps". > > Any comments/opinion? > > __________________________________________________ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Johnson Poovathummoottil > 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). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez 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).
