I have some PL/SQL code which looks for chained rows once a week and unchains them when the chained rows count exceeds 5% of the total number of rows. Inside this code for each table where the unchaining occurs I increase PCTFREE by 5 and decrease PCT used by 5. The goal is to achieve equilibrium where chained rows no longer occur within this table.
Pablo ksksksk wrote: > > How can I calculate the values I should set PCTFREE > and PCTUSED for a table that has already been created. > > can I use the statistics for that? > > thank you. > Pablo > > _______________________________________________________________ > Do You Yahoo!? > Yahoo! Messenger > Comunicaci�n instant�nea gratis con tu gente. > http://messenger.yahoo.es > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Pablo=20ksksksk?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lead, follow, or at least have the courtesy to get out of my way! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
