Re: show runtime for all active queries

Yes, I should have said v$instance. In the 10g manual Oracle provides the following query to get the db host name:

select utl_inaddr.get_host_name as hn from sys.dual

As Daniel points out that the value of the database "host" name is questionable depending on exactly what you are using it for and the existance of a RAC or non-RAC environment.

HTH -- Mark D Powell -- Received on Tue Mar 22 2005 - 09:19:33 CST