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

Home -> Community -> Usenet -> c.d.o.tools -> Re: sp_who for Oracle

Re: sp_who for Oracle

From: Klaus Zeuch <KZeuch_at_hotmail.com>
Date: Fri, 25 Aug 2000 22:01:42 +0200
Message-ID: <8o6jaf$r6m$12$1@news.t-online.com>

No, there's no command. To obtain this information you must query the Oracle-Views v$session and v$sqltext, v$sqlarea

Klaus
"MAnder2686" <mander2686_at_aol.com> schrieb im Newsbeitrag news:20000825134704.27693.00000372_at_ng-bk1.aol.com...
> Is there a command in Oracle like the Sybase sp_who command that will let
 me
> see which users are logged on to the server and maybe what they are doing?
>
> Thank you,
>
> Michael A. Anderson
Received on Fri Aug 25 2000 - 15:01:42 CDT

Original text of this message

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