open spreport.sql in your favorite editor, and find the following line: column snap_id heading 'Snap|Id' format 9990; Change it to: column snap_id heading 'Snap|Id' format 9999990; Look also for 'linesize 80'. You will likely want to change it to at least linesize 83 HTH Jared oracle-l-bounce@xxxxxxxxxxxxx wrote on 07/21/2004 12:03:47 PM: > 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 //www.freelists.org/archives/oracle-l/ > FAQ is at //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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------