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!

How to show the connection string or SID from sql plus?

wyfwongMay 3 2008 — edited May 5 2008

I logon two sessions of SQL Plus, one to the local Oracle 10g with host string "ORCL" and one to a shared Oracle 10g on another PC with host string "otherorcl"
Is there any SQL command that can show the host string of the SQL Plus session?
Thanks for any discussion.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 2 2008

Added on May 3 2008

#general-database-discussions

5 comments

9,841 views