Filter
Top Products
BEGIN
DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings(
retention => 43200, -- Minutes (= 30 Days).
Current value retained if NULL.
interval => 30); -- Minutes. Current value retained if NULL.
END;
/
A typical Sterling B2B Integrator deployment contains characteristics of both
interactive and batch data processing systems, including a high volume of small
transactions that rapidly update the database and periodic long-running
transactions that touch many records.
The key areas to inspect in an AWR report are:
v Top SQL (by CPU or I/O)
v Top wait events
v Buffer cache hit ratio (refer to the topic "Instance Efficiency Percentages")
v I/O contention (hot spots) on disks (refer to the topic " Tablespace IO Stats and
File IO Stats")
Instance Efficiency Percentages
When viewing the Instance Efficiency Percentages area, focus on Buffer Hit % and
Buffer Nowait % as shown in the following figure. These are the key performance
indicators on the Oracle database server. The goal is to keep these values at 95% or
greater, which can typically increase efficiency by increasing buffer cache available
to the DB server.
Note: When Sterling B2B Integrator performs internal maintenance, these values
may be affected.
The following figure shows the buffer pool statistics.
Performance Management 29