SSR

• Jul 20th, 2011

 

select * from v$database
select * from v$instance

prakash_dba

 Profile Answers by prakash_dba 

• Aug 1st, 2011

 

Re: How do you find which database the user is connected in oracle 10g?

show parameter db_name

Banu

• Aug 9th, 2011

 

SQl>select INSTANCE_NAME from v$INSTANCE;

prakash

• Aug 26th, 2011

 

SQL>show parameter db_name:

SQL>select db_name from v$database;

Dharma Teja

• Oct 10th, 2011

 

select name from v$database;

SHARFUDDIN AHMED

• Oct 18th, 2011

 

select name from v$database;

nikhilesh nirwan

• Oct 21st, 2011

 

1>database in nomount stage:-show parameter db_name
2>database is in mount use dynamic parameter like v$database and v$instance

Albert Z

• Mar 31st, 2015

 

SELECT SYS_CONTEXT (USERENV, HOST) from dual;

Manoranjan Dash

• Sep 18th, 2017

 

Query the v$session table.