Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Cursors and Shared pool

Cursors and Shared pool

From: Emre <emre_at_emre.com>
Date: Tue, 23 Jan 2007 14:40:50 GMT
Message-ID: <Xns98C1A943021CEemreemrecom@fe06.highwinds-media.phx>


Hii All..

I am wondering something about concepts of cursors and shared pool.
--In documention of oracle say;"an application make parse call or execute call if
make execute call then it have to make harde parse but I dont understand it if it make parse call then it dosent have to execute ?
--what is the exactly mean of rexecute cursor ? when cursor reexecuted then is sql
statement same before rexecuted ?
--when cursor is reused for diffrent sql statment then have to make parse call.it
have to execute call ? Received on Tue Jan 23 2007 - 08:40:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US