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