Re: Cursors and Shared pool

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Tue, 23 Jan 2007 16:00:14 GMT
Message-ID: <Xns98C1516E44735anacedenthotmailcom@69.28.173.184>

Emre <emre_at_emre.com> wrote in
news:Xns98C1A943021CEemreemrecom_at_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 ?
>

http://tahiti.oracle.com
Read the fine Concepts Manual Received on Tue Jan 23 2007 - 10:00:14 CST