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

Home -> Community -> Usenet -> c.d.o.server -> Re: Batch jobs

Re: Batch jobs

From: <awtracy_at_my-dejanews.com>
Date: Tue, 27 Apr 1999 14:20:14 GMT
Message-ID: <7g4h2o$pgq$1@nnrp1.dejanews.com>


Try ...

SELECT username, osuser, program
FROM v$session
WHERE username IS NOT NULL;

Should give you all you need.

In article <3PhV2.70$LK2.110_at_c01read02-admin>,   "jfguyard" <jfguyard_at_swissonline.ch> wrote:
> Hi
>
> Trying to find out which users still are working at night when the
> backup process is starting. Has anyone such a script ot any idea how it
> can be done?
> Our environment is Digital UNIX with Oracle 7.3.4.
>
> Thanks in advance and best regards.
> --
> Posted via Talkway - http://www.talkway.com
> Exchange ideas on practically anything (tm).
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 27 1999 - 09:20:14 CDT

Original text of this message

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