I still am trying to understand the differences between running Analyze and DBMS_stat in Space Mgr.
According to the manual the analyze does more work and therefore should be gathering more information .
I have always thought that running DBMS_STATS in Space Mgr was the same as running Oracle Statistics... Is that not the case?
Oracle needs statistics for the cost-based optimiser, to get queries to run well.
There is an old way to get statistics, and a new way.
The old way is the ANALYZE SQL command.
The new way is the DBMS_STATS PL/SQL procedure.
Oracle recommends that people use the new way, DBMS_STATS. Any automatic statistics collection that Oracle does with its jobs uses DBMS_STATS. Oracle 10 has the GATHER_STATS_JOB database job, and Oracle 11 has automated maintenance tasks that gather database statistics. In Oracle 10 and Oracle 11, the pre-built jobs / tasks use DBMS_STATS.
The old ANALYZE command gathered information about free space in table blocks, and count of chained rows, something that DBMS_STATS does not do. In Space Manager we get better information from the ANALYZE command, but Oracle tells people to use DBMS_STATS.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center