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:

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

 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

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

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

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

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

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

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

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

Backups :

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

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

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

Communication Protocols:

• JDBC