Resolving High CPU Usage on Oracle Servers

This case study demonstrates a top-down tuning methodology that was applied to a performance problem involving high CPU usage on a database server.
The diagnostics that were collected and analyzed for this problem include: operating system (OS) data such as vmstat and top; statspack, and trace event 10046 with TKProf output.
The conclusion from analyzing the collected data was that a specific query was consuming most of the CPU and needed to be tuned.

We present various ways of tuning the query as well as verification that the recommended solution solved the problem.

Click Link Below…

Oracle_Server_HighCPU

Enjoy

Advertisements

2 Comments on “Resolving High CPU Usage on Oracle Servers”

  1. Dba Z says:

    Good.. Very good and pragmatic. Thank you Levi!

    Dba Z. (Data Warehouse Oracle DBA Senior)

    Like


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s