SQL> @spreport.sqlCurrent Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
221215848 MYDATA 1 mydataInstances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host
----------- -------- ------------ ------------ ------------
221215848 1 MYDATA mydata MICROSOF-00D
D93Using 221215848 for database Id
Using 1 for instance numberCompleted 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
5Specify 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.txtUsing the report name rep1208.txt
ERROR: Begin Snapshot Id specified does not exist for this database/instanceERROR: End Snapshot Id specified does not exist for this database/instanceWARNING: timed_statitics setting changed between begin/end snaps: TIMINGS AREVALIDERROR: Snapshots chosen span an instance shutdown: RESULTS ARE INVALIDERROR: Session statistics are for different sessions: RESULTS NOT PRINTED
begin
*
ERROR 位于第 1 行:
ORA-20100: Missing start value for statistic: db block changes
ORA-06512: 在"PERFSTAT.STATSPACK", line 794
ORA-06512: 在"PERFSTAT.STATSPACK", line 894
ORA-06512: 在line 2
STATSPACK report forDB Name DB Id Instance Inst Num Release Cluster Host
------------ ----------- ------------ -------- ----------- ------- -----------
MYDATA 221215848 mydata 1 9.0.1.1.1 NO MICROSOF-00
D93
:ela := ;
*
ERROR 位于第 4 行:
ORA-06550: 第 4 行, 第 17 列:
PLS-00103: 出现符号 ";"在需要下列之一时:
(-+casemodnotnull
<an identifier><a double-quoted delimited-identifier>
<a bind variable>avgcountcurrentexistsmaxminpriorsqlstddev
sumvarianceexecuteforallmergetimetimestampintervaldate
<a string literal with character set specification>
<a number><a single-quoted SQL string>pipe
符号 "null" 被替换为 ";" 后继续。
ORA-06550: 第 6 行, 第 16 列:
PLS-00103: 出现符号 ";"在需要下列之一时:
(-+casemodnotnull
<an identifier><a double-quoted delimited-identifier>
<a bind variable>avgcountcurrentexistsmaxminpriorsqlstddev
sumvarianceexecuteforallmergetimetimestampintervaldate
请问这里的错误是什么原因,做实验的时候并没有停机
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
221215848 MYDATA 1 mydataInstances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host
----------- -------- ------------ ------------ ------------
221215848 1 MYDATA mydata MICROSOF-00D
D93Using 221215848 for database Id
Using 1 for instance numberCompleted 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
5Specify 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.txtUsing the report name rep1208.txt
ERROR: Begin Snapshot Id specified does not exist for this database/instanceERROR: End Snapshot Id specified does not exist for this database/instanceWARNING: timed_statitics setting changed between begin/end snaps: TIMINGS AREVALIDERROR: Snapshots chosen span an instance shutdown: RESULTS ARE INVALIDERROR: Session statistics are for different sessions: RESULTS NOT PRINTED
begin
*
ERROR 位于第 1 行:
ORA-20100: Missing start value for statistic: db block changes
ORA-06512: 在"PERFSTAT.STATSPACK", line 794
ORA-06512: 在"PERFSTAT.STATSPACK", line 894
ORA-06512: 在line 2
STATSPACK report forDB Name DB Id Instance Inst Num Release Cluster Host
------------ ----------- ------------ -------- ----------- ------- -----------
MYDATA 221215848 mydata 1 9.0.1.1.1 NO MICROSOF-00
D93
:ela := ;
*
ERROR 位于第 4 行:
ORA-06550: 第 4 行, 第 17 列:
PLS-00103: 出现符号 ";"在需要下列之一时:
(-+casemodnotnull
<an identifier><a double-quoted delimited-identifier>
<a bind variable>avgcountcurrentexistsmaxminpriorsqlstddev
sumvarianceexecuteforallmergetimetimestampintervaldate
<a string literal with character set specification>
<a number><a single-quoted SQL string>pipe
符号 "null" 被替换为 ";" 后继续。
ORA-06550: 第 6 行, 第 16 列:
PLS-00103: 出现符号 ";"在需要下列之一时:
(-+casemodnotnull
<an identifier><a double-quoted delimited-identifier>
<a bind variable>avgcountcurrentexistsmaxminpriorsqlstddev
sumvarianceexecuteforallmergetimetimestampintervaldate
请问这里的错误是什么原因,做实验的时候并没有停机
------------------------------------
这里提示很清楚,98、100 Snapshot Id不存在。
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---------------------------------
这里列出的就是已完成的快照ID(1和2)。
注意看提示信息。