DBA Newbie question

From: Maurice Sogelée <msogelee_at_kembit.nl>
Date: Fri, 29 Sep 2000 08:57:34 +0200
Message-ID: <8r1ej2$a7gno$1@reader4.wxs.nl>

Hi,

i have been asked to examine a database where users experience problems while committing data to a certain table. I have run a trace several times, but found no severe 'values'.

What i would, using TOAD, is that there are some problem areas, which are :

Buffer cashe hit rate= 22,9292 , comment : may need to increase db_block_buffer
Chained fetch ratio = 0,0318, comment: pctfree TOO LOW for a table
parse/execute ratio = 66,9118, comment : high parse to execute ratio.

Can anyone tell me what these statistics tell me ?

regards,

Maurice Sogelée Received on Fri Sep 29 2000 - 01:57:34 CDT