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.14 -r1.1.2.15 --- openacs-4/packages/acs-core-docs/www/maint-performance.adp 6 Jan 2017 09:18:42 -0000 1.1.2.14 +++ openacs-4/packages/acs-core-docs/www/maint-performance.adp 2 Jun 2017 11:12:57 -0000 1.1.2.15 @@ -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