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
Messages: 315
Registered: June 2002
Senior Member

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.


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
Messages: 619
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.


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

Current Time: Wed Jul 26 08:06:17 CDT 2017

Total time taken to generate the page: 0.05944 seconds