Re: What table contains Oracle Userid?

Bob McGuire wrote:
>
> Greetings all.
>
> Does anyone know what table, if any, contains the Oracle run Id?
> This would be the same one you see under SQLDBA in the user screen.
>
> I've written a script that uses the spool command in the sqldba screen, but
> I'd rather have a recurring query.
>
> Any Info greatly appreciated.
>
> Thanks,
>
> Bob Mc.
>
> ps.. Thanks to all who responded to my question on the zip/unzip problem.
>
> --
> +-----------------------------------------------------+
> | Bob McGuire, N1HKV ARRL/W5YI VE et al |
> | Oracle Database Administrator/VMS Systems Manager |
> | Groundwater Technology, Inc. Norwood, MA |
> | Email to: bmcguire_at_gtionline.com |
> | |
> | "Testing's for sissies..." ...-.- |
> -----------------------------------------------------+

I think it's sys.v$session

Michel Lapierre Received on Tue Mar 05 1996 - 00:00:00 CET