Database Reference
In-Depth Information
No.
Script Name
Description
MVRACPDnTap_objpolicystats.sql
The script against the X$OBJECT_POLICY_STATISTICS gives current
statistics on the type of access the objects have on the instances
they are currently being mastered. SOPENS column indicates the
number of times the object has been mastered on the instance in
shared mode. XOPENS indicates exclusive mode, and XREFS indicates
exclusive reference.
9
MVRACPDnTap_blockers.sql
10
The script helps to identify lockers and the sessions that are blocked
from due to chained waits.
MVRACPDnTap_latch_childrencbc.sql The script lists the CBC ( cache buffer chains ) latch statistics.
11
MVRACPDnTap_seglatchstats.sql
12
The query helps determine the objects and the number of times that
the object has been touched.
MVRACPDnTap_instCacheTrans.sql
13
The query displays statistics for blocks transferred among instances
in the cluster; the view captures data based on where the data had
originated.
MVRACPDnTap_gesLockBlockers.sql
14
The script displays all locks currently maintained by the Global
Enqueue Service and helps in identifying global lockers and waiters
across the cluster.
MVRACPDnTap_crblksrvr.sql
15
The script list the CR blocks served statistics.
MVRACPDnTap_curblksrvr.sql
16
The script lists the current block served statistics.
MVRACPDnTap_ConvertLocal.sql
17
The script displays statistics for local GES enqueue operations
and records average convert times, count information, and timed
statistics for global enqueue requests for current and consistent read
requests/operations.
MVRACPDnTap_ConvertRemote.sql
18
The script displays average convert times, count information, and
timed statistics for global enqueue requests for CURRENT blocks.
The script helps to determine the type of locks conversions that did
not occur locally on the instance and had happened on one of the
remote instances in the cluster.
MVRACPDnTap_dlmlibcache.sql
19
The script displays statistics showing library cache performance
and activities. When looking at RAC from each individual instance
in the cluster, the RELOADS and INVALIDATIONS columns should be
monitored. RELOADS indicates the number of times the objects had to
be reloaded into the library cache.
MVRACPDnTap_rowcache.sql
20
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_svcstats.sql
21
The script list the statistics for the database services with active
sessions.
The script is identical to the MVRACPDnTap_svcloadstats.sql script
used in Chapter 11.
 
Search WWH ::




Custom Search