Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: freelists and dba_free_space

Re: freelists and dba_free_space

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 14 Feb 2006 19:51:57 +0100
Message-ID: <gh94v1d63g0ptd5ak9mr270qa55tsfh08j@4ax.com>


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 DBA
Received on Tue Feb 14 2006 - 12:51:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US