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.24 -r1.1.2.25 --- openacs-4/packages/acs-core-docs/www/maint-performance.adp 20 Jun 2017 07:16:41 -0000 1.1.2.24 +++ openacs-4/packages/acs-core-docs/www/maint-performance.adp 6 Aug 2017 11:31:21 -0000 1.1.2.25 @@ -32,7 +32,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

@@ -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