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.4.2.1 -r1.4.2.2 --- openacs-4/packages/acs-core-docs/www/maint-performance.adp 2 Mar 2019 19:30:05 -0000 1.4.2.1 +++ openacs-4/packages/acs-core-docs/www/maint-performance.adp 10 Mar 2019 21:47:14 -0000 1.4.2.2 @@ -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 Analysis +

Figure 6.8. Query Analysis example

Query Analysis example

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