5 Pluggable Database
For each metric, it provides the following information:
-
Description
-
Metric table
The metric table can include some or all of the following: target version, default collection frequency, default warning threshold, default critical threshold, and alert text.
Database Feature Usage
This metric category provides details on database feature usage metrics.
Count
This column stores feature-specific usage data in number format.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The AUX_COUNT column from the CDB_FEATURE_USAGE_STATISTICS view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information about which database features are being used.
Currently Used
Indicates whether usage was detected the last time the system checked (TRUE) or not (FALSE)
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The CURRENTLY_USED column from the CDB_FEATURE_USAGE_STATISTICS view.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information about which database features are being used.
DBID
Database identifier of the database being tracked
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The DBID column from the CDB_FEATURE_USAGE_STATISTICS view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information about which database features are being used.
Detected Usages
Number of times the system has detected usage for the feature
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The DETECTED_USES column from the CDB_FEATURE_USAGE_STATISTICS view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information about which database features are being used.
Feature Info
This column stores feature-specific usage data in character format.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The FEATURE_INFO column from the CDB_FEATURE_USAGE_STATISTICS view.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information about which database features are being used.
Feature Name
Name of the feature
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The NAME column from the CDB_FEATURE_USAGE_STATISTICS view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information about which database features are being used.
First Usage Date
First sample time the system detected usage of the feature
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The FIRST_USAGE_DATE column from the CDB_FEATURE_USAGE_STATISTICS view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information about which database features are being used.
Last Sample Date
Amount of time (in seconds) between the last two usage sample times
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The LAST_SAMPLE_DATE column from the CDB_FEATURE_USAGE_STATISTICS view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information about which database features are being used.
Last Sample Period
Amount of time (in hours) between the last two usage sample times
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The LAST_SAMPLE_PERIOD column from the CDB_FEATURE_USAGE_STATISTICS view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information about which database features are being used.
Last Usage Date
Last sample time the system detected usage of the feature
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The LAST_USAGE_DATE column from the CDB_FEATURE_USAGE_STATISTICS view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information about which database features are being used.
Total Samples
Number of times the system has woken up and checked for feature usage
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The TOTAL_SAMPLES column from the CDB_FEATURE_USAGE_STATISTICS view.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information about which database features are being used.
Version
Database version in which the feature was tracked
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The VERSION column from the CDB_FEATURE_USAGE_STATISTICS view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information about which database features are being used.
Datafiles
This metric category provides details on the datafile metrics.
Autoextensible
Autoextensible indicator.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The AUTOEXTENSIBLE column of the CDB_DATA_FILES view if a permanent datafile or the AUTOEXTENSIBLE column of the CDB_TEMP_FILES view if a temporary file.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Datafile Name
Name of the database file or temporary file.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The FILE_NAME column of the CDB_DATA_FILES view if a permanent datafile. The FILE_NAME column of the CDB_TEMP_FILES view if a temporary file.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
File Size
Size of the file in bytes.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The BYTES column of the CDB_DATA_FILES view if a permanent datafile or the BYTES column of the CDB_TEMP_FILES view if a temporary file.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Initial File Size
Creation size of the file (in bytes)
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The CREATE_BYTES column of the V$DATAFILE view if a permanent datafile or the CREATE_BYTES column of the V$TEMPFILE view if a temporary file.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Increment By
Number of tablespace blocks used as autoextension increment. Block size is contained in the BLOCK_SIZE column of the CDB_TABLESPACES view.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The INCREMENT_BY column of the CDB_DATA_FILES view if a permanent datafile or the INCREMENT_BY column of the CDB_TEMP_FILES view if a temporary file.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Max File Size
Maximum file size in bytes
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The MAXBYTES column of the CDB_DATA_FILES view if a permanent datafile or the MAXBYTES column of the CDB_TEMP_FILES view if a temporary file.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Status
The ONLINE status of the database file (one of SYSOFF, SYSTEM, OFFLINE, ONLINE, RECOVER) or the status of the temporary file (one of OFFLINE, ONLINE, UNKNOWN).
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The ONLINE_STATUS column of the CDB_DATA_FILES view if a permanent datafile or the STATUS column of the CDB_TEMP_FILES view if a temporary file.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Storage Entity
The filesystem or the raw device used by this datafile or temporary file.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
Perl script utility to retrieve the full file path.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Tablespace
Name of the tablespace to which the file belongs
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The TABLESPACE column of the CDB_DATA_FILES view if a permanent datafile or the TABLESPACE column of the CDB_TEMP_FILES view if a temporary file.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Database Job Status
The metrics in this category represent the health of database jobs registered through the DBMS_SCHEDULER interface.
Broken Job Count
The Oracle Server job queue is a database table that stores information about local jobs such as the PL/SQL call to execute for a job such as when to run a job. Database replication is also managed by using the Oracle job queue mechanism using jobs to push deferred transactions to remote master sites, to purge applied transactions from the deferred transaction queue or to refresh snapshot refresh groups.
A job can be broken in two ways:
-
Oracle failed to successfully execute the job after a specified number of attempts (defined in the job).
-
The job is explicitly marked as broken by using the procedure DBMS_JOB.BROKEN.
This metric checks for broken DBMS jobs. A critical alert is generated if the number of broken jobs exceeds the value specified by the threshold argument.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
0 |
Not Defined |
%value% job(s) are broken. |
Failed Job Count
The Oracle Server job queue is a database table that stores information about local jobs such as the PL/SQL call to execute for a job such as when to run a job. Database replication is also managed by using the Oracle job queue mechanism using jobs to push deferred transactions to remote master sites, to purge applied transactions from the deferred transaction queue or to refresh snapshot refresh groups.
If a job returns an error while Oracle is attempting to execute it, the job fails. Oracle repeatedly tries to execute the job doubling the interval of each attempt. If the job fails after a specified number of times (specified in the job definition), Oracle automatically marks the job as broken and no longer tries to execute it.
This metric checks for failed DBMS jobs. An alert is generated if the number of failed job exceeds the value specified by the threshold argument.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
0 |
Not Defined |
%value% job(s) have failed. |
Database Scheduler Jobs
This section provides information on the metrics in the Database Scheduler Jobs category, which report the current status of DBMS jobs registered through the DBMS_SCHEDULER interface. Using these metrics, you can monitor long running jobs and obtain alerts on individual jobs.
Elapsed Running Time (in Minutes)
The duration of time the current DBMS job has been running, in minutes.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
| All versions | Every 5 Minutes | > 5 Minutes | > 30 Minutes | DBMS job %job_name% for %owner% has been running for %value% minutes. |
Failure Count
The number of times the DBMS job has failed during the last collection period.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
| All versions | Every 5 Minutes | > 0 | Not Defined | DBMS job %job_name% for %owner% has failed %value% time(s) during last collection period. |
Database Services
The metrics in this category include the service CPU time and service response time.
Service CPU Time (per user call) (microseconds)
This metric represents the average CPU time, in microseconds, for calls to a particular database service.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
CPU per call for service %keyValue% is %value% microseconds |
Service Response Time (per user call) (microseconds)
This metric represents the average elapsed time, in microseconds, for calls to a particular database service.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Elapsed time per call for service %keyValue% is %value% microseconds |
Datafile Allocation
This section provides information on the metrics in the Datafile Allocation category.
The allocated space is the current size of the datafile. A portion of this allocated space is used to store data while some may be free space. The metrics in this category check the amount of space used and the amount of space allocated to each datafile. The used space can then be compared to the allocated space to determine how much space is unused in the datafile. This metric is not intended for alerts. Rather it is intended for reporting. Historical views of unused allocated free space can help DBAs to correctly size their datafiles, eliminating wasted space.
| Target Version | Evaluation and Collection Frequency |
|---|---|
| All versions | Every 24 hours |
| Metric Name | Description | Data Source |
|---|---|---|
| Allocated File Size (MB) | The space allocated to the datafile. This metric should be used in conjunction with the Used File Size (MB) metric to produce a historical view of the amount of space being used and unused in each datafile. |
|
| Used File Size (MB) | The space used in the datafile. This metric should be used in conjunction with the Allocated File Size (MB) metric to produce a historical view of the amount of space being used and unused in each datafile. |
|
Failed Logins
The metrics in this category check for the number of failed logins on the target database. This check is performed every interval specified by the collection frequency and returns the number of failed logins for the last 30 minutes. These metrics will only work for databases where the audit_trail initialization parameter is set to DB or XML and the session is being audited.
Failed Login Count
This metric checks for the number of failed logins on the target database. This check is performed every interval specified by the collection frequency and returns the number of failed logins for the last 30 minutes. This metric will only work for databases where the audit_trail initialization parameter is set to DB or XML and the session is being audited.
If the failed login count crosses the values specified in the threshold arguments, then a warning or critical alert is generated. Because it is important to know every time a significant number of failed logins occurs on a system, on every collection, this metric determines the number of failed login attempts in the last 30 minutes and overrides the current alert instead of a new alert. You can manually clear these alerts.They will not automatically cleared after the next collection.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 30 Minutes |
150 |
300 |
Number of failed login attempts exceeds threshold value. |
Invalid Objects
This metric category contains the metrics associated with invalid objects.
Total Invalid Object Count
This metric represents the total invalid object count.
This is a database-level metric. For cluster databases, this metric is monitored at the cluster database target level and not by member instances.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined* |
%value% object(s) are invalid in the database. |
Invalid Objects by Schema
This metric category contains the metrics that represent the number of invalid objects in each schema.
Owner's Invalid Object Count
This metric represents the invalid object count by owner.
This is a database-level metric. For cluster databases, this metric is monitored at the cluster database target level and not by member instances.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
%value% object(s) are invalid in the %owner% schema in pluggable database %pdbName% |
Data Source
For each metric index:
SELECT count(1)
User Action
View the status of the database objects in the schema identified by the Invalid Object Owner metric. Recompile objects as necessary.
Messages per buffered queue
The metrics in this category monitor the age and state of the first (top of the queue) message for each buffered queue in the database except for the system queues. Queues that are in the schema of SYS, SYSTEM, DBSNMP, and SYSMAN are defined as system level queues.
Average age of messages per buffered queue (seconds)
This metric provides the average age (in seconds) of the messages in the buffered queue for all nonsystem queues in the database.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Average age of messages in %schema%.%queue_name% queue is %value% seconds. |
Spilled Messages
This metric displays the current number of overflow messages spilled to disk from the buffered queue.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Current number of overflow messages spilled to disk from the buffered queue %schema%.%queue_name% is %value% |
First message age in the buffered queue per queue (seconds)
This metric gives the age (in seconds) of the first message in the buffered queue for all non-system queues in the database.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Age of first message in %schema%.%queue_name% buffered queue is %value% seconds. |
Messages processed per buffered queue (%)
This metric gives the messages processed percentage per minute per buffered queue in the last collection interval of the metric.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Messages processed for queue %schema%.%queue_name% is %value% percent. |
Total Messages Processed per Buffered Queue per Minute
This metric gives the total number of messages processed per minute per buffered queue in the last collection interval of the metric.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Total messages processed per minute in the last interval for queue %schema%.%queue_name% is %value% |
Total messages received per buffered queue per minute
This metric gives the total number of messages received or enqueued into the buffered queue per minute in the last collection interval of the metric.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Total messages processed per minute in the last interval for queue %schema%.%queue_name% is %value% |
Total number of messages processed
This metric gives the total number of messages processed in the last collection interval of the metric.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Messages per buffered queue per subscriber
This metric category monitors the messages for buffered queues per subscriber in the database.
Average age of messages/buffered queue/subscriber (seconds)
This metric display's the average age of messages in the buffered queue per queue in seconds.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Average age of messages for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% seconds. |
First message age in buffered queue per subscriber (seconds)
This metric displays the age of the first message in the buffered queue per queue per subscriber in seconds.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Age of first message for subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% seconds. |
Messages processed/buffered queue/subscriber (%)
This metric gives the messages processed percentage for the buffered queue per subscriber. Messages processed percent is calculated as the percent of the total number messages processed or dequeued to the total number of messages received or enqueued.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Messages processed for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% percent. |
Messages processed/buffered queue/subscriber per minute (%)
This metric gives the total number of messages processed per minute per buffered queue subscriber in the last collection interval of the metric.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Messages processed per minute in the last interval for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value. |
Total messages processed/buffered queue/subscriber per minute
This metric gives the total number of messages processed per minute per buffered queue subscriber in the last collection interval of the metric.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Total messages processed per minute in the last interval for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% |
Total messages received/buffered queue/subscriber per minute
This metric gives the total number of messages received or enqueued into the queue per subscriber per minute in the last collection interval of the metric.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Total messages received per minute in the last interval for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% |
Total number of messages processed
This metric gives the total number of messages processed in the last collection interval of the metric.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Messages per persistent queue
The metrics in this category monitor the age and state of the first (top of the queue) message for each persistent queue in the database except for the system queues. Queues that are in the schema of SYS, SYSTEM, DBSNMP, and SYSMAN are defined as system level queues.
Average age of messages per persistent queue (seconds)
This metric displays the average age of messages in the persistent queue per queue in seconds.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Average age of messages in %schema%.%queue_name% queue is %value% seconds. |
First message age in persistent queue/queue (seconds)
This metric gives the age (in seconds) of the first message in the persistent queue for all non-system queues in the database.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Age of first message in %schema%.%queue_name% queue is %value% seconds. |
Global Database Name
This metric provides the unique global database name.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Messages processed per persistent queue (%)
This metric gives the messages processed percentage for the persistent queue. Messages processed percent is calculated as the percent of the total number messages processed or dequeued to the total number of messages received or enqueued.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Messages processed for queue %schema%.%queue_name% is %value% percent. |
Messages processed per persistent queue per minute (%)
This metric gives the messages processed percentage per minute per persistent queue in the last collection interval of the metric.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Messages processed per minute in the last interval for queue %schema%.%queue_name% is %value% |
Total messages processed per persistent queue per minute
This metric gives the total number of messages processed per minute per persistent queue in the last collection interval of the metric.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Total messages processed per minute in the last interval for queue %schema%.%queue_name% is %value% |
Total messages received per persistent queue per minute
This metric gives the total number of messages received or enqueued into the queue per minute in the last collection interval of the metric.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Total messages received per minute in the last interval for queue %schema%.%queue_name% is %value% |
Total number of messages processed
This metric gives the total number of messages processed in the last collection interval of the metric.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Messages per persistent queue per subscriber
The metrics in this category monitor the age and state of the first (top of the queue) message for each persistent queue per queue subscriber in the database except for the system queues. Queues that are in the schema of SYS, SYSTEM, DBSNMP, and SYSMAN are defined as system level queues.
Average age of messages/persistent queue/subscriber (seconds)
This metric display's the average age of messages in the persistent queue per queue in seconds.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Average age of messages for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% seconds. |
First message age in persistent queue/subscriber (seconds)
This metric gives the age (in seconds) of the first message in the persistent queue per subscriber for all non-system queues in the database.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Age of first message for subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% seconds. |
Global Database Name
This metric provides the unique global database name.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Messages processed/persistent queue/subscriber per minute (%)
This metric gives the messages processed percentage per minute per persistent queue subscriber in the last collection interval of the metric.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Messages processed per minute in the last interval for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% |
Messages processed/persistent queue/subscriber (%)
This metric gives the messages processed percentage for the persistent queue per subscriber. Messages processed percent is calculated as the percent of the total number messages processed or dequeued to the total number of messages received or enqueued.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Messages processed for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value% percent. |
Total messages processed/persistent queue/subscriber per minute (%)
This metric gives the messages processed percentage per minute per persistent queue subscriber in the last collection interval of the metric.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Total messages processed per minute in the last interval for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value%. |
Total messages received/persistent queue/subscriber per minute
This metric gives the total number of messages received or enqueued into the queue per subscriber per minute in the last collection interval of the metric.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
Total messages received per minute in the last interval for the subscriber %subs_name% %subs_address% in %schema%.%queue_name% queue is %value%. |
Total number of messages processed
This metric gives the total number of messages processed in the last collection interval of the metric.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
PDB Mode
This metric category provides the current Open or Restricted mode of a PDB target in a RAC instance. It covers the READ ONLY, READ WRITE, MOUNTED, READ ONLY RESTRICTED, and READ WRITE RESTRICTED modes.
| Target Version | Collection Frequency |
|---|---|
| All versions | Collection is based on the collection schedule of the parent CDB or is triggered when PDB open or close events are received from the RAC instance. |
| Metric Name | Description |
|---|---|
| Any Restricted | Indicates if the PDB is open in restricted modes
(Read Only Restricted or Read Write Restricted). Possible values
are:
Default Warning Threshold: Yes Default Critical Threshold: Not defined Number of Occurrences: 1 Alert Text: Pluggable Database %target% is open in restricted mode on database instance %keyValue%. |
| Mode | Open mode of the PDB. Possible values are:
Default Warning Threshold: MOUNTED Default Critical Threshold: Not defined Number of Occurrences: 1 Alert Text: Pluggable Database %target% is CLOSED (%value%) on database instance %keyValue%. |
| Read Only Restricted | Indicates if the PDB is in Read Only Restricted
mode. Possible values are:
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Number of Occurrences: 1 Alert Text: Pluggable Database %target% is open in read only restricted mode on database instance %keyValue%. |
| Read Write Restricted | Indicates if the PDB is in Read Write Restricted
mode. Possible values are:
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Number of Occurrences: 1 Alert Text: Pluggable Database %target% is open in read write restricted mode on database instance %keyValue%. |
Resource Usage
This metric category provides the resource usage statistics of a PDB.
| Target Version | Evaluation and Collection Frequency |
|---|---|
| 12cR2, 18c, 19c, 20c, 21c | Every 1 hour |
| Metric Name | Description | Unit |
|---|---|---|
| Average Buffer Cache Usage (MB) | Average usage of the buffer cache by the PDB, in
megabytes.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average buffer cache usage by sessions in Pluggable Database on database instance '%inst_name%' has been over the %severity% setting for past %num_of_occur% collection(s). |
Megabytes |
| Average CPU Utilization (%) | Average percentage of the CPU consumed by the consumer group.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average CPU usage on database instance '%inst_name%' has been lower than the %severity% setting for the past %num_of_occur% collection(s). |
Percentage |
| Average Exempted I/O (per second) | Average I/O per second that was exempted from throttling in the PDB. | NA |
| Average I/O Count (per second) | Average I/O operations per second for the PDB.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average I/O operation frequency detected on database instance '%inst_name%' has been lower than the %severity% setting the past %num_of_occur% collection(s). |
NA |
| Average I/O Data Size (MB/s) | Average megabytes of I/O per second for the PDB.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average I/O operation data size detected on database instance '%inst_name%' has been lower than the %severity% setting for the past %num_of_occur% collection(s). |
Megabytes |
| Average I/O Throttle Time (ms) | Average throttle time per I/O operation for the PDB,
in milliseconds.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average throttle length per I/O operation on database instance '%inst_name%' has been over the %severity% setting for past %num_of_occur% collection(s). |
Milliseconds |
| Average Number of Active Parallel Servers | Average number of parallel servers that are actively running as
part of a parallel statement.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average number of actively running parallel servers on database instance '%inst_name%' has been lower than the %severity% setting for past %num_of_occur% collection(s). |
NA |
| Average Number of Parallel Servers Requested | Average number of parallel servers that are requested by queued
parallel statements.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average number of queued parallel server requests on database instance '%inst_name%' has been over the %severity% setting for past %num_of_occur% collection(s). |
NA |
| Average Number of Queued Parallel Statements | Average number of parallel statements that are queued.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average queued parallel statement requests on database instance '%inst_name%' has been over the %severity% setting for past %num_of_occur% collection(s). |
NA |
| Average Number of Running Parallel Statements | Average number of parallel statements that are running.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average active running parallel statement on database instance '%inst_name%' has been lower than the %severity% setting for past %num_of_occur% collection(s). |
NA |
| Average Number of Running Sessions | Average number of sessions in the consumer group that are
currently running.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average number of running sessions on database instance '%inst_name%' has been lower than the %severity% setting for past %num_of_occur% collection(s). |
NA |
| Average Number of Waiting Sessions | Average number of sessions in the consumer group that are waiting
for CPU due to resource management.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average number of waiting sessions on database instance '%inst_name%' has been over the %severity% setting for past %num_of_occur% collection(s). |
NA |
| Average PGA Usage (MB) | Average PGA usage by the PDB, in megabytes.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average PGA usage by sessions in Pluggable Database on database instance '%inst_name%' has been over the %severity% setting for past %num_of_occur% collection(s). |
Megabytes |
| Average SGA Usage (MB) | Average SGA usage by the PDB, in megabytes.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average SGA usage by sessions in Pluggable Database on database instance '%inst_name%' has been over the %severity% setting for past %num_of_occur% collection(s). |
Megabytes |
| Average Shared Pool Usage (MB) | Average usage of the shared pool by the PDB, in
megabytes.
Default Warning Threshold: Not defined Default Critical Threshold: Not defined Alert Text: Average shared pool usage by sessions in Pluggable Database on database instance '%inst_name%' has been over the %severity% setting for past %num_of_occur% collection(s). |
Megabytes |
| Average Exempted I/O Data Size (MB/s) | Average megabytes of I/O executed per second that were exempted from throttling in the current PDB. | Megabytes |
| Buffer Cache Usage (MB) | Buffer cache usage by the PDB, in megabytes. | Megabytes |
| CPU Consumption Time (ms) | Cumulative amount of CPU time consumed by all sessions in the consumer group, in milliseconds. | Milliseconds |
| CPU Count | Total number of CPUs available to the PDB. | NA |
| CPU Utilization Limit (%) | Maximum percentage of CPU that the consumer group can use at any time. | Percentage |
| CPU Wait Time (ms) | Cumulative amount of time that sessions waited for CPU because of resource management. | Milliseconds |
| High Buffer Cache Usage (MB) | Highest usage of the buffer cache by the PDB, in megabytes. | Megabytes |
| High PGA Usage (MB) | Highest usage of the PGA by the PDB, in megabytes. | Megabytes |
| High SGA Usage (MB) | Highest usage of the SGA by the PDB, in megabytes. | Megabytes |
| High Shared Pool Usage (MB) | Highest usage of the shared pool by the PDB, in megabytes. | Megabytes |
| Low Buffer Cache Usage (MB) | Lowest usage of the buffer cache by the PDB, in megabytes. | Megabytes |
| Low PGA Usage (MB) | Lowest usage of the PGA by the PDB, in megabytes. | Megabytes |
| Low SGA Usage (MB) | Lowest usage of the SGA by the PDB, in megabytes. | Megabytes |
| Low Shared Pool Usage (MB) | Lowest usage of the shared pool by the PDB, in megabytes. | Megabytes |
| Parallel Servers Limit | Number of parallel servers that can be used by this consumer group. | NA |
| PGA Usage (MB) | PGA usage by the PDB, in megabytes. | Megabytes |
| Running Sessions Limit | Maximum number of sessions in the consumer group that can run simultaneously. | NA |
| SGA Usage (MB) | SGA usage by the PDB, in megabytes. | Megabytes |
| Shared Pool Usage (MB) | Usage of the shared pool by the PDB, in megabytes. | Megabytes |
Response
This metric category represent the responsiveness of the Oracle Server, with respect to a client. For PDB, it is also indicative of the state of the PDB. For example, an Open state maps to Up and a Closed/Mounted state maps to Down. If the PDB target exists but the PDB has been dropped/unplugged from the CDB, the target will be in Metric Collection Error.
State
This metric represents the state of the pluggable database.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 5 Minutes |
MOUNTED |
DOWN¦UNKNOWN* |
The database status is %value%. |
User Action
Check the listener configured for the CDB to make sure it is running and serves the CDB. If listener is fine, check if the PDB is in the mount/closed state and open the PDB.
Status
This metric checks whether a new connection can be established to a database. If the maximum number of users is exceeded or the listener is down, this test is triggered.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 5 Minutes |
Not Defined |
0 |
Failed to connect to database instance: %oraerr%. |
User Action
Check the listener configured for the CDB to make sure it is running and serves the CDB. If listener is fine, check if the PDB is in the mount/closed state and open the PDB.
ORA- Error
This is a user-readable message, including any Ora-error, encountered during response evaluation.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 5 Minutes |
User Action
Check the listener configured for the CDB to make sure it is running and serves the CDB. If listener is fine, check if the PDB is in the mount/closed state and open the PDB.
Rollback Segments
This metric category provides the rollback metrics.
Name
Name of the rollback segment
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The SEGMENT_NAME column from the CDB_ROLLBACK_SEGS view.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Aveactive
Current size of active extents, averaged over time.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The AVEACTIVE column from the V$ROLLSTAT view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Aveshrink
Average shrink size
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The AVESHRINK column from the V$ROLLSTAT view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Extents
Number of extents in the rollback segment
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The EXTENTS column from the V$ROLLSTAT view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Hwmsize
High watermark of the rollback segment size
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The HWMSIZE column from the V$ROLLSTAT view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Initial Size
Initial extent size in bytes
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The INITIAL_EXTENT column from the CDB_ROLLBACK_SEGS view.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Maximum Size
Maximum number of extents
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The MAX_EXTENTS column from the CDB_ROLLBACK_SEGS view.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Minimum Extents
Minimum number of extents
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The MIN_EXTENTS column from the CDB_ROLLBACK_SEGS view.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Next Size
Secondary extent size in bytes
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The NEXT_EXTENT column from the CDB_ROLLBACK_SEGS view.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Optsize
Optimal size of the rollback segment
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The OPTSIZE column from the V$ROLLSTAT view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Pct Increase
Percent increase for extent size
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The PCT_INCREASE column from the CDB_ROLLBACK_SEGS view.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Size
Size (in bytes) of the rollback segment.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The RSSIZE column from the V$ROLLSTAT view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Shrinks
Number of times the size of a rollback segment decreases
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The SHRINKS column from the V$ROLLSTAT view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Status
The status of the rollback segment (one of OFFLINE, ONLINE, NEEDS RECOVERY, PARTLY AVAILABLE, UNDEFINED).
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The STATUS column from the CDB_ROLLBACK_SEGS view.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Tablespace Name
Name of the tablespace containing the rollback segment
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The TABLESPACE_NAME column from the CDB_ROLLBACK_SEGS view.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Wraps
Number of times the rollback segment is wrapped
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The WRAPS column from the V$ROLLSTAT view
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Segment Advisor Recommendations
This metric category provides segment advisor recommendations. Oracle uses the Automatic Segment Advisor job to detect segment issues regularly within maintenance windows. It determines whether the segments have unused space that can be released. The Number of recommendations is the number of segments that have Reclaimable Space. The recommendations come from all runs of the automatic segment advisor job and any user-scheduled segment advisor jobs.
Number of recommendations
Oracle uses the Automatic Segment Advisor job to detect segment issues regularly within maintenance windows. It determines whether the segments have unused space that can be released. The Number of recommendations is the number of segments that have Reclaimable Space. The recommendations come from all runs of the automatic segment advisor job and any user-scheduled segment advisor jobs.
This is a database-level metric. For cluster databases, this metric is monitored at the cluster database target level and not by member instances.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 60 Minutes |
Shard Apply Lag
The metrics in this category provide information regarding the shard replication apply coordinator process and replication unit apply lag.
| Target Version | Evaluation and Collection Frequency |
|---|---|
| 23ai and later | Every 15 minutes |
Note that the collection for this metric is disabled by default and you can either enable it on the metric page or by creating a custom monitoring template. For information on monitoring templates, see Monitoring Templates in Oracle Enterprise Manager Monitoring Guide.
| Metric Name | Description | Unit |
|---|---|---|
| Apply Coordinator Process Name | Name of the apply coordinator process for the shard. | None |
| Apply Coordinator Process State | State of the apply coordinator process for the shard.
Possible values are:
|
None |
| Apply Time | Time at which the Logical Change Record (LCR) with the highest log index was recorded. | None |
| High Watermark LCR Log Index | LCR with the highest commit log index, which means that no LCR with a higher commit log index has been applied. | None |
| Last Processed Logical Change Record (LCR) Log Index | LCR log index last processed by the apply coordinator. | None |
| Message Creation Time | Time when the LCRs corresponding to the high watermark were created. | None |
| Shard Apply Lag (sec) | Replication unit apply lag (in seconds) for the shard. | Seconds |
Shard Replication Units
The metrics in this category provide details of the replication units in the shard.
| Target Version | Evaluation and Collection Frequency |
|---|---|
| 23ai and later | Every 15 minutes |
Note that the collection for this metric is disabled by default and you can either enable it on the metric page or by creating a custom monitoring template. For information on monitoring templates, see Monitoring Templates in Oracle Enterprise Manager Monitoring Guide.
| Metric Name | Description | Unit |
|---|---|---|
| Leader ID | Leader's SHARD_ID for the
corresponding replication unit.
|
None |
| Leader Shard | Name of the leader shard of the corresponding replication unit. | None |
| Replication Unit Ready | Indicates that the replication unit is open for workload. | None |
| Replication Unit Recovery Time | Time taken for recovery in the shard. | Seconds |
| Replication Unit Role | Role of the shard for the replication unit. Possible
values are:
|
None |
| Replication Unit Role Change Time | Time when the role for a replication unit in a shard was changed. | None |
| Replication Unit Role Changed | Indicates whether the replication unit role changed in the shard since the last metric collection. If the role has changed, the value denotes the new role, otherwise, the value is "Unchanged". | None |
| Role Change Duration | Time taken (in seconds) to switch the role of a replication unit. | Seconds |
| Role Change Elapsed Time | Time taken for the role change to complete. The purpose of this metric is to generate an alert if the role of the replication unit has changed, along with the Role Change Duration metric value (time taken to switch the role). | Seconds |
Shard Transport Lag
The metrics in this category provide information regarding the shard replication transport lag.
| Target Version | Evaluation and Collection Frequency |
|---|---|
| 23ai and later | Every 15 minutes |
Note that the collection for this metric is disabled by default and you can either enable it on the metric page or by creating a custom monitoring template. For information on monitoring templates, see Monitoring Templates in Oracle Enterprise Manager Monitoring Guide.
| Metric Name | Description | Unit |
|---|---|---|
| Flow Controlled Followers | Shard ID of the flow controlled followers shard. | None |
| Follower Shard Database Name | Name of the follower shard database. | None |
| LCR Producer Startup Time | Start time of the Logical Change Record (LCR) producer process. | None |
| LCR Producer State | State of the LCR producer in the shard. | None |
| LCR Propagation Time | Time taken (in seconds) to propagate the last LCR. | Seconds |
| Network Sender Connection Errors Count | Number of network sender connection errors. | Count |
| Network Sender Startup Time | Start time of the network sender process. | None |
| Network Sender State | State of the network sender. | None |
| Transport Lag (# log indexes) | Transport lag of the follower replication unit in the number of log indexes. | None |
| Transport Lag (sec) | Replication unit transport lag (in seconds) for the follower shard. | Seconds |
Tablespaces
This metric category provides details on the tablespace metrics.
Allocation Type
Type of extent allocation in effect for the tablespace (one of SYSTEM, UNIFORM, USER).
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The ALLOCATION_TYPE column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Big File
Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO).
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The BIGFILE column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Block Size
Tablespace block size.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The BLOCK_SIZE column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Extent Management
Indicates whether the extents in the tablespace are dictionary managed (DICTIONARY) or locally managed (LOCAL).
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The EXTENT_MANAGEMENT column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Increment By
Default percent increase for extent size.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The PCT_INCREASE column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Initial Ext Size
Default initial extent size.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The INITIAL_EXTENT column from CDB_TABLESPACES
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Logging
Default logging (one of LOGGING, NOLOGGING).
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The LOGGING column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Max Extents
Default maximum number of extents
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The MAX_EXTENTS column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Minimum Extent Size
Minimum extent size for this tablespace.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The MIN_EXTLEN column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Minimum Extents
Default minimum number of extents.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The MIN_EXTENTS column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Next Extent
Default incremental extent size.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The NEXT_EXTENT column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Segment Space Management
Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO).
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The SEGMENT_SPACE_MANAGEMENT column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Size
Allocated size in bytes of the tablespace.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
Sum of BYTES column from CDB_DATA_FILES for permanent and undo tablespaces or the sum of BYTES column from CDB_TEMP_FILES for temporary tablespaces.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Status
Tablespace status (one of ONLINE, OFFLINE, READ ONLY).
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The STATUS column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Tablespace Name
Name of the tablespace.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The TABLESPACE_NAME column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Type
One of UNDO, PERMANENT or TEMPORARY.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
The CONTENTS column from CDB_TABLESPACES.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Used Size(B)
Size in bytes of the used space of the tablespace.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
Sum of BYTES column from CDB_DATA_FILES minus the sum of BYTES from CDB_FREE_SPACE for permanent and undo tablespaces or the sum of USED_BLOCKS FROM GV$SORT_SEGMENT times BLOCK_SIZE from CDB_TABLESPACES for temporary tablespaces.
User Action
This is a configuration metric so this column is purely informative and collected to provide DBAs with information necessary to manage the current database.
Tablespace Used Space (MB)
This metric calculates the space used for each tablespace. It is not intended to generate alerts. Rather it should be used in conjunction with the Tablespace Allocated Space (MB) metric to produce a historical view of the amount of space being used and unused by each tablespace.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
Tablespace Used Space (MB) is Tablespace Allocated Space (MB)� Tablespace Allocated Free Space (MB) where:
Tablespace Allocated Space (MB) is calculated by looping through the tablespace�s data files and totaling the size of the data files.
Tablespace Allocated Free Space (MB) is calculated by looping through the tablespace�s data files and totaling the size of the free space in each data file.
Tablespace Allocation
The metrics in this metric category check the amount of space used and the amount of space allocated to each tablespace. The used space can then be compared to the allocated space to determine how much space is unused in the tablespace. This metric is intended for reporting, rather than alerts. Historical views of unused allocated free space can help DBAs to correctly size their tablespaces, eliminating wasted space.
Tablespace Allocated Space (MB)
The allocated space of a tablespace is the sum of the current size of its data files. A portion of this allocated space is used to store data while some may be free space. If segments are added to a tablespace, or if existing segments grow, they will use the allocated free space. The allocated free space is only available to segments within the tablespace. If, over time, the segments within a tablespace are not using this free space, the allocated free space is not being used.
This metric calculates the space allocated for each tablespace. It is not intended to generate alerts. Rather it should be used in conjunction with the Allocated Space Used (MB) metric to produce a historical view of the amount of space being used and unused by each tablespace.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Data Source
Tablespace Allocated Space (MB) is calculated by looping though the tablespace�s data files and totalling the size of the data files.
Tablespace Used Space (MB)
The allocated space of a tablespace is the sum of the current size of its datafiles. Some of this allocated space is used to store data and some of it may be free space. If segments are added to a tablespace, or if existing segments grow, they will use the allocated free space. The allocated free space is only available to segments within the tablespace. If, over time, the segments within a tablespace are not using this free space, then the allocated free space is being wasted.
This metric calculates the space used for each tablespace. It is not intended to generate alerts. Use in conjunction with the Tablespace Allocated Space (MB) metric to produce a historical view of the amount of space being used and unused by each tablespace.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 24 Hours |
Tablespaces Full
The metrics in this metric category check for the amount of space used by each tablespace. The used space is then compared to the available free space to determine tablespace fullness. The available free space accounts for the maximum data file size as well as available disk space. This means that a tablespace will not be flagged as full if data files can extend and there is enough disk space available for them to extend.
Tablespace Free Space (MB)
As segments within a tablespace grow, the available free space decreases. If there is no longer any available free space, meaning data files reached their maximum size or there is no more disk space, then the creation of new segments or the extension of existing segments will fail.
This metric checks for the total available free space in each tablespace. This metric is intended for larger tablespaces, where the Available Space Used (%) metric is less meaningful. If the available free space falls below the size specified in the threshold arguments, then a warning or critical alert is generated.
If the version of the monitored database target is Oracle Database 10g Release 1 or later and the tablespace uses Local Extent Management, then the Oracle Database Server evaluates this metric internally every 10 minutes. Alternatively, if the version of the monitored Database target is Oracle 9i or earlier, or the tablespace uses Dictionary Extent Management, then the Oracle Management Agent tests the value of this metric every 30 minutes.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 30 Minutes |
Not Defined |
Not Defined |
Tablespace [%name%] only has [%value% megabytes] free space. |
Data Source
MaximumSize Total Used Space where:
-
TotalUsedSpace: Total used space in MB of tablespace
-
MaximumSize: Maximum size (in MB) of the tablespace. The maximum size is determined by looping through the tablespaces data files, as well as additional free space on the disk that would be available for the tablespace should a data file autoextend.
User Action
Perform one of the following:
-
Increase the size of the tablespace by: Enabling automatic extension for one of its existing data files, manually resizing one of its existing data files, or adding a new data file.
-
If the tablespace is suffering from tablespace free space fragmentation problems, consider reorganizing the entire tablespace.
-
Relocate segments to another tablespace, thereby increasing the free space in this tablespace.
-
Run the Segment Advisor on the tablespace.
Tablespace Space Used (%)
As segments within a tablespace grow, the available free space decreases. If there is no longer any available free space, meaning data files have reached their maximum size or there is no more disk space, then the creation of new segments or the extension of existing segments will fail.
This metric checks the Available Space Used (%) for each tablespace. If the percentage of used space is greater than the values specified in the threshold arguments, then a warning or critical alert is generated.
If the version of the monitored database target is Oracle Database 10g Release 1 or later and the tablespace uses Local Extent Management, then the Oracle Database Server evaluates this metric internally every 10 minutes. Alternatively, if the version of the monitored Database target is Oracle 9i or earlier, or the tablespace uses Dictionary Extent Management, then the Oracle Management Agent tests the value of this metric every 30 minutes.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 30 Minutes |
85 |
97 |
Tablespace [%name%] is [%value% percent] full |
Data Source
(TotalUsedSpace / MaximumSize) * 100 where:
-
TotalUsedSpace: total used space in MB of tablespace
-
MaximumSize: Maximum size (in MB) of the tablespace. The maximum size is determined by looping through the tablespace�s data files, as well as additional free space on the disk that would be available for the tablespace should a data file autoextend.
For additional information about the data source, refer to the fullTbsp.pl Perl script located in the sysman/admin/scripts directory.
User Action
Perform one of the following:
-
Increase the size of the tablespace by: Enabling automatic extension for one of its existing data files, manually resizing one of its existing data files, or adding a new data file.
-
If the tablespace is suffering from tablespace free space fragmentation problems, consider reorganizing the entire tablespace.
-
Relocate segments to another tablespace, thus increasing the free space in this tablespace.
-
Run the Segment Advisor on the tablespace.
Tablespaces Full (Temp)
The metrics in this category check for the amount of space used by each locally managed temporary tablespace. The used space is then compared to the available free space to determine tablespace fullness. The available free space takes into account the maximum data file size as well as available disk space. This means that a tablespace will not be flagged as full if data files can extend and there is enough disk space available for them to extend.
Tablespace Free Space (MB) (Temp)
As segments within a tablespace grow, the available free space decreases. If there is no more free space available, that is, the data files have hit their maximum size or there is no more disk space, then the creation of new segments or the extension of existing segments will fail.
This metric checks for the total available free space in each temporary tablespace. This metric is intended for larger temporary tablespaces, where the Available Space Used (%) metric is less meaningful. If the available free space falls below the size specified in the threshold arguments, then a warning or critical alert is generated.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 30 Minutes |
Not Defined |
Not Defined |
Tablespace [%name%] has [%value% mbytes] free |
Tablespace Space Used (%) (Temp)
As segments within a tablespace grow, the available free space decreases. If there is no more free space available, that is, the data files have hit their maximum size or there is no more disk space, then the creation of new segments or the extension of existing segments will fail.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 30 Minutes |
Not Defined |
Not Defined |
Tablespace [%name%] is [%value% percent] full |
Temporary File Status
This metric category provides the temporary file status metrics.
File Name
The name of the temporary file.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 15 Minutes |
Data Source
The NAME column of the V$TEMPFILE view.
User Action
This information is purely Informative.
Status
The status of the temporary file, either ONLINE or OFFLINE.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 15 Minutes |
OFFLINE |
Not Defined |
The temporary file %NAME% in pluggable database %pdbName% is %STATUS%. |
Data Source
The STATUS column of the V$TEMPFILE view.
User Action
If the default settings are still in use, an offline temporary file will generate an incident (alert). Determine whether this file is expected to be offline and if not, switch it back online. Also, if this file is expected to be offline, ensure that the temporary tablespace it belongs to has other available online temporary files.
Temporary File Id
The absolute file number of the temporary file, used to join with other database tables and views to retrieve additional information.
| Target Version | Collection Frequency |
|---|---|
|
All Versions |
Every 15 Minutes |
Data Source
The FILE# column of the V$TEMPFILE view.
User Action
This information is purely informative.
Total Objects by Schema
The metrics in this category contain the metric that provides the number of database objects in a schema.
Total Object Count
This metric displays the total number of database objects in a schema.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
%value% object(s) exist in the %owner% schema. |
Total Tables by Schema
The metrics in this category contain the metric that provides the number of tables in a schema.
Wait Count
This metric category contains the metrics that approximate the percentage of time spent waiting by user sessions.
Active Sessions: CPU
This metric represents the active sessions using CPU.
| Target Version | Collection Frequency |
|---|---|
|
All versions |
Every 15 Minutes |
Active Sessions: I/O
This metric represents the active sessions waiting for I/O.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All versions |
Every 10 Minutes |
Not Defined |
Not Defined |
The Management Agent generates the alert text.Foot 1 |
Footnote 1
For releases earlier than Oracle Database plug-in release 12.1.0.6, the Database Server generates this alert text.
Active Sessions: Other
This metric represents all the waits that are neither idle nor user I/O.
| Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
All versions |
Every 10 Minutes |
Not Defined |
Not Defined |
The Management Agent generates the alert text.Foot 2 |
Footnote 2
For releases earlier than Oracle Database plug-in release 12.1.0.6, the Database Server generates this alert text.