Posted on 2011-03-23
Last Modified: 2012-05-11
Is there any command to find the service name in oracle.
or else what is the best way to find service name..
Question by:nobleit
  • 3
LVL 51

Expert Comment

by:Huseyin KAHRAMAN
ID: 35204117

select name,value from v$parameter
where name='instance_name'
LVL 51

Expert Comment

by:Huseyin KAHRAMAN
ID: 35204123
or check for service_names

select name,value from v$parameter
where name='service_names'
LVL 51

Expert Comment

by:Huseyin KAHRAMAN
ID: 35204127
also this one

select name,value from v$parameter
where name='db_name'

Accepted Solution

MrNed earned 500 total points
ID: 35204158
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;
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35206208
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;


Featured Post

Independent Software Vendors: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question