Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CHAINED FETCH RATIO

391807Apr 29 2003 — edited May 1 2003

Hello sir

i am using ORACLE TOOL TOAD .
WHEN I SEE DATABASE PERFORMANCE STATISTICS

PCTFREE TO LOW ON TABLE THIS IS THE MESSAGE IT IS GIVING>
RECENTLY IN MY TABLE (REFERRALS) I AHVE ADDED 6 MORE COLUMNS AND I HAVE UPDATE THE THE TABLE.I THINK DUE TO THIS REASON I AM GETTING THIS.
HOW CAN I IMPROVE PCTFREE FOR A TABLE(ALREADY WITH 55,000 RECORDS)
HOW TO INCREASE CHAINED FETCH RATIO

Locked Post

New comments cannot be posted to this locked post.

Locked on May 29 2003

Added on Apr 29 2003

#general-database-discussions

3 comments

310 views