How to get SID and Service Name?

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
admin
Posts: 2015
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

How to get SID and Service Name?

Post by admin »

Import SQL's

SELECT sys_context('userenv','instance_name') FROM dual;

select value from v$parameter where name like '%service_name%';

SELECT sys_context('USERENV', 'SID') FROM DUAL;
select sys_context('userenv','db_name') from dual;
select sys_context('userenv', 'server_host') from dual;
select ora_database_name from dual;
select * from global_name;
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests