Index: openacs-4/packages/acs-core-docs/www/maint-performance.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/maint-performance.adp,v diff -u -r1.1.2.10 -r1.1.2.11 --- openacs-4/packages/acs-core-docs/www/maint-performance.adp 11 Jun 2016 08:44:02 -0000 1.1.2.10 +++ openacs-4/packages/acs-core-docs/www/maint-performance.adp 21 Jun 2016 07:44:36 -0000 1.1.2.11 @@ -31,7 +31,7 @@

This should return a list of database queries on the page, including the exact query (so it can be cut-paste into psql or oracle) and the time each query took.

-

Figure 6.8. Query +

Figure 6.8. Query Analysis example

Query Analysis example

@@ -122,7 +122,7 @@ query, install "autotrace". I usually follow the instructions here http://asktom.oracle.com/~tkyte/article1/autotrace.html.

-Make sure, that the Oracle CBO works with +Make sure, that the Oracle CBO works with adequate statistics

The Oracle Cost Based optimizer is a piece of software that tries to find the "optimal" execution plan for a given SQL statement. For that it estimates the costs of running a SQL query