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

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.

See also

The cost of an SQL statement as calculated (estimated) by the optimizer.
System statistics describe I/O and CPU characteristics.
Active Session History
Declaring a PL/SQL function with the pragma udf might improve the function's response time.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758199313, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/adminstration/performance-tuning/index(71): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78