Re: show runtime for all active queries

Mark D Powell wrote:
> 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
>

Works on 9.2, too.

-- 
Regards,
Frank van Bortel