Re: Urgent Oracle parsing question

You need to use host variables and as someone else said make sure the SQL statements are the same. For example,
select * from emp where empid=5;
is different from
select * from Emp where empid=5;
is differnet from
select * from emp where empid=7;

but you could do
select * from emp where empid=:hvEmpid; where hvEmpid is a host variable with a value of 5 and then
select * from emp where empid=:hvEmpid; where hvEmpid is a host variable with a value of 7 Then Oracle does not need to reparse etc. There is a section in the application developers guide that addresses this at length. If you are using ODBC the backend will only see the ? parameters as string substitutions and that won;t help. but OCI or proC etc. will allow you to use host variables.
Jim

Rajesh Bhave wrote in message <364BD569.ED9B8D21_at_india.hp.com>...
>Hello Oracle gurus,
>
>We are facing extensive performance degradation.
>This is because of Oracle parsing the same SQL
>statements for too many number of times. If someone
>could throw some lights on how to stop / avoid this,
>it will of great help.
>
>Thanx and Regards,
>Rajesh
>
Received on Fri Nov 13 1998 - 12:58:22 CST