Oracle Real Application Cluster or Real Application Cluster One Node Database
To configure the monitor type
In the Add Monitoring Configuration panel, select the following parameters for the Oracle Enterprise Database KM:
Parameter | Selection |
|---|---|
Monitoring Solution | Oracle Enterprise Database |
Monitoring Profile | Oracle Environment Monitoring |
Monitor Type | Oracle RAC Database |
For the Global Monitoring Setting, you can enable Logging for all of the configured PATROL Agent environments to confirm that all of the PATROL for Oracle Enterprise Database environments are correctly configured.
To add an environment configuration
Click Add and enter the details in the Environment Configurations pane.
The remaining environment details are in the following sections:
RAC instance connection details
In the RAC instance connection details section, click Add. The RAC instance connection details pane is displayed.
Field | Description |
|---|---|
Oracle SCAN | Enter the hostname or the IP address used for the Oracle RAC. |
Oracle SCAN listener port | Enter the port number that is used to connect with the Oracle RAC Database. |
Oracle RAC service name | Enter the RAC service that you want to monitor. To get a list of RAC services, use the srvctl command. |
Connect as SYSDBA | Select this option to connect to the Oracle RAC instance as SYSDBA privileged user. |
Oracle credentials | |
User Name | Enter the user name to connect to the Oracle RAC Database. |
Password | Enter the password to connect to the Oracle RAC Database. |
Oracle Custom SQL Queries | |
Query name | In the Oracle Custom SQL Queries section, click Add. On the Custom SQL Query pane, enter the name for the SQL query. |
SQL query | Enter the SQL query command. |
Collection time (min) | Enter the SQL query collection time. The default collection time is 10 minutes. |
Enable number of records annotation | Select this option to display the query result as an annotation on number of records metric. |
Monitoring Categories details
Select the Oracle RAC Database activity categories and tablespaces that you want to monitor.
The Node availability monitor category is discovered by default.
Monitoring Categories | Description |
|---|---|
ASM | Select this checkbox to monitor the performance of the Oracle Database ASM disks. |
Fast Recovery Area | Select this checkbox to monitor the performance of the Oracle Fast Recovery Area disks. |
Operating System usage | Select this checkbox to monitor the operating system utilization statistics and system resources. |
Pluggable Database | Select this checkbox to monitor the pluggable databases. |
Services | Select this checkbox to monitor Oracle services running inside the Database. |
Sessions | Select this checkbox to monitor the session activity of the Oracle Database. |
Wait Events | Select this checkbox to monitor the wait events in the Oracle RAC Database. |
Tablespaces | |
Tablespaces | Select this option to monitor the tablespaces. To configure thresholds and categorize tablespaces as large and very large, see Configure large and very large tablespace categorization. |
Tablespaces filtering options | |
Filtering mode | Select the filtering mode:
|
Include/Exclude matching criteria | Based on the selection of the filtering mode, specify the tablespaces to include or exclude from monitoring. Use comma (,) only to separate the tablespaces.
|
Filter for top n queries by total wait time | |
Total wait time monitoring | Select this option to enable the filter for top n queries by total wait time. |
Top Number of queries | Enter the number of queries that you want to filter. This is a mandatory field. |
Maximun query instances limit | Enter the maximum number of query instances to filter. This is a mandatory field. |
Number of days to keep query instances | Enter the number of days to keep the query instance. This is a mandatory field. |
Environment Settings details
Field | Description |
|---|---|
Logging | Select this option to enable detail-level logging for all PostgreSQL databases configured on this environment to get more details about policy configuration and data collection. The log files are created under the PATROL_HOME directory:
For more information about logging, see Using-debug-logging-in-the-TrueSight-Infrastructure-Management-operator-console. |
Device mapping | By default, device mapping on the TrueSight console is enabled. If enabled, all the Oracle RAC Database instances are discovered under the Oracle host device. |
Java collector settings | |
Java path | Enter the path to the JRE directory (also known as $JAVA_HOME environment variable) on the PATROL Agent host.
If you enter a path for the JRE directory, you must enter the full path, such as C:\Program files\Java\jre1.8.0_151. Do not use the short path format.
|
JVM arguments | Enter the optional Java Virtual Machine (JVM) arguments for the Java collector. |
User name | Enter the local user name to start the Java process. |
Password Confirm password | Enter the password to start the Java process. |
Collection settings | |
Availability collection interval (min) | Enter the time interval used to check for the availability of environment for collecting data. |
Data collection interval (min) | Enter the time interval used for data collection from the environment. |
Long running data collection queries (min) | Enter the time interval used to determine when a running query is blocked. The query is blocked because its execution duration is equal to, or greater than, this interval's threshold. |
Wait time sql data collection interval (min) | Enter the total time interval in minutes to collect or report the value for the wait time SQL attributes. This attribute is valid for SQL instances attributes only. The default wait time SQL data collection time is 5 minutes. |
Where to go from here