Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql_id vs sql_address vs sql_hash_value columns in v$session, what is the best and correct way to jo

JordenMJun 29 2018 — edited Jun 29 2018

Hi,

Q1) Please help in understand the difference between given columns (are they all have same meaning or different meaning for all):

COLUMNS -> sql_id vs sql_address vs sql_hash_value in v$session.

Q2) what is the best and correct way to join v$session with v$sql (and/or v$sqlarea), I am not getting the following:

a) join using SQL_ID is not sufficient?

b) does join should have sql_hash_value and sql_address (both)?

This post has been answered by Jonathan Lewis on Jun 29 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 27 2018

Added on Jun 29 2018

#general-database-discussions, #query

8 comments

2,172 views