Oracle Database backgroundOracle Database
Oracle Database backgroundOracle Database
Databases
Elastic SearchCassandraMicrosoft SQL ServerOracle DatabaseMariaDBMySQLDB2/ZPostgreSQLDB2HazelcastApache HbaseMongoDBRedis

Oracle Database

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.

Oracle.oveerview.en

Monitoring Oracle database considers the following elements:

General Metrics:

  1. Instance Name
  2. Host Name
  3. Host Operating System
  4. Version
  5. Instance Start Time
  6. Instance Status
  7. Is Clustered?
  8. Archiver State
  9. Number Of Redo Threads
  10. Login Status
  11. Pending Shutdown
  12. Database Status
  13. Instance Role
  14. Database Active State
  15. Data Growth Rate
  16. Database Files Total Size
  17. Database Files Free Size
  18. Database Files Used Percentage
  19. IO Read Rate
  20. IO Write Rate
  21. Blocks Read Rate
  22. Blocks Write Rate
  23. Number Of Active Sessions
  24. Number Of System Sessions
  25. Number Of Inactive Sessions
  26. Buffer Hit Ratio
  27. Data Dictionary Hit Ratio
  28. Library Hit Ratio
  29. SGA Free Memory Space
  30. Buffer Cache Size
  31. Shared Pool Size
  32. Redo Log Buffer Size
  33. Fixed Area Size
  34. Java Pool Size
  35. Large Pool Size
  36. Library Cache Size
  37. Number Of Broken Jobs
  38. Number Of Failed Jobs
  39. Number Of Current Open Cursors
  40. Session Limit Used Percentage
  41. Process Limit Used Percentage
  42. Last Backup Duration Time
  43. Last Backup Status
  44. Last Backup Size
  45. Elapsed Time Since Last Successful Backup
  46. Parse Rate
  47. Execute Rate
  48. Commit Rate
  49. Rollback Rate
  50. Consistent Read Rate
  51. Session Logical Read Rate
  52. Redo Write Rate

Oracle.kpi.en

 PGA Metrics:

  1. PGA Freed Back Memory
  2. Total PGA Freeable Memory
  3. Maximum PGA Allocated Memory
  4. Current PGA Allocated Memory
  5. Total PGA Used Memory
  6. PGA Cache Hit Ratio

Oracle.pga.en

Processes:

  1. List Of Processes
  2. ID
  3. PGA Used Memory
  4. PGA Allocated Memory
  5. PGA Freeable Memory
  6. PGA Maximum Allocated Memory
  7. Program Name
  8. Session ID

Oracle.process.en

Sessions:

  1. List Of Sessions
  2. SID
  3. Status
  4. Host Name
  5. Oracle User Name
  6. Client Host Username
  7. Elapsed Time
  8. CPU Used Time
  9. Memory Sorts
  10. Number Of Table Scans
  11. Physical Reads
  12. Logical Reads
  13. Number Of Commits
  14. Cursor
  15. Buffer Read Hit Ratio
  16. Session Type
  17. Wait State
  18. Wait Time
  19. Seconds In Wait

Oracle.sessions.en

Table Space:

  1. List Of Table Spaces 
  2. Name
  3. Total Space
  4. Total Usable Space
  5. Free Space
  6. Free Space Percentage
  7. Used Space
  8. Used Space Percentage
  9. Total Number Of Blocks
  10. Number Of Usable Blocks
  11. Number Of Free Blocks
  12. Data File Count
  13. Blocks Used Percentage
  14. Table Space Maximum Size
  15. Used Percentage Of Maximum Size
  16. Status
  17. Content Type

Oracle.table Space.en

Data Files:

  1. List Of Data Files
  2. Data File Name
  3. Status
  4. Physical Read Rate
  5. Physical Write Rate
  6. Physical Block Read Rate
  7. Physical Block Write Rate
  8. Single Block Read Rate
  9. Average Read Time
  10. Average Write Time
  11. Average IO Time
  12. Last IO Spent Time
  13. Maximum Single IO Read Time
  14. Maximum Single IO Write Time

Oracle.datafile.en

Locks:

  1. List Of Locks
  2. Session ID
  3. User Name
  4. Lock Mode
  5. Object
  6. Object Type
  7. Lock Type
  8. Serial
  9. Lock ID1
  10. Lock ID 2

Oracle.lock.en

Rollbacks:

  1. List Of Rollbacks
  2. Name
  3. Segment ID
  4. State
  5. Current Size
  6. Initial Extent Size
  7. Secondary Extent Size
  8. Minimum Number Of Extent
  9. Maximum Number Of Extent
  10. High WaterMark Size
  11. Number Of Gets
  12. Number Of Waits
  13. Hit Ratio
  14. Number Of Shrink
  15. Number Of WRAPS
  16. Number Of Extends

Corrupted Blocks:

  1. List Of Blocks
  2. File Name
  3. Block Number Of Corrupt Block
  4. Number Of Corrupted Blocks
  5. Corruption Type

FRA:

  1. List Of Domains 
  2. Name
  3. FRA Maximum Size
  4. Used Space
  5. Number Of Files
  6. Used Percentage

Oracle.rollback.en

Jobs:

  1. List Of Jobs
  2. Job Name
  3. Current State
  4. Last Run Date
  5. Last Run Duration
  6. Next Run Date
  7. Run Count
  8. Failure Count
  9. Retry Count
  10. Enable State
  11. Elapsed Time Since Last Run

Oracle.jobs.en

Backups :

  1. List Of Backups 
  2. Session Key
  3. Type
  4. End Time
  5. Status
  6. Time Taken
  7. File Size
  8. Start Time

Oracle.‌backup.en

Outstanding Alerts:

  1. List Of Alerts
  2. Sequence ID
  3. Object Owner
  4. Object Name
  5. Object Type
  6. Creation Time
  7. Last Update Time
  8. Alert Reason
  9. Suggested Action

Oracle.‌alert.en

Resource Limit :

  1. Name
  2. Resource Used Percentage
  3. Resource Used Value
  4. Resource Limit

Top Queries based on different criteria:

  1. Top Queries in Terms of Average CPU Time
  2. Most Frequently Executed Queries
  3. Top Queries in Terms of Buffer Get Count
  4. Top Queries in Terms of Read from disk
  5. Top Queries in Terms of Write Disk Queries
  6. Top Queries in Terms of Elapsed Time 
  7. Top Queries in Terms of Number of Processed Rows
  8. Top Queries in Terms of Memory Time Usage

Oracle.‌top Query.en

Communication Protocols:

  • JDBC
Databases
Elastic SearchCassandraMicrosoft SQL ServerOracle DatabaseMariaDBMySQLDB2/ZPostgreSQLDB2HazelcastApache HbaseMongoDBRedis
Address
3rd floor, No. 8, 2nd dead-end, Sadeghi St., Azadi Ave., Tehran, Iran, Postal code 1458846155
Behpaya Co. All rights reserved