Oracle can be monitored to prevent performance degradation for Oracle Database data update processing. The following items can be used in Oracle monitoring to prevent degraded performance for data update processing:
The following table lists the records and fields related to data update processing performance.
Table 1-2 Records and fields related to data update processing performance
Record used | Field used | Value measured (example) |
---|---|---|
PI | Cache Hit % | Buffer cache usage. |
Buffer Busy Wait % | Buffer busy wait ratio. | |
Free List Wait Events | Free list wait events. |