|
-
I didn't bounce the datatbase neither the timed_statistics is set to false but some reason I still have problems, I ran many statspack in 8i before and I never encounter any issues, this is the first statspack I rn on 9i and I have problem, below is that I did
1. log in as sysdba
2. alter session set timed_statistics=true;
3. exec statspack.snap
4. 4 hours later run another exec.statspack.snap
5. run the spreport.sql with begining value let's say 50 and end value let's 55
and I got this error:
ERROR: Begin Snapshot Id specified does not exist for this database/instance
ERROR: End Snapshot Id specified does not exist for this database/instance
WARNING: timed_statitics setting changed between begin/end snaps: TIMINGS ARE IN
VALID
ERROR: Snapshots chosen span an instance shutdown: RESULTS ARE INVALID
ERROR: Session statistics are for different sessions: RESULTS NOT PRINTED
begin
*
ERROR at line 1:
ORA-20100: Missing Init.ora parameter db_block_size
ORA-06512: at "PERFSTAT.STATSPACK", line 727
ORA-06512: at "PERFSTAT.STATSPACK", line 1126
ORA-06512: at line 2
STATSPACK report for
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|