Re: STATSPACK

From: Q A I S E R <qrasheed_at_gmail.com>
Date: Wed, 21 Jul 2004 15:09:26 -0500
Message-ID: <4d4db22004072113095078ef1f@mail.gmail.com>

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_at_hotmail.com> 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_at_freelists.org
> 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_at_freelists.org 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
-----------------------------------------------------------------

Received on Wed Jul 21 2004 - 15:09:03 CDT