Message-Id: <10621.117204@fatcity.com> From: "Adisekaran Murugaian" Date: Sat, 16 Sep 2000 19:33:13 -0400 Subject: DATABASE TUNING This is a multi-part message in MIME format. ------=_NextPart_000_0009_01C02014.F446F6A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I get the following information from Toad. Chained fetch ratio: 0.0464 (PCTFREE TOO LOW for a table) parse/execute ratio 77.8308 (high parse to execute ratio) to increase the performance and to avoid the warning : PCTFREE TOO LOW = for a table &high parse to execute ratio=20 What should be the optimum values ? What are parameters related to these values ? Environment: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ORACLE 8.1.6 Sun OS. 5.7 RAM 1GB 400 x 2 processor =20 ------=_NextPart_000_0009_01C02014.F446F6A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I get the following information from = Toad.
 
Chained fetch ratio: 0.0464   (PCTFREE TOO = LOW for a=20 table)
parse/execute ratio 77.8308 (high parse to execute=20 ratio)
 
 
to increase the performance and to avoid the warning = : PCTFREE=20 TOO LOW for a table &high parse to execute ratio
What should be the optimum values = ?
What are parameters related to these values=20 ?
 
Environment:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
ORACLE 8.1.6
Sun OS.  5.7
RAM 1GB
400 x 2 processor