Problem with spreport.sql [message #234985] |
Thu, 03 May 2007 11:32 |
thorin666
Messages: 144 Registered: March 2007
|
Senior Member |
|
|
hi, my problem is that
when i use spreport.sql make an error
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
SQL> @spreport.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1491322848 ORACLE 1 oracle
Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Using 1491322848 for database Id
Using 1 for instance number
declare
*
ERROR at line 1:
ORA-20200: Database/Instance 1491322848/1 does not exist in
STATS$DATABASE_INSTANCE
ORA-06512: at line 23
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr oduction
With the Partitioning, OLAP and Data Mining options
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
i tried to use echo $DATABASE_INSTANCE but nothing happen,
Sorry but is my first time that i try to use statspacks (i used spcreate.sql and run the spreport.sql using the schemma perfstat)
Can someone help me?
thnx
[Updated on: Thu, 03 May 2007 11:33] Report message to a moderator
|
|
|
|
Re: Problem with spreport.sql [message #235002 is a reply to message #234994] |
Thu, 03 May 2007 13:04 |
thorin666
Messages: 144 Registered: March 2007
|
Senior Member |
|
|
Michel Cadot wrote on Thu, 03 May 2007 12:13 | You tried to use spreport.sql on a database that is not the one that collects the statistics.
Instead of spreport.sql use:
define dbid=<your original database id>
define inst_num=<your original instance number>
@spreins
Regards
Michel
|
michel, i am trying to run spreport.sql locally in the database where i want to collect the statistics, must i follow your steps?
and where must i put the define values? i never did it before
|
|
|
|
Re: Problem with spreport.sql [message #235016 is a reply to message #235003] |
Thu, 03 May 2007 14:03 |
thorin666
Messages: 144 Registered: March 2007
|
Senior Member |
|
|
Michel Cadot wrote on Thu, 03 May 2007 13:08 | Then you should first investigate why STATS$DATABASE_INSTANCE does not contain your dbid/instance_number.
Regards
Michel
|
sorry michael was my fault
first i must to run statspack.snap 2 times to get 2 snaps to make the report, that's why my stats$database_instance dont contain mi instance information
thnx
|
|
|