You are attempting to pin the cursors so they do not have to be hard parsed
again, right? What about using outlines?
On 12/1/06, Binh Pham <binhpham15_at_hotmail.com> wrote:
>
> Trying to automate a process of pinning cursors of certain SQL's after
> database bounce.
>
> These are the data:
>
> 1. Know the hash values of these SQL's.
> 2. Have captured these SQL's from V$SQLTEXT and V$SQLTEXT_WITH_NEWLINES.
> 3. Can generate SQL's to pin these cursors.
>
> Problems:
>
> 1. Can't pin what is not there.
> 2. Have written PLSQL to retrieve these SQL's from (2) above and execute
> them in hope that they would produce the same hash values and then I can pin
> them.
> 3. Since I could not create the same hashes, no use to pin them.
>
> The results were not successful and different hash_values are created than
> the one created from the original Oracle forms.
>
> Did I miss anything? Any idea would be greatly appreciated.
>
> Thank you.
>
> (Note: thinking about using Mercury tool or Oracle form record/playback to
> execute the forms before pinning but this is not what I'd like to do)
>
> ------------------------------
> Talk now to your Hotmail contacts with Windows Live Messenger.<http://g.msn.com/8HMBENUS/2749??PS=47575>--
> http://www.freelists.org/webpage/oracle-l
--
Charles Schultz
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Dec 02 2006 - 06:37:33 CST
