Statspack分析结果错误
点击右边红色标题查看本文完整版：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
