Re: freelists and dba_free_space

On 15 Feb 2006 08:42:28 -0800, "Ben" <balvey_at_comcast.net> wrote:

>So, I won't ever be able to see any of that available space from the
>purge, until that table is analyzed will I?
>

apart from using dbms_space, no.

>I know that analyze is obsolete but until I can get it tested out I
>can't switch to dbms_stats.gather_stats. Currently we are running a
>procedure every weekend dbms_utility.analyze_schema, it starts at 1pm
>on Saturday and runs until around 6 am Monday for a 330Gb schema.
>Should I expect about the same runtime from gather_stats?

No. You can limit the number of tables being analyzed by making sure all tables are set to monitoring. If you run dbms_stats with the 'gather stale' option, it will analyze only those tables which have changed for more than 10 percent. Also dbms_stats supports using multiple cpu's and analyze doesn't.

--
Sybrand Bakker, Senior Oracle DBA