Re: Pinning cursors knowing the hash_values and SQL's ahead of time

  • From: "Charles Schultz" <sacrophyte@xxxxxxxxx>
  • To: binhpham15@xxxxxxxxxxx
  • Date: Sat, 2 Dec 2006 06:37:33 -0600

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@xxxxxxxxxxx> 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.


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
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 

Charles Schultz

Other related posts: