执行完awrrpt.sql中的内容之后报了一个错如下:SQL> Rem $Header: awrrpt.sql 24-oct-2003.12:04:53 pbelknap Exp $
SQL> Rem
SQL> Rem awrrpt.sql
SQL> Rem
SQL> Rem Copyright (c) 1999, 2003, Oracle Corporation. All rights reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem awrrpt.sql
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem This script defaults the dbid and instance number to that of the
SQL> Rem current instance connected-to, then calls awrrpti.sql to produce
SQL> Rem the Workload Repository report.
SQL> Rem
SQL> Rem NOTES
SQL> Rem Run as select_catalog privileges.
SQL> Rem This report is based on the Statspack report.
SQL> Rem
SQL> Rem If you want to use this script in an non-interactive fashion,
SQL> Rem see the 'customer-customizable report settings' section in
SQL> Rem awrrpti.sql
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem pbelknap 10/24/03 - swrfrpt to awrrpt
SQL> Rem pbelknap 10/14/03 - moving params to rpti
SQL> Rem pbelknap 10/02/03 - adding non-interactive mode cmnts
SQL> Rem mlfeng 09/10/03 - heading on
SQL> Rem aime 04/25/03 - aime_going_to_main
SQL> Rem mlfeng 01/27/03 - mlfeng_swrf_reporting
SQL> Rem mlfeng 01/13/03 - Update comments
SQL> Rem mlfeng 07/08/02 - swrf flushing
SQL> Rem mlfeng 06/12/02 - Created
SQL> Rem
SQL> --
SQL> -- Get the current database/instance information - this will be used
SQL> -- later in the report along with bid, eid to lookup snapshots
SQL> set echo off heading on underline on;
SQL> column inst_num heading "Inst Num" new_value inst_num format 99999;
SQL> column inst_name heading "Instance" new_value inst_name format a12;
SQL> column db_name heading "DB Name" new_value db_name format a12;
SQL> column dbid heading "DB Id" new_value dbid format 9999999999 just c;
SQL> prompt
SQL> Rem $Header: awrrpt.sql 24-oct-2003.12:04:53 pbelknap Exp $
SQL> Rem
SQL> Rem awrrpt.sql
SQL> Rem
SQL> Rem Copyright (c) 1999, 2003, Oracle Corporation. All rights reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem awrrpt.sql
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem This script defaults the dbid and instance number to that of the
SQL> Rem current instance connected-to, then calls awrrpti.sql to produce
SQL> Rem the Workload Repository report.
SQL> Rem
SQL> Rem NOTES
SQL> Rem Run as select_catalog privileges.
SQL> Rem This report is based on the Statspack report.
SQL> Rem
SQL> Rem If you want to use this script in an non-interactive fashion,
SQL> Rem see the 'customer-customizable report settings' section in
SQL> Rem awrrpti.sql
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem pbelknap 10/24/03 - swrfrpt to awrrpt
SQL> Rem pbelknap 10/14/03 - moving params to rpti
SQL> Rem pbelknap 10/02/03 - adding non-interactive mode cmnts
SQL> Rem mlfeng 09/10/03 - heading on
SQL> Rem aime 04/25/03 - aime_going_to_main
SQL> Rem mlfeng 01/27/03 - mlfeng_swrf_reporting
SQL> Rem mlfeng 01/13/03 - Update comments
SQL> Rem mlfeng 07/08/02 - swrf flushing
SQL> Rem mlfeng 06/12/02 - Created
SQL> Rem
SQL> --
SQL> -- Get the current database/instance information - this will be used
SQL> -- later in the report along with bid, eid to lookup snapshots
SQL> set echo off heading on underline on;
SQL> column inst_num heading "Inst Num" new_value inst_num format 99999;
SQL> column inst_name heading "Instance" new_value inst_name format a12;
SQL> column db_name heading "DB Name" new_value db_name format a12;
SQL> column dbid heading "DB Id" new_value dbid format 9999999999 just c;
SQL> prompt
SQL> prompt Current Instance
Current InstanceSQL> prompt ~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~SQL> select d.dbid dbid
2 , d.name db_name
3 , i.instance_number inst_num
4 , i.instance_name inst_name
5 from v$database d,
6 v$instance i; DBID DB_NAME INST_ INST_NAME
---------- ------------ ----- ------------
1592291887 CIRC 1 circSQL> @@awrrpti
Error reading fileSQL> undefine num_days;
SQL> undefine report_type;
SQL> undefine report_name;
SQL> undefine begin_snap;
SQL> undefine end_snap;
SQL> --
SQL> -- End of file
SQL> 我用的服务器是9i,客户端是10g的。
不知道这里什么问题,请指教
SQL> Rem
SQL> Rem awrrpt.sql
SQL> Rem
SQL> Rem Copyright (c) 1999, 2003, Oracle Corporation. All rights reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem awrrpt.sql
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem This script defaults the dbid and instance number to that of the
SQL> Rem current instance connected-to, then calls awrrpti.sql to produce
SQL> Rem the Workload Repository report.
SQL> Rem
SQL> Rem NOTES
SQL> Rem Run as select_catalog privileges.
SQL> Rem This report is based on the Statspack report.
SQL> Rem
SQL> Rem If you want to use this script in an non-interactive fashion,
SQL> Rem see the 'customer-customizable report settings' section in
SQL> Rem awrrpti.sql
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem pbelknap 10/24/03 - swrfrpt to awrrpt
SQL> Rem pbelknap 10/14/03 - moving params to rpti
SQL> Rem pbelknap 10/02/03 - adding non-interactive mode cmnts
SQL> Rem mlfeng 09/10/03 - heading on
SQL> Rem aime 04/25/03 - aime_going_to_main
SQL> Rem mlfeng 01/27/03 - mlfeng_swrf_reporting
SQL> Rem mlfeng 01/13/03 - Update comments
SQL> Rem mlfeng 07/08/02 - swrf flushing
SQL> Rem mlfeng 06/12/02 - Created
SQL> Rem
SQL> --
SQL> -- Get the current database/instance information - this will be used
SQL> -- later in the report along with bid, eid to lookup snapshots
SQL> set echo off heading on underline on;
SQL> column inst_num heading "Inst Num" new_value inst_num format 99999;
SQL> column inst_name heading "Instance" new_value inst_name format a12;
SQL> column db_name heading "DB Name" new_value db_name format a12;
SQL> column dbid heading "DB Id" new_value dbid format 9999999999 just c;
SQL> prompt
SQL> Rem $Header: awrrpt.sql 24-oct-2003.12:04:53 pbelknap Exp $
SQL> Rem
SQL> Rem awrrpt.sql
SQL> Rem
SQL> Rem Copyright (c) 1999, 2003, Oracle Corporation. All rights reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem awrrpt.sql
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem This script defaults the dbid and instance number to that of the
SQL> Rem current instance connected-to, then calls awrrpti.sql to produce
SQL> Rem the Workload Repository report.
SQL> Rem
SQL> Rem NOTES
SQL> Rem Run as select_catalog privileges.
SQL> Rem This report is based on the Statspack report.
SQL> Rem
SQL> Rem If you want to use this script in an non-interactive fashion,
SQL> Rem see the 'customer-customizable report settings' section in
SQL> Rem awrrpti.sql
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem pbelknap 10/24/03 - swrfrpt to awrrpt
SQL> Rem pbelknap 10/14/03 - moving params to rpti
SQL> Rem pbelknap 10/02/03 - adding non-interactive mode cmnts
SQL> Rem mlfeng 09/10/03 - heading on
SQL> Rem aime 04/25/03 - aime_going_to_main
SQL> Rem mlfeng 01/27/03 - mlfeng_swrf_reporting
SQL> Rem mlfeng 01/13/03 - Update comments
SQL> Rem mlfeng 07/08/02 - swrf flushing
SQL> Rem mlfeng 06/12/02 - Created
SQL> Rem
SQL> --
SQL> -- Get the current database/instance information - this will be used
SQL> -- later in the report along with bid, eid to lookup snapshots
SQL> set echo off heading on underline on;
SQL> column inst_num heading "Inst Num" new_value inst_num format 99999;
SQL> column inst_name heading "Instance" new_value inst_name format a12;
SQL> column db_name heading "DB Name" new_value db_name format a12;
SQL> column dbid heading "DB Id" new_value dbid format 9999999999 just c;
SQL> prompt
SQL> prompt Current Instance
Current InstanceSQL> prompt ~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~SQL> select d.dbid dbid
2 , d.name db_name
3 , i.instance_number inst_num
4 , i.instance_name inst_name
5 from v$database d,
6 v$instance i; DBID DB_NAME INST_ INST_NAME
---------- ------------ ----- ------------
1592291887 CIRC 1 circSQL> @@awrrpti
Error reading fileSQL> undefine num_days;
SQL> undefine report_type;
SQL> undefine report_name;
SQL> undefine begin_snap;
SQL> undefine end_snap;
SQL> --
SQL> -- End of file
SQL> 我用的服务器是9i,客户端是10g的。
不知道这里什么问题,请指教
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货