Site24x7 Oracle pluggable database monitoring offers real-time performance tracking, instant alerts, and auto-discovery for each of your Oracle pluggable databases (PDBs). Ensure high availability and optimal performance with customizable alerts.
Get real-time insights into critical performance indicators like active and inactive sessions, database size, used and available percentage, transaction details, and so on to manage and optimize your Oracle database instances effectively.
Supported Oracle flavors
Oracle version 12c and above
Supported database metrics
Overview
Metric name
Description
Unit
Total Sessions
The total number of sessions
Count
Total Number of Transactions (User Commits)
The total number of transactions (user commits)
Count
Total Number of Transactions (User Rollbacks)
The total number of transactions (user rollbacks)
Count
Total Number Of Transactions
The total number of transactions (user commits + user rollbacks)
Count
Total (Size)
The total size of the database
KB, MB, or GB
Used (Size)
The used size of the database
KB, MB, or GB
Available (Size)
The available size of the database
KB, MB, or GB
Active Session
The number of active sessions
Count
Inactive Session
The number of inactive sessions
Count
Tablespace Count
The total number of tablespaces
Count
Available Percentage
The percentage of the database that's available (available size/total size)*100
Percentage
Used Percentage
The percentage of the database that's used (used size/total size)*100
Percentage
Performance
Metric name
Description
Unit
SQL*Net Received Rate
The amount of bytes received via SQL*Net from the client
KB, MB, or GB
SQL*Net Sent Rate
The amount of bytes sent via SQL*Net to the client
KB, MB, or GB
Invalid Objects Count
The number of unused or invalid objects
Count
Unused Indexes Count
The number of unused or invalid indexes
Count
Session Logical Reads
The number of logical reads done in a session
Count
Total Number of Blocking Sessions
The total number of blocking sessions
Count
Tablespace
Metric name
Description
Unit
Status
The status of the tablespace: possible values are ONLINE, OFFLINE, and READ ONLY
Text
Name
The name of the tablespace
Text
Total Size
The total size of the tablespace
KB, MB, or GB
Used Size
The size of used space of the tablespace
KB, MB, or GB
Free Size
The size of free space in the tablespace
KB, MB, or GB
Used Percentage
The percentage of tablespace used (used size/total size)*100
Percentage
Free Percentage
The percentage of space available in the tablespace
Percentage
Configurations
Metric name
Description
Unit
Container ID
The ID of the container
Number
Name
The name of the container
Text
Block Size
The current block size of the PDB
Bytes
Snapshot Parent Container ID
This shows the container ID of the master PDB that this PDB is a snapshot clone of
Number
Application Root
This indicates whether the PDB is an application root
Text
Application PDB
This indicates whether the PDB is an application PDB
Text
Application Seed
This indicates whether the PDB is an application seed (an application seed is also an application PDB)
Text
Application Root Container ID
If this PDB is an application PDB, this value indicates the container ID of an application root to which this application PDB belongs
Number
Application Root Clone
This indicates whether this PDB is an application root clone
Text
Proxy PDB
This indicates whether this PDB is a proxy PDB (YES) or not (NO)
Text
Creation Time
The date and time at which the PDB was created
Time
Licensing
Each Oracle Database instance consumes one Advanced monitor license and includes monitoring for 25 PDBs. For each additional PDB, one Basic monitor license will be consumed. For now, each Oracle instance and each PDB can include monitoring of up to 10 Tablespaces. For more information, contact [email protected].
