Database Reference
In-Depth Information
Appendix A
The SQL Scripts Used in This Topic
This appendix lists and documents the various scripts referenced and/or used in the various chapters of this topic.
Please note that the scripts are provided for illustration/example purposes only. The author does not intend to
support these scripts. The scripts have been tested and appear to work as intended. It is advised that all scripts should
be run in a test environment before executing the same in a production environment.
All scripts are suffixed with the following string: “MVRACPDnTap” (Murali Vallath, RAC Performance Diagnostics
and Tuning, Apress). It's just a method to keep generic scripts from those written specifically for this topic.
Chapter 3—Testing for Availability
No.
Script Name
Description
MVRACPDnTap_verifyic.sql
1
Script helps to list the interconnects configured and currently in use by the
database for cache fusion activity.
MVRACPDnTap_taftest.sql
2
Check if the connections made to the database are using the TAF feature. Also,
during an instance crash, the script can be used to check on how many connections
have failed over from the failed instance to one of the surviving instances.
MVRACPDnTap_dgsynchcheck.sql
The script is used to verify if the database is synchronized between the
primary and the standby site. Useful during a scheduled maintenance
operation when the data guard switchover operation is planned between the
primary and standby site.
3
Chapter 4—Testing for Scalability
No.
Script Name
Description
MVRACPDnTap_iocalcheck1.sql
I/O calibration check. Script helps to check if calibration has been completed
for the database and what the current IOPS (I/Os per second) is for the
number of physical disks provided to the calibration operation.
1
Chapter 5—Real Application Testing
No.
Script Name
Description
MVRACPDnTap_extractsql.pl
1
Sample perl script to help extract SQL statements from 10046 trace file and
help replace bind variables with bind values. The output could be used for
load/stress testing the environment.
Search WWH ::
Custom Search