Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: freelists and dba_free_space
On 14 Feb 2006 04:34:12 -0800, "Ben" <balvey_at_comcast.net> wrote:
>Thank you for the information, makes very good sense.
>
>One other thing, what is the avg_space_freelist_blocks and
>num_freelist_blocks within dba_tables?
>
>I was under the impression that some of those columns in dba_tables
>didn't get updated until you analyzed the table. Or in this case, ran
>the dbms_stats or dbms_space procedures.
>
>Along those lines, what kind of impact does the dbms_space and *_stats
>procedure have on performance? Should I wait until night time
>processing to be running these?
>
>Thank you again.
>
>Ben
avg_space_free_list_blocks: the average space available in all blocks
on the free list.
num_free_list_blocks: the number of blocks on the free list.
Indeed they are only updated during (obsolete) analyze table and/or dbms_stats.gather_table_stats
dbms_space: none
dbms_stats : never measured any noticeable effect, but am running it
outside office hours.
-- Sybrand Bakker, Senior Oracle DBAReceived on Tue Feb 14 2006 - 12:51:57 CST