Which DB am i connected to currently?

Question

I am working in a project which has huge amounts of DATA, hence we are using two DBs. Now my question is, how will i know to which DB my system is currently connected to?

If usernames are diffferent then you can use `select user from dual;` — vishad, Sep 19 '14 at 10:22
possible duplicate of [Checking oracle sid and database name](http://stackoverflow.com/questions/6288122/checking-oracle-sid-and-database-name) — yamny, Sep 19 '14 at 10:29

Patrick Hofman · Accepted Answer · 2014-09-19T10:31:36.910

1

You can get the variable instance_name from the context:

select sys_context
       ( 'userenv'
       , 'instance_name'
       )
from   dual

edited Sep 19 '14 at 10:31

answered Sep 19 '14 at 10:23

Patrick Hofman

148,824
21
237
306

Which DB am i connected to currently?

1 Answers1