/Oracle Database
Databases
Oracle Database Monitoring
Integrated operations monitoring system, Moein, is a monitoring system whose service area expands to all layers of Information Technology (IT). As databases are among the most widely used service systems in IT domain, one side of Moein focuses on the monitoring of this type of application-level products. Monitoring Oracle database as one of the databases commonly used in the organization and medium scale is fully supported by Moein. Success ratio of buffer, dictionary, and library, SGA- and PGA-related indicators, processes, sessions, tablespaces, data files, locks, rollbacks, jobs, backups, and top queries are some of the key parameters that are monitored and reported to the system administrator.
Monitoring Oracle database considers the following elements:
General Metrics:
- Instance Name
- Host Name
- Host Operating System
- Version
- Instance Start Time
- Instance Status
- Is Clustered?
- Archiver State
- Number Of Redo Threads
- Login Status
- Pending Shutdown
- Database Status
- Instance Role
- Database Active State
- Data Growth Rate
- Database Files Total Size
- Database Files Free Size
- Database Files Used Percentage
- IO Read Rate
- IO Write Rate
- Blocks Read Rate
- Blocks Write Rate
- Number Of Active Sessions
- Number Of System Sessions
- Number Of Inactive Sessions
- Buffer Hit Ratio
- Data Dictionary Hit Ratio
- Library Hit Ratio
- SGA Free Memory Space
- Buffer Cache Size
- Shared Pool Size
- Redo Log Buffer Size
- Fixed Area Size
- Java Pool Size
- Large Pool Size
- Library Cache Size
- Number Of Broken Jobs
- Number Of Failed Jobs
- Number Of Current Open Cursors
- Session Limit Used Percentage
- Process Limit Used Percentage
- Last Backup Duration Time
- Last Backup Status
- Last Backup Size
- Elapsed Time Since Last Successful Backup
- Parse Rate
- Execute Rate
- Commit Rate
- Rollback Rate
- Consistent Read Rate
- Session Logical Read Rate
- Redo Write Rate
PGA Metrics:
- PGA Freed Back Memory
- Total PGA Freeable Memory
- Maximum PGA Allocated Memory
- Current PGA Allocated Memory
- Total PGA Used Memory
- PGA Cache Hit Ratio
Processes:
- List Of Processes
- ID
- PGA Used Memory
- PGA Allocated Memory
- PGA Freeable Memory
- PGA Maximum Allocated Memory
- Program Name
- Session ID
Sessions:
- List Of Sessions
- SID
- Status
- Host Name
- Oracle User Name
- Client Host Username
- Elapsed Time
- CPU Used Time
- Memory Sorts
- Number Of Table Scans
- Physical Reads
- Logical Reads
- Number Of Commits
- Cursor
- Buffer Read Hit Ratio
- Session Type
- Wait State
- Wait Time
- Seconds In Wait
Table Space:
- List Of Table Spaces
- Name
- Total Space
- Total Usable Space
- Free Space
- Free Space Percentage
- Used Space
- Used Space Percentage
- Total Number Of Blocks
- Number Of Usable Blocks
- Number Of Free Blocks
- Data File Count
- Blocks Used Percentage
- Table Space Maximum Size
- Used Percentage Of Maximum Size
- Status
- Content Type
Data Files:
- List Of Data Files
- Data File Name
- Status
- Physical Read Rate
- Physical Write Rate
- Physical Block Read Rate
- Physical Block Write Rate
- Single Block Read Rate
- Average Read Time
- Average Write Time
- Average IO Time
- Last IO Spent Time
- Maximum Single IO Read Time
- Maximum Single IO Write Time
Locks:
- List Of Locks
- Session ID
- User Name
- Lock Mode
- Object
- Object Type
- Lock Type
- Serial
- Lock ID1
- Lock ID 2
Rollbacks:
- List Of Rollbacks
- Name
- Segment ID
- State
- Current Size
- Initial Extent Size
- Secondary Extent Size
- Minimum Number Of Extent
- Maximum Number Of Extent
- High WaterMark Size
- Number Of Gets
- Number Of Waits
- Hit Ratio
- Number Of Shrink
- Number Of WRAPS
- Number Of Extends
Corrupted Blocks:
- List Of Blocks
- File Name
- Block Number Of Corrupt Block
- Number Of Corrupted Blocks
- Corruption Type
FRA:
- List Of Domains
- Name
- FRA Maximum Size
- Used Space
- Number Of Files
- Used Percentage
Jobs:
- List Of Jobs
- Job Name
- Current State
- Last Run Date
- Last Run Duration
- Next Run Date
- Run Count
- Failure Count
- Retry Count
- Enable State
- Elapsed Time Since Last Run
Backups:
- List Of Backups
- Session Key
- Type
- End Time
- Status
- Time Taken
- File Size
- Start Time
Outstanding Alerts:
- List Of Alerts
- Sequence ID
- Object Owner
- Object Name
- Object Type
- Creation Time
- Last Update Time
- Alert Reason
- Suggested Action
Resource Limit:
- Name
- Resource Used Percentage
- Resource Used Value
- Resource Limit
Top Queries based on different criteria:
- Top Queries in Terms of Average CPU Time
- Most Frequently Executed Queries
- Top Queries in Terms of Buffer Get Count
- Top Queries in Terms of Read from disk
- Top Queries in Terms of Write Disk Queries
- Top Queries in Terms of Elapsed Time
- Top Queries in Terms of Number of Processed Rows
- Top Queries in Terms of Memory Time Usage
Communication Protocols:
- JDBC
Databases
Behpaya Co. All rights reserved