Re: show runtime for all active queries

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 21 Mar 2005 13:34:13 -0800
Message-ID: <1111440649.634830@yasure>

lambu999_at_yahoo.com wrote:

> Mark D Powell wrote:
>

>>Note that the v$session.machine columns tells you the machine the
>>session connected from and is not the host name of the database

>
> server.
>

>> You can get that from v$database.

>
>
> Mark,
>
> I am using Oracle 9i EE on Win. I do not see the hostname column in
> V$database view. Did you mean v$instance view?
>
> If yes, I have another question. How does it work in the case of RAC?
> What is the 'host' where the data is stored in a SAN or a big storage
> array which hosts multiple databases.
>
> Thanks,
> Ram.

Lets clear something up here ... the database is just a bunch of files sitting on some form of disk storage that has not 1:1 relationship with any server. Thus a database, by definition, does not have a host unless you name your SAN with a post-it note.

Instances run in memory on a server and there is no difference, in that regard, between a stand-alone instance and RAC. Each instance runs on a named host.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Mon Mar 21 2005 - 15:34:13 CST