Home » RDBMS Server » Performance Tuning » Problem with spreport.sql
icon9.gif  Problem with spreport.sql [message #234985] Thu, 03 May 2007 11:32 Go to next message
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 #234994 is a reply to message #234985] Thu, 03 May 2007 12:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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
Re: Problem with spreport.sql [message #235002 is a reply to message #234994] Thu, 03 May 2007 13:04 Go to previous messageGo to next message
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 #235003 is a reply to message #235002] Thu, 03 May 2007 13:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Then you should first investigate why STATS$DATABASE_INSTANCE does not contain your dbid/instance_number.

Regards
Michel
Re: Problem with spreport.sql [message #235016 is a reply to message #235003] Thu, 03 May 2007 14:03 Go to previous message
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
Previous Topic: RBO in 10g
Next Topic: Performance monitoring
Goto Forum:
  


Current Time: Fri Dec 02 18:36:13 CST 2016

Total time taken to generate the page: 0.37839 seconds