Statspack wierd Output

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Tue, 06 Jan 2004 06:14:25 -0800
Message-ID: <F001.005DBD88.20040106061425@fatcity.com>

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: VIVEK_SHARMA_at_infosys.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 Tue Jan 06 2004 - 08:14:25 CST