Filter
Top Products
Tablespace IO Stats and File IO Stats
Review the IO Stats area to obtain information about hotspots or drive contention.
Analysis of information such as Buffer Wait and Average Buffer Waits can help you
determine whether you are getting the best performance from your drives, and
identify potential bottlenecks. Separation of objects into their own unique
tablespaces can contribute to performance tuning of specific areas.
Wait Events
The AWR report for Sterling B2B Integrator shows typical wait events as displayed
in the following figure. To see if the wait events are problematic, compare it to a
baseline in your environment. The following figures are an example of what you
can see normally for Sterling B2B Integrator.
The SQL statements that should be inspected are SQL ordered by Gets and SQL
ordered by Reads as shown in the following figure. Again, compare these with the
baseline of the system to determine if any SQL statement is behaving oddly. If yes,
refer to the query plans to determine if the query plan is appropriate.
30 Sterling B2B Integrator: Performance Management