mamdouh asked this 7 years ago

How to find the service name of a oracle database?

How to get the service name of the currently running Oracle Service?

Best Answer by anette 7 years ago

Any one of the below queries:

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

select * from global_name;

show parameter service;

Guest 5 years ago

3 likes

select * from global_name;

Guest 1 year ago

Thank you!!

Select * from global_name;

Above query worked for all users.