Hi
Statspack exceptionally showing the following on a particular day :-
Top 5 Wait Events
~~~~~~~~~~~~~~~~~ Wait %
Total
Event Waits Time (cs)
Wt Time
-------------------------------------------- ------------ ------------
-------
db file sequential read 100,106,503 ############
41.66
db file scattered read 15,134,519 ############
25.00
latch free 1,692,425 ############
16.67
buffer busy waits 2,067,006 ############
16.66
log file sync 543,576 2,449,354
.00
-------------------------------------------------------------
NOTE -
Statspack taken from a Production Database for a 1 hour period on Oracle
8.1.7.4 version
Application = Hybrid in nature , Banking s/w
4000 Concurrent Users connect to the Database
Qs What can be the cause of the same?
Qs Can anything be done about such field value Overflow i.e.
############ ?
Will provide any info required
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
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: [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).
