Statspack分析结果错误

Statspack分析结果错误:

SQL> @spreport.sql

Current Instance
~~~~~~~~~~~~~~~~
  DB Id  DB Name  Inst Num Instance
----------- ------------ -------- ------------
221215848 MYDATA  1 mydata


Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DB Id  Inst Num DB Name  Instance  Host
----------- -------- ------------ ------------ ------------
221215848  1 MYDATA  mydata  MICROSOF-00D
    D93

Using  221215848 for database Id
Using  1 for instance number

Completed Snapshots

  Snap  Snap
Instance  DB Name  Id  Snap Started  Level Comment
------------ ------------ ----- ----------------- ----- ----------------------
mydata  MYDATA  1 02 1月  2009 23:2  5
  5
  2 02 1月  2009 23:2  5
  5


Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
输入 begin_snap 的值:  98
Begin Snapshot Id specified: 98

输入 end_snap 的值:  100
End  Snapshot Id specified: 100


Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is sp_98_100.  To use this name,
press <return> to continue, otherwise enter an alternative.
输入 report_name 的值:  rep1208.txt

Using the report name rep1208.txt


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

VALID

ERROR: Snapshots chosen span an instance shutdown: RESULTS ARE INVALID

ERROR: Session statistics are for different sessions: RESULTS NOT PRINTED
begin
*
ERROR 位于第 1 行:
ORA-20100: Missing start value for statistic: db block changes