Hi all,
I know the the question isn't inusual, but i 've a problem with parse
to execute ratio.
In my DB 92070 foran application i've applied this parameter:
cursor_sharing=force
session_cached_cursor=2000 (before it was setting to 0)
My SGA is setting so 700 Mb with Shared pool = 160MB. In PGA i've
149MB but only 89 are used.
My parse to execute ratio it's 62% and it's very high value the
response times sometimes aren't good.
My application works with bind varibles because if i run this SQL
statement:
select parse_calls, execution, hash_value, sql_text from v$sqlarea the
result for example it's 'select a,b,c from x where a=:B1' but more sql
statement it's
parsed 2344 for 2344 executions.It's very strange. Only few statements
are parsed 1 and execution more.
Thanks a lot in advance for your help.
Regards.
Alberto
Received on Mon Nov 19 2007 - 02:55:31 CST
