Q: how to minimize parse call ?

From: <tedchyn_at_yahoo.com>
Date: Thu, 28 Oct 1999 19:30:17 GMT
Message-ID: <7va889$ase$1@nnrp1.deja.com>

Sir: following listing from sqlarea show very high parse call and invalidation. this may be caused by close cursor after each transaction. questions:
1. how do I reduce parse call/invalidations ? one of oracle paper stated:

  Reducing the amount of parsing is often as simple as setting 'HOLD_CURSOR=TRUE' for the precompilers.

 is this mean I can close the cursor and compile the program with hold_cursor=true (how to do this)?

thanks in advance(ted chyn)

SQL_TEXT

---

---

PARSE_CALLS EXECUTIONS INVALIDATIONS
----------- ---------- -------------
insert into batch_transactions (mid, oid, odate, status, batch_time) values (:mi
d, :oid, :odate, :status, :batch_time)

    2014998 2015021 213

insert into items (mid, oid, itemnum, odate, itemid, description, price, quantit
y, softtype, softgood, downloadip, downloadtm, downloadrate) values (:mid, :oid,
 :itemnum, :odate, :itemid, :description, :price, :quantity, :softtype, :softgoo
d, :downloadip, :downloadtm, :downloadrate)

    4030399 4030402 213

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 28 1999 - 14:30:17 CDT