Using dbms_stats.auto_sample_size in dbms_stats.

Title: Message To all 9i DBA's. I am trying to find out how efficient (or not ) is the option of running dbms_stats with dbms_stats.auto_sample_size. Reading metalink I see a lot of issues with the time it takesto run, and also that sample_size column is always equal to num_rows. Would

Oracle failsafe and RMAN

reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arnon, Yuval

Pinning packages

Hi My question is to all the 8i dba's. Do you still pin packages in memory. ??? If you do what is the reason for it?? I am referring to both system packages and application packages. TIA Yuval. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arnon, Yuval INET