1.3.1 Purpose of performance monitoring
Performance monitoring using PFM - Agent for Oracle can be used to perform the following:
-
Analysis of performance data to discover causes of bottlenecks
-
Monitoring to check whether the Oracle server is running properly
During Oracle server operation, specific causes can negatively impact overall Oracle server performance. These causes can include the following:
-
Insufficient buffer cache
-
Insufficient shared pools
-
Insufficient memory for sort operations
-
Increase in the "Search All" ratio
-
Insufficient segment free lists
-
Insufficient disk capacity
-
Occurrence of wait events concerning REDO log file
It is very important to make sure that the Oracle server is running properly. In addition to performance standpoints, monitoring such as the following can be used to check whether an Oracle server is running properly.
-
Oracle instance operation monitoring
Performance monitoring using PFM - Agent for Oracle can be performed to achieve stable operation for Oracle servers.
Note that the performance monitoring method thresholds are for reference only. The actual thresholds need to be determined through baseline measurement.
The actual items set need to be determined based on the type of operation for the Oracle server.