Re: statspack question

Read Metalink Note:149122.1 , Sharing StatsPack snapshot data between two or more databases.

If you need to create a report based on the imported data, you will need to modify
the spreport.sql to reference the inst_num and dbid of the database imported directly.
This is required because this script obtain these values by quering the v$database and v$instance views in the target database.

Jaffar

Akimeu wrote:
> hello again. we ran the statspack snaps on a production database, and
> exported the schema (perfstat) to a test machine. how can we run the
> spreport against the test machine? it currently gives us an error that
> it's the wrong dbid. thanks for your assistance.
Received on Wed Jun 21 2006 - 02:11:14 CDT