Oracle databases manage application data in terabyte size. Application security, stability and performance are heavily dependent on the availability and throughput of simultaneous access to the database instances.

Oracle is a professional RDBMS with corresponding storage units on disks, corresponding processes and memory / cache structures in order to efficiently manage users and their access.

 

System behavior is determined by the settings of more than 300 profile parameters.

 

All of these units have to be permanently monitored and analyzed in order to guarantee safe operation and efficient use of existing resources.

The following attributes are monitored and analyzed in detail:

 

• Oracle database status
• monitoring of all configuration parameters
• segment information and review
• status and filling level of tablespaces and data files
• existence and mirroring of control and data files
• archiving status (“database log mode”, “automatic archival”) and redo log status
• number of client connections by percentage of the number of licensed clients
• detection of user logins with safety-critical login (e.g. system, sys, scott)
• cache quality
• status of rollback segments
• I/O performance on caches and data files
• statistical analysis of transactions, calls, sorts and enqueues
• active sessions

In addition to this, various database values and configurations can be directly displayed in lists.

 

theGuard! ApplicationManager includes pre-configured metrics for the monitoring of Oracle.

• availability, performance and analysis of Oracle systems and applications on Oracle
• capacity planning and control
• storage optimization