Re: STATSPACK

From: Terry Sutton <terrysutton_at_usa.net>
Date: Wed, 21 Jul 2004 13:25:25 -0700
Message-ID: <034201c46f61$20acc180$6601a8c0@TerrySutton>

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_at_gmail.com> To: <oracle-l_at_freelists.org> 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_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
-----------------------------------------------------------------


----------------------------------------------------------------
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:24:37 CDT