Re: Cached blocks and performance

From: Sybrand Bakker <postbus_at_sybrandb.demon-verwijderdit.nl>
Date: Fri, 30 Aug 2002 14:12:13 +0200
Message-ID: <b6oumug6ekvi6nl061m09s5dj6dhleks7i@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

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Aug 30 2002 - 07:12:13 CDT