Re: determine from some table which instance you are in

From: Wayne <bruzek_at_erols.com>
Date: Thu, 23 Aug 2001 11:24:24 -0400
Message-ID: <9m377a$i7h$1@bob.news.rcn.net>

select 'Host Name:' as name, host_name as value from v$instance;

select

decode(name,'instance_name',        'Instance Name:',
            'service_names',        'Service Name:',
            'db_name',              'Database Name:',
            'ifile',                'Init.ora File:',
            'host_name',            'Host Name:',
            'background_dump_dest', 'Background Dump File:',
            'user_dump_dest',       'User Dump File:',
             name),

value
from v$system_parameter where name in
('instance_name','service_names','db_name','ifile','host_name', 'background_dump_dest','user_dump_dest');

Jeff Kish wrote in message ...
>Is there any table or view I can query to find out the Oracle instance
>that I am connected to as a certain user? What about the machine name?
>
>I would like to determine if some processes I need to run are in the
>same instance or not. I am working in C++.
>
>Thanks
>Jeff Kish
>jeff.kish_at_mro.com
Received on Thu Aug 23 2001 - 10:24:24 CDT