| high parse to execute ratio [message #132815] |
Tue, 16 August 2005 06:05  |
owais303
Messages: 19
Registered: July 2005
Location: India
|
Junior Member |
|
|
hi,
My database is showing high parse to execute ratio,kindly suggest the ways to equate parse and execute attempts.Earlier i used to have a low buffer cache hit ratio which i rectified by increasing SGA and db_cache_size
Thanks
|
|
|
|
| Re: high parse to execute ratio [message #132828 is a reply to message #132815] |
Tue, 16 August 2005 07:10  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>suggest the ways to equate parse and execute attempts.
Base reason is, You are not reusing the statements.
Use Bind variables.
>>arlier i used to have a low buffer cache hit ratio
buffer cache hit ratio based tuning is flawed.
You programmatically bring the hit ratio to anything you want, with out increasing your cache size or anything.
So ignore it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
