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
