Re: Cached blocks and performance

From: Jonathan Bliss <bliss_jonathan_at_hotmail.com>
Date: Sun, 1 Sep 2002 19:19:52 +0100
Message-ID: <MNsc9.3128$fY.81364@newsfep2-gui>

"Sybrand Bakker" <postbus_at_sybrandb.demon-verwijderdit.nl> wrote in message news:b6oumug6ekvi6nl061m09s5dj6dhleks7i_at_4ax.com...
> On 30 Aug 2002 02:37:50 -0700, bliss_jonathan_at_hotmail.com (Jonathan
> Bliss) wrote:
>
> >3 - Rows chained across blocks (too small pct free, regular updates)
>
> Analyze table <table_name> list chained rows into ...
> Or just analyze table to determine the chain_cnt column in user_tables
> Or look at your statspack reports (utlbstat/utlestat in former
> versions)
>
> Hth
>

yep, this helps

Thanks, Jonathan Received on Sun Sep 01 2002 - 13:19:52 CDT