Database Reference
In-Depth Information
Figure 2-5.
oratop output screen shot
The granular statistics that appear in the window help to identify database performance contention and
bottlenecks. The live window guidelines are categorized into three major sections: 1) top five events (similar to
the AWR/ASH report), 2) top Oracle sessions on the server in terms of high I/O and memory and 3) DB load
(also provides blocking session details, etc.). Press
q
or
Q
to quit from the utility and press
Cont+C
to abort.
■
Note
the tool is available for downloading only through Mos, which requires additional support licensing.
RAC Configuration Audit Tool - RACcheck
RACcheck
is a tool that performs audits on various important configuration settings and provides a comprehensive
HTML-based assessment report on the overall health check status of the RAC environment.
The tool is currently certified on the majority of operating systems that can be used in interactive and
non-interactive modes and also supports multiple databases at a single run. It can be run across all nodes, on a subset
of cluster nodes, or on a local node. When the tool is invoked, it carries out the health checks on various components,
such as cluster-wide, CRS, Grid, RDBMS, ASM, general database initialization parameters, OS kernel settings, and OS
packages. The most suitable time for performing health checks with this tool is immediately after deploying a new
RAC environment, before and after planned system maintenances, prior to major upgrades, and quarterly.
With its Upgrade Readiness Assessment Module ability, it will simplify and enhance system upgrade readiness
reliability. Apart from regular upgrade prerequisite verifications, the module lets you perform automatic prerequisite
verification checks for patches, best practices, and configuration. This will be of great assistance before planning any
major cluster upgrades.
Invoke the RACcheck Tool
Download the raccheck.zip file from MOS, unzip it, and set the appropriate permission to the
raccheck
file, which
is
chmod 755 raccheck
on Unix platforms. To invoke the tool in interactive mode, use the following example at the
command prompt as the Oracle software owner and provide the following input when prompted:
$./raccheck
