sql_id

What is actually sql_id?

what is the use of it....
walkerdbaAsked:
Who is Participating?
 
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
It is used for uniquely identifying any sql statement in the database when it gets executed. We can use it to find sql statements by querying with that id.
0
 
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
normally we use it join all required data dictionary views accordingly to find more information about a problematic sql orfor that matter any particular sql when needed to understand all details related to it like its explain plan, bind variables, etc...
0
 
walkerdbaAuthor Commented:
any sql statements

that is executed  ok..

that is alphanumeric or just numeric...
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
The docs are your friend:
http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_3016.htm#REFRN30223

For example for V$SESSION:
SQL_ID       VARCHAR2(13)       SQL identifier of the SQL statement that is currently being executed
0
 
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
0
 
Franck PachotCommented:
Hi,

It is a way to identify statements, by hashing the sql text.

See:
http://blog.tanelpoder.com/2009/02/22/sql_id-is-just-a-fancy-representation-of-hash-value/

Note that as with any hashing function, two different sql statements may have the same sql_id - but that should be very very rare.

Regards,
Franck.
0
 
walkerdbaAuthor Commented:
fine ok
0
 
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.