The SQL Scripts Used in This Topic - Expert Oracle RAC Performance Diagnostics and Tuning - page 643

Chapter 11—Tuning Oracle Net

No. Script Name Description

MVRACPDnTap_svcloadstats.sql 1 The query displays the current load distribution across the various

database services. The load characteristics are updated by MMON
and can be viewed from GV$SERVICEMETRIC view.

Chapter 12—Tuning the Storage Subsystem

No. Script Name Description

MVRACPDnTap_iostat.sql 1 The script displays information regarding disk I/O statistics of

database files. Statistics for data files and temp files are listed for
each file. However, for other types of files, such as archive logs and
backup sets, statistics are consolidated into one entry.

Chapter 13—Tuning Global Cache

No. Script Name Description

MVRACPDnTap_reslimit.sql 1 The query lists the current utilization of the global cache section

of the instance memory. When the current utilization equals or
nears the value of the initial allocation, it's an indication to resize the
appropriate memory parameters.

MVRACPDnTap_sharedpooladvice.sql

2 The scripts checks against the shared_pool_advice view and

indicates the current utilization of the shared pool. Based on the
frequent need for a higher shared pool, increasing the start value to
30 G provided improved performances.

MVRACPDnTap_blkpreptime11g.sql 3 The query will help determine the average time spent to prepare the

block for the requestor.

MVRACPDnTap_blksndtime.sql 4 The query will help determine the average time spent by the process

to send the block to the requestor.

MVRACPDnTap_gesLockBlockers.sql 5 This script shows GES locks and blockers with grants and acquires.

MVRACPDnTap_policyhistory.sql 6 The script helps to understand what type of policy was used while the

objects where remastered from one instance to the other. The query
looks at historical behavior by querying the V$POLICY_HISTORY view.

MVRACPDnTap_sqlstats.sql 7 The script gives the wait times experienced by the query during

various stages of the operation. It helps to understand cluster-related
waits and IO-related waits for the query.

MVRACPDnTap_findhotobjmasters.sql The script lists the current master (CM) and previous master (PM)
instances for a few of the objects. The output has been sorted by the
number of times it has been remastered
(CNT column) since the instances were started.

8

( continued )