reducing parse/execution ratio

From: Riad <rsouissi_at_yahoo.com>
Date: Wed, 01 Dec 1999 20:48:59 GMT
Message-ID: <8241jp$uab$1@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 Wed Dec 01 1999 - 14:48:59 CST