Home » SQL & PL/SQL » SQL & PL/SQL » How the SQL hash is computed ?
How the SQL hash is computed ? [message #585117] Wed, 22 May 2013 05:32 Go to next message
Amine
Messages: 278
Registered: March 2010
Senior Member

Hi all,
Is it true that the SQL hash is computed on the SQL text only ?
Any Oracle link on that is appreciated.

Thanks in advance,
Amine
Re: How the SQL hash is computed ? [message #585120 is a reply to message #585117] Wed, 22 May 2013 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: How the SQL hash is computed ? [message #585121 is a reply to message #585120] Wed, 22 May 2013 06:06 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And it took me 10 seconds to find this information in chapter 7 of both "Database Concepts" and "Database Performance Tuning Guide"

Regards
Michel
Re: How the SQL hash is computed ? [message #585133 is a reply to message #585121] Wed, 22 May 2013 07:10 Go to previous messageGo to next message
Amine
Messages: 278
Registered: March 2010
Senior Member

Sorry for spamming then Razz
http://docs.oracle.com/cd/E11882_01/server.112/e16638/memory.htm#PFGRF94291
Re: How the SQL hash is computed ? [message #585134 is a reply to message #585133] Wed, 22 May 2013 07:12 Go to previous message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See, you are able to find the answer by yourself. Razz
Thanks for the feedback and link.

Regards
Michel
Previous Topic: Please help me to implement this.
Next Topic: please help,Error(15,22): PLS-00382: expression is of wrong type
Goto Forum:
  


Current Time: Mon Dec 29 00:45:49 CST 2014

Total time taken to generate the page: 0.21480 seconds