Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: show runtime for all active queries

Re: show runtime for all active queries

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sun, 20 Mar 2005 22:00:28 GMT
Message-ID: <Xns961F8E7F2685ASunnySD@68.6.19.6> 





"Mark D Powell" <Mark.Powell_at_eds.com> wrote in 
news:1111350533.862759.291690_at_z14g2000cwz.googlegroups.com:



> 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.




SELECT MACHINE FROM V$SESSION WHERE SID = 1;

does return the hostname of the database server itself.
Received on Sun Mar 20 2005 - 16:00:28 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US