4 Maximize Performance and Availability

As an IT operations administrator, you can use Oracle IT Analytics to identify enterprise-wide systemic problems that affect the availability and performance of your applications.

Using Oracle IT Analytics, you can:

• Visualize top performance findings and trends across databases and middleware over time.

• Analyze activities of databases or middleware over time across related components or groups to view the effect of shared resources or application workloads.

• Analyze trends of top incoming web requests or SQL statements and their changes over time to detect changes in workload or degradation in response.

If you see a break in the graphs in the applications, then it could be because the entities weren’t functioning during that time period, and so no data was collected. This is applicable to all entities and graphs.

Note:

Oracle IT Analytics retains the raw data (the metric data that is collected and uploaded by agents on the target hosts) for eight days. Before purging the raw data, it rolls up the data into hourly and daily intervals. The rolled up data is then retained for 13 months to provide historical metric information. Data becomes inaccessible at the end of the 13-month period.

Topics:

• Read This Before You Begin

• Maximize Database Performance

• Analyze SQL Performance

• Maximize Application Performance

• Maximize Application Server Performance

• Analyze IT Server and Application Availability