| Show |
Topic |
Description |
Version |
 |
RAC |
I/O Calibarion procedure, modify the number of physical disks to your need. |
11.1.0 > |
|
RAC |
Script to "overload" the CPU in the database instance. |
10.2.0 > |
|
ASM |
List hidden ASM parameters |
10.1.0 > |
|
RAC |
Object privileges |
|
|
RAC |
System privileges to roles and users: |
|
|
RAC |
Users to roles and system privileges |
|
|
Clusterware |
This script can be used to validate the resources in a cluster environment in 1 run, or parts of it. For example if you have 8 database in your Cluster environment, to validate the status without Enterprise Manager Grid control you need to execute srvctl status several times or use crs_stat. This script can show the status for asm,database,nodeapps,crs. Usage script -h to see the possible options. |
10.0 > |
|
Dataguard |
Redo Generation Peak load |
|
|
ASM |
What database does file ..... in ASM belong to? |
10.1.0 > |
|
ASM |
What database files do I have in ASM for each database?
|
10.1.0 > |
|
RAC |
Show the index name, index type for each table in the user schema, including the location of the index column.
|
9.2.0 > |
|
RAC |
This script will show the contraint type and name for each table in the user schema. |
9.2.0 > |
|
Unix |
script to setup SSH for Cluster installation |
|
|
ASM |
Shows relation between ASM Disks and the Diskgroups (with or without failuregroups). |
10.1.0 - 11.1.0 |
|
RAC |
A perl script to generate CPU load at OS level. |
9.2.0 - 11.1.0 |
|
RAC |
Show the average interconnect latency for Cache Fusion. |
10.1.0 - 11.1.0 |
|
ASM |
Show if Preferred Mirror Read is used in extended cluster environment. |
11.1.0 > |
|
ASM |
Shows which database instance(s) are using any ASM diskgroup with the compatibility settings in 11g |
11.1.0 > |
|
ASM |
Show the attribute settings for a diskgroup in 11g
|
11.1.0 > |
|
ASM |
Show the relation between Diskgroups, failure groups and ASM Disks in 11g |
11.1.0 > |
|
Session Info |
Provide an output showing what an OS session is doing in the database. |
10.1.0 - 11.1.0 |
|
RAC |
Shows size of the database files, excluding the tempfiles. |
10.1.0 - 11.1.0 |
|
Flash Recovery Area |
Is the archive logfile stored in the flash recovery area. |
10.1.0 - 11.1.0 |
|
ASM |
Shows which database instance(s) are using any ASM disk group that are being mounted by this ASM instance by querying v$asm_client |
10.1.0 - 11.1.0 |
|
ASM |
Shows which templates are available in an ASM diskgroup. |
10.1.0 - 11.1.0 |
|
ASM |
Shows which disks are seen by the ASM instance, query on v$asm_disk |
10.1.0 - 11.1.0 |
|
ASM |
Shows ASM waits statistics |
10.1.0 - 11.1.0 |
|
ASM |
Shows ASM disk statistics |
10.1.0 - 11.1.0 |
|
ASM |
Show Rebalance operations going on |
|
|
ASM |
Shows the relationship between ASM Diskgroup, OS Path and Lun id at OS level for AIX system |
|
|
ASM |
This script can be used to validate if there are performance problems at OS/Disk level or that the performance problems are related to the RDBMS/ASM part. If the disk performance is also bad at OS level using the script it is pointing to an OS/Storage issue. |
|
|
Backup/Recovery |
How to map SCN with Timestamp. In Oracle 10g, there are two inbuilt functions to give the timestamp and SCN mapping details. Timestamp_to_scn() and Scn_to_timestamp() built-ins. |
|
|
Backup/Recovery |
What is the block change tracking file performance benefit if we would not use Fast incremental backups, but just incremental backups |
|
|
Backup/Recovery |
Where is the block change tracking file. used for FAST incremental backups. CTWR background process keeps track of block changes and RMAN use it to do quicker incremental backups, then without the block change tracking file. |
|
|
Clusterware |
Display the CRS_STAT -t option in a more readable format. |
10.0 > |
|
Clusterware |
This script is the basis for a serverside FAN callout events.
In the if.. then... fi. part you can add/change the needed part based on the values. As with every script, you need to test it.
Remember that every script in the $ORA_CRS_HOME/racg/usrco defined is executed. |
|
|
Flash Recovery Area |
Is the controlfile stored in the flash recovery area. |
|
|
Flash Recovery Area |
Is the logfile stored in the flash recovery area. |
|
|
Flash Recovery Area |
What is the status of the flash recovery area. |
|
|
Locking |
Shows the Holder session and Waiting session in a rac environment. The second query will do the same but then only in a instance and not clusterwide. |
|
|
Locking |
Shows which session is waiting on which session and the locking type. |
|
|
RAC |
Display the sessions using undo bocks and the number of undo records in a cluster environment. |
|
|
RAC |
Shows the master parallel session with there childeren, Cluster wide, including DOP. |
|
|
RAC |
Shows which instance is mastering an object. |
10.0 > |
