Re: Statspack wierd Output
Hi Vivek, I am not a statspack expert but your problem is simply an SQL issue. The ### means that the field format is not big enough for the value being returned in the SQL. Simply open the SQL file and find the SQL that prints this and look for the column format somewhere above that. Change the format so it is wider. The other options is to run the report so that it generates smaller values - shorter time period? hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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).
Re: Statspack wierd Output
Alternate solution: Don't run it for an hour. One would expect the accumulated wait times to be smaller then and not leading to the value overflow. At 07:14 AM 1/6/2004, you wrote: Statspack taken from a Production Database for a 1 hour period on Oracle 8.1.7.4 version 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: [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).
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,5762,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). 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: [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).
RE: Statspack wierd Output
modify the sql file and change the format string ... ### indicates value overflow. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, January 06, 2004 9:14 AM To: Multiple recipients of list ORACLE-L 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,5762,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). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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).