Help Docs

Oracle pluggable database monitoring

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].

Related Links

Was this document helpful?

Would you like to help us improve our documents? Tell us what you think we could do better.


We're sorry to hear that you're not satisfied with the document. We'd love to learn what we could do to improve the experience.


Thanks for taking the time to share your feedback. We'll use your feedback to improve our online help resources.

Shortlink has been copied!