Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

servicename

Is there any command to find the service name in oracle.
or else what is the best way to find service name..
0
nobleit
Asked:
nobleit
  • 3
1 Solution
 
HainKurtSr. System AnalystCommented:
try

select name,value from v$parameter
where name='instance_name'
0
 
HainKurtSr. System AnalystCommented:
or check for service_names

select name,value from v$parameter
where name='service_names'
0
 
HainKurtSr. System AnalystCommented:
also this one

select name,value from v$parameter
where name='db_name'
0
 
MrNedCommented:
Some services related views:

select * from gv$services;
select * from gv$servicemetric;
select * from gv$servicemetric_history;
select * from gv$service_event;
select * from gv$service_stats;
0
 
slightwv (䄆 Netminder) Commented:
Instance name or database name?

In addition to the above:
select global_name from global_name;
select name from v$database;
select instance_name from v$instance;

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now