Re: Statspack wierd Output

Just go in the spreport.sql ($ORACLE_HOME/rdbms/admin) and change the time format for that output. On my W2K install it's at line 579 and then again line 635 for the full wait events list.

At 07:14 AM 1/6/2004, you wrote:
>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: 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).

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.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).