Search notes:

Oracle Performance and tuning

A database has a performance problem if it is not able to complete and deliver the requested tasks or specified workload in timely fashion, that is, if the answer times put the stakes of an organization at risk.

Throughput

Throughput is the amount of work that can be done in a specific amount of time.

Typical causes of performance problems

Typical problems are

CPU bottlenecks
Too little memory (see memory management)
Too little I/O capacity
Inefficient SQL statements
Too many sessions requesting to change the same object (Concurrency and contention)
Bad database configuration

Tuning

Tuning aims at improving response time, usually by increasing throughput.

Automatic Workload Repository

One essential and indispensable treasure of information that is needed to tune a database is found in the Automatic Workload Repository.

Oracle Performance and tuning

Throughput

Typical causes of performance problems

Tuning

Automatic Workload Repository

See also