• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

sql_id

What is actually sql_id?

what is the use of it....
0
walkerdba
Asked:
walkerdba
4 Solutions
 
Naveen KumarProduction 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 KumarProduction 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
slightwv (䄆 Netminder) 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 KumarProduction 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now