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

Chapter 14—Tuning the Cluster Interconnect

No. Script Name Description

MVRACPDnTap_dlmmisc.sql 1 The script gives you the distributed lock manager activity across the

network and specifically around the message traffic.

MVRACPDnTap_verifyic.sql

2 The script helps to verify the Interconnect configuration to check if

the right interconnect addresses have been registered or are visible
from inside the database instance.

MVRACPDnTap_blksndtime.sql 3 The script helps calculate the time required to send the block from

the holder to the requestor across all instances in
the cluster.

MVRACPDnTap_dlmtrafficntrl.sql 4 When a message needs to be sent, the process needs to acquire a

ticket from the pool and return the ticket back to the pool once the
message has been transmitted. When there is a message flooding,
there may not be a sufficient amount of tickets in the pool, and the
process requesting for the ticket will have to wait for the ticket. The
script displays the current usage of tickets.

MVRACPDnTap_raclostblocks.sql 5 Blocks can be corrupted or lost during transfer across the

interconnect. This script helps determine the number of blocks
lost/corrupted over the interconnect since the instance was started.

MVRACPDnTap_Dynamicmasterstats.sql The data from the query provides an indication of the overall
activity of remaster operations and the time spent at various stages
of the operation.

6

Chapter 15—Optimizing Distributed Workload

No. Script Name Description

MVRACPDnTap_rowcache.sql 1 This script displays statistics showing the cache behavior of the

dictionary cache. The dictionary cache is part of the shared pool and
does not have any tunable parameters other than the SHARED_POOL
initialization parameter itself. This means that if the shared pool
has not been sized correctly, there is a direct impact on the
dictionary cache.

MVRACPDnTap_sqlstats.sql 2 The script lists SQL run time statistics.

MVRACPDnTap_whoractive.sql 3 This script will list details for active sessions.

MVRACPDnTap_dbrm.sql

4 This script will define DBRM packages and the various services used

in Chapter 15.

MVRACPDnTap_svcstatshist.sql 5 Script will list all statistics for services from the service metrics

history view.

MVRACPDnTap_SrvActSum.sql 6 Script lists the summary of all actions by services.

MVRACPDnTap_SrvModSum.sql

7 Script lists the summary of all modules by services.