Re: reducing parse/execution ratio

It seems the sql statement always paged out from shared pool. either
(1) increase the SHARED_POOL_SIZE in init.ora or (2) pin your object using DBMS_SHARED_POOL.KEEP();

HTH John Chiu

Riad <rsouissi_at_yahoo.com> wrote in message news:8241jp$uab$1_at_nnrp1.deja.com...
>
>
> Hello,
>
> I checked the V$SQLAREA to see the EXECUTION and PARSE time. It seems
> that our Oracle Database (8i) is reparsing ther same statement all the
> time.
> How could I reduce the parse/execution ratio and have Oracle not
> reparsing the sql statement all the time ? (so have it executed
> directly)
>
> Actually, we are running an application through Netscape Application
> Server that keeps a pool of opened connections.
> Anyway, we open a lot of cursors (dynamic, but bindable statements).
>
> Thanks in advance.
> Riad
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Dec 05 1999 - 06:42:05 CST