Forum OpenACS Q&A: Oracle: analyzing tables

Collapse
1: Oracle: analyzing tables
Posted by Jade Rubick on 03/27/02 08:18 PM
I should have been reading my "Oracle DBA" book more carefully. It
says that the cost-based optimizer doesn't automatically update the
information upon which it decides what execution plans to run, and
that I should be doing ANALYZE statements periodically.

Hmm, I don't think I have ever run any ANALYZE statements on these
tables and indices!

Fortunately, it includes a script for doing it all automatically.

Perhaps we should include such a script in an appendum to the install
guide?

Collapse
2: Response to Oracle: analyzing tables (response to 1)
Posted by Yonatan Feldman on 03/27/02 08:37 PM
the installation process already creates a dbms_job that analyzes your entire
schema (actually an estimate of it) every day. it uses the dbms_stats
package. i don't believe this has been ported to postgres yet.
Collapse
3: Response to Oracle: analyzing tables (response to 1)
Posted by Jade Rubick on 03/27/02 08:42 PM
How far back does this go? Is this also true for older OpenACS 3 installatons, and ACS 3.x installations?
Collapse
4: Response to Oracle: analyzing tables (response to 1)
Posted by Yonatan Feldman on 03/27/02 08:55 PM
this was included in the original ACS 4 release. as far as i know, it is not in
ACS 3.x