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!

Join v$sql and v$session

794905Sep 27 2010 — edited Sep 27 2010

Hi All,

I want following columns from both v$sql(last_active_time) and v$session(username,status ,program)

Cud anyone guide me how to what is the sql that joins both views so that i get above column info ?

Thanks a lot

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2010

Added on Sep 27 2010

#general-database-discussions

6 comments

5,069 views