Home » RDBMS Server » Performance Tuning » Chained Fetch Ratio & Parse to Execute Ratio
Chained Fetch Ratio & Parse to Execute Ratio [message #203838] Thu, 16 November 2006 09:19 Go to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

In my TOAD it is showing

Chained Fetch Ratio - 0.0912
Parse to Execute Ratio - 37.5033

Infront of this it shows a RED alert. What could be wrong and how to correct.


Brian.


Re: Chained Fetch Ratio & Parse to Execute Ratio [message #203870 is a reply to message #203838] Thu, 16 November 2006 14:00 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Chained Fetch Ratio - your PCTFREE parameter (and possibly PCTUSED ) are not set correctly, so you have quite high number of chained/migrated rows. The only thing you can do is to rebuild the tables (look for CHAINED_ROWS in dba_tables ).


Parse to Execute Ratio - Probably your application is NOT using bind variables so it performs hard parse for a lot of sql statements or it is NOT reusing cursors and is performing soft parses. In both cases it means a number of parses is high compared with a number of executions.
Chech you V$SQL view for a similar statements using hard-coded values instead of parameters or for a statements with high number of parses.

HTH.



Previous Topic: check last statement executed
Next Topic: Is this the best performed query?
Goto Forum:
  


Current Time: Sun Dec 04 16:59:25 CST 2016

Total time taken to generate the page: 0.06145 seconds