Can not execute a Statspack Report (spreport.sql)

From: Christian Svensson <chse30_at_hotmail.com>
Date: 27 Aug 2002 00:38:08 -0700
Message-ID: <ccc2a7eb.0208262338.e549542@posting.google.com>

Greetings,

I am getting errors when running the script from Sql*Plus in Windows as PERFSTAT user:

D:\Oracle\Ora81\rdbms\admin\spreport.sql

on a Oracle 8.1.7.3.0 database

I have searched at Metalink, but cant find anything relevant for this.

---

When running this part in the beginning of the script:

clear break compute;
repfooter off;
ttitle off;
btitle off;
set timing off veri off space 1 flush on pause off termout on numwidth 10;
set echo off feedback off pagesize 60 linesize 80 newpage 2 recsep off;
set trimspool on trimout on;

define top_n_events = 5;
define top_n_sql = 65;
define num_rows_per_hash=5;

--

-- Get the current database/instance information - this will be used -- later in the report along with bid, eid to lookup snapshots

column inst_num heading "Inst Num" new_value inst_num format 99999;

column inst_name heading "Instance"  new_value inst_name format a12;
column db_name   heading "DB Name"   new_value db_name   format a12;
column dbid      heading "DB Id"     new_value dbid      format
9999999999 just c;
select d.dbid            dbid
     , d.name            db_name
     , i.instance_number inst_num
     , i.instance_name   inst_name
  from v$database d,
       v$instance i;

variable dbid       number;

variable inst_num number;
variable inst_name varchar2(20);
variable db_name varchar2(20);
begin

  :dbid      := &dbid;
  :inst_num  := &inst_num; 
  :inst_name := &'inst_name';
  :db_name   := &'db_name';

end;
/

Then I get these errors:

FEJL i linie 2:

ORA-06550: line 2, column 17:
PLS-00103: Encountered the symbol "&" when expecting one of the
following:

( - + mod not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance execute forall time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string>

The symbol "- was inserted before "&" to continue.

ORA-06550: line 3, column 17:
PLS-00103: Encountered the symbol "&" when expecting one of the
following:

( - + mod not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum varianc

ORA-06550: line 4, column 17:
PLS-00103: Encountered the symbol "&" when expecting one of the
following:

( - + mod not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum varianc ORA-06550: line 5,

---

Thanks for any comment on this.

Regards

/Christian Received on Tue Aug 27 2002 - 02:38:08 CDT