sqlplus how to find details of the currently connected database session

oracle sqlplus
Nishant Bhardwaj picture Nishant Bhardwaj · Mar 21, 2013 · Viewed 133.9k times · Source

I have very recently started to work on oracle databases. Generally I have many sqlplus windows open to different oracle databases. When switching from one sqlplus session to another, how can i view the current session details for each sqlplus session ? Any help is greatly appreciated!

Answer

igr picture igr · Mar 21, 2013 
show user

to get connected user 

 select instance_name from v$instance

to get instance or set in sqlplus 

set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> "

Related questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How do I spool to a CSV formatted file using SQLPLUS?

I want to extract some queries to a CSV output format. Unfortunately, I can't use any fancy SQL client or any language to do it. I must use SQLPLUS. How do I do it?

Read More
How to display databases in Oracle 11g using SQL*Plus

With help of this command show databases; I can see databases in MySQL. How to show the available databases in Oracle?

Read More