Forum .LRN Q&A: Re: Help Needed in Setting up .LRN to Scale

Posted by Joel Aufrecht on
I'm pasting in some emails so that everything is online:

Here's one thing that makes a big difference.  We're regularly analyzing our
tables using the acs-monitoring package.  Also, just after doing a new import, I
always analyze the entire schema using

SQL> exec dbms_stats.gather_schema_stats('DBUSER',cascade => true);