Database Reference
In-Depth Information
Chapter 6—Tools and Utilities
No.
Script Name
Description
MVRACPDnTap_ServiceStats.sql
1
Script lists database service stats. The script helps to isolate top
activity on the database by service name.
MVRACPDnTap_enableAgg.sql
2
Lists the aggregation type enabled at the module/action level.
MVRACPDnTap_ServModActStats.sql
3
Script lists statistics enabled at the service/module/action level from
GV$SERV_MOD_ACT_STATS
view.
Chapter 9—Tuning the Database
No.
Script Name
Description
MVRACPDnTap_EnqStats.sql
1
The query/script gives a list of the top enqueue statistics from all
instances in the cluster. It helps to understand the current enqueue
activity and potential contention areas.
MVRACPDnTap_rowcache.sql
2
The row cache statistics from the output help to understand the
database configuration settings. Higher refresh or reload activity
for a specific row cache item could be an indication to look at
optimizing it, for example, in the case of sequences (identified by
dc_sequences
) to increase the cache size.
MVRACPDnTap_dlmrowcache.sql
3
It's a variation of the previous query. The primary difference
between the two is from what level the data is reported. This query
reports data from a RAC level, across instances, and reflects cache
fusion activity.
MVRACPDnTap_seqcachebal.sql
4
When monitoring the cache size requirements for database
sequences, the script helps to understand how frequently the
database sequences are consumed and how often they have to
be reloaded. This helps to size the cache and to understand the
contentions when the database sequences are defined with the
order clause.
MVRACPDnTap_hardparses.sql
5
The script gives a count of the total number of hard parse operations
from the database.
MVRACPDnTap_rcobjectcount.sql
6
The script gives a list of objects currently stored in the result cache
section of the shared pool.
MVRACPDnTap_rcobjects.sql
7
The query gives a list of objects involved in a result cache operation.
MVRACPDnTap_rcutil.sql
8
The query gives the current result cache statistics. It gives the
current space utilization of the results section of the operation.
MVRACPDnTap_clsqlstats.sql
9
The script gives cluster-level stats for an SQL Statement.
MVRACPDnTap_impopcheck.sql
10
The script lists the current segment statistics of the in-memory area.
Search WWH ::
Custom Search