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

Home -> Community -> Mailing Lists -> Oracle-L -> Pinning cursors knowing the hash_values and SQL's ahead of time

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

From: Binh Pham <binhpham15_at_hotmail.com>
Date: Sat, 02 Dec 2006 01:58:10 +0000
Message-ID: <BAY103-F2716C48565B5254A528C8BD2D90@phx.gbl>

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://www.freelists.org/webpage/oracle-l Received on Fri Dec 01 2006 - 19:58:10 CST

Original text of this message

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