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 -N -r1.1.2.12 -r1.1.2.13 --- openacs-4/packages/acs-core-docs/www/maint-performance.adp 23 Jun 2016 08:32:45 -0000 1.1.2.12 +++ openacs-4/packages/acs-core-docs/www/maint-performance.adp 19 Nov 2016 09:21:54 -0000 1.1.2.13 @@ -1,5 +1,5 @@ -{/doc/acs-core-docs {Documentation}} {Diagnosing Performance Problems} +{/doc/acs-core-docs {ACS Core Documentation}} {Diagnosing Performance Problems} Diagnosing Performance Problems 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

@@ -123,7 +123,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