Re: STATSPACK

Seema,

Since you're using 8.1.6, I believe the file you need to change is
spreport.sql, but otherwise Qaiser's suggestion is correct.

--Terry

----- Original Message ----- 
From: "Q A I S E R" <qrasheed@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, July 21, 2004 1:09 PM
Subject: Re: STATSPACK


Seema,

In $ORACLE_HOME/rdbms/admin/sprepins.sql, change the column format. By
default it shows you four characters 9999. Your snap_id is bigger than
this number.

column snap_id     format 99990 heading 'Snap|Id';

Qaiser



On Wed, 21 Jul 2004 15:03:47 -0400, Seema Singh <oracledbam@xxxxxxxxxxx>
wrote:
> Hi,
> when I was trying to run statspack report,the snapid is showing #####
after
> 9999 In oracle 816.
> Do you think we may need to truncate and restart?
> thanks
>
> _________________________________________________________________
> Don't just search. Find. Check out the new MSN Search!
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: