How to get SID and Service Name?
Posted: Sun May 15, 2022 5:04 pm
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;
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;