list users/databases
From: Philip Davies <hc76_at_dial.pipex.com>
Date: 1996/07/01
Message-ID: <4r8nbb$qib_at_soap.news.pipex.net>#1/1
Date: 1996/07/01
Message-ID: <4r8nbb$qib_at_soap.news.pipex.net>#1/1
The question is:
Is it possible to get a list of users that are logged onto Oracle -
I can list this on UNIX (ps -ef | grep ora) but I can't find a way within
Oracle. I would also like to be able to get a list of all available
databases. Apart from querying the oratab file and hoping it is up to
date is there any way to detect this?
My first reaction is no to both, set it up yourself - but here's hoping
that Oracle can do these!
Any help would be gratefully received,
Thanks in advance,
Lisa Jarman, DBA, PECC Ltd Received on Mon Jul 01 1996 - 00:00:00 CEST