Create a normal statspack report user on the main library
Sqlplus/as SYSDBA
Sql>@?/rdbms/admin/spcreate.sql
Sql>--Notice to cancel $oracle_home/sqlplus/glogin.sql some settings
Sql>--some normal words will appear asking for password and tablespace and temporary files
Perfstat 235619
--Create SB User
Sql>@?/rdbms/admin/sbcreate.sql
Enter the password tablespace temporary table space.
Then ask if you want to configure network (y/n) input y
Configure the Tnsname of the standby library;
Build Dblink use Perfstat password 235619 to double quotation marks
Stdbyperf 235619
Sql>@?/rdbms/admin/sbdrop.sql can remove the re-match for SB users.
Execution on the main library
Sql> Conn stdbyperf/235619
Sql> exec statspack_goodg_goodg. SNAP-Package STATSPACK_GOODG_GOODG can go to the user stdbyperf to see the specific name
--In the middle you can go to the repository to execute some SQL
Sql> exec statspack_goodg_goodg. SNAP
Execution on the main library
(5) Generate report
Sql> Conn stdbyperf/235619
Sql> @?/rdbms/admin/sbreport.sql
In the execution script, you are prompted to enter information,
Only one
Instance Name
Then it's the snapshot ID.
Then there is the report name
Although this is good, but every time in the main library operation is inconvenient to the main library to dry it? So we have a lot of caution, I hope that in the future can be executed in the standby snapshot, production reports.
Statspack performance report configuration method for ORACLE 11G ADG