Oracle Database Monitoring
Usage, availability and health of Oracle databases under continuous observation, so that potential problems are known before they hit the system.
Practical support for DBAs
Oracle is one of the best-known and most widely used database management systems. It belongs to the RDBMS (Relational DataBase Management System) family, the systems based on the relational model, and is used by most business applications: managing it well starts with in-depth performance monitoring.
To support DBAs, Sentinet³ provides the Sentinet³ Oracle Pattern, a comprehensive package of checks that analyses system usage, availability and health. Monitoring is continuous and flags potential problems before they hit the system.
| At a glance | |
|---|---|
| Pattern | Sentinet³ Oracle Pattern |
| Scope | Server, database performance |
The Pattern’s checks
The Pattern includes 19 checks. Each has configurable thresholds and generates a notification when values exceed them.
Server
| Check | What it verifies |
|---|---|
| Reachability | The server responds on the network |
| CPU | Percentage of CPU utilisation |
| Memory | Memory usage |
| Disk | Free disk space |
Database performance
| Check | What it verifies |
|---|---|
| Backup File | Whether backup is active or not |
| Buffer Pool Block Size | Block size of the buffer pool |
| Cpu Parsing | Percentage of CPU spent on parsing |
| Cpu Recursive | Percentage of CPU spent on recursive calls |
| Bg Elapsed Time | Time spent in background processes |
| Free Shared Pool | Free memory in the shared pool |
| Free Sga | Free memory in the System Global Area |
| Ts Size | Free space in the tablespace |
| Ts Status | Tablespace status and its free space |
| UsersList | List of database users |
| User State | Users connected to the database |
| DB Size | Database size |
| Shutdown Pending State | Whether a shutdown is pending |
| Long Query | Whether long-running queries are present |
| Last Analyzed | Date of the last analysis run on the database |
Like having a virtual DBA at your side
- Prevention: continuous monitoring reports potential problems before they hit the system.
- Best practice: the information gathered helps eliminate weak points, improve replication and optimise performance.
Related topics
Want to see Sentinet³ on your infrastructure?
Tell us about your environment: sites, technologies, critical services. We will show you how Core and Infinity can work on your case.