|
|
| Re: Chained Fetch Ratio & Parse to Execute Ratio [message #203870 is a reply to message #203838] |
Thu, 16 November 2006 14:00  |
michael_bialik
Messages: 621
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
