pients of list
ORACLE-L
en cc:
@xo.com> Subject: Currently log-in users
Sent by: root
04/11/2002
11:53 AM
Pleas
David M" To: Multiple recipients of list ORACLE-L
en cc:
Thanks for the script. It is useful for me.
David
-Original Message-
Sent: Thursday, April 11, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Try either of 1 script and make changes according to your requirement:
1)
col LOGIN_TIME format a12
COL OSUSER FORMAT A7
COL ORACLE_US
Try either of 1 script and make changes according to your requirement:
1)
col LOGIN_TIME format a12
COL OSUSER FORMAT A7
COL ORACLE_USER FORMAT A8
COL PROGRAM FORMAT A25
COL PROCESS_NR FORMAT A8
col uur format A5
select to_char(a.logon_time,'DD/MM HH24:MI') LOGIN_TIME,
to_char(round(c.seconds_in_
Here's a good starting point. If you want I also have a unix shell script
driver for this that does a little more formatting.
set feedback off
set heading off
set timing off
set time off
set echo off
set term off
set pagesize 256
set space 1
column username format a8
column machine format a8
co
Some selects You can find in
http://www.itsystems.lv/gints/dba_selects.htm
I'm sure there are websites with more scripts around the net, of course...
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
>How do I check who is currently logging into database, where h
select * from v$sqlarea where address in ( select sql_address from v$session
where username is not null ) ;
--Madhu
-Original Message-
Sent: Thursday, April 11, 2002 10:53 AM
To: Multiple recipients of list ORACLE-L
How do I check who is currently logging into database, where he is
>
cc:
Subject:
Currently log-in users
How do I check who is currently logging into database, where he is accessing
from and what he is doing?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat
v$session would be a good startin place.
Dave
-Original Message-
Sent: Thursday, April 11, 2002 10:53 AM
To: Multiple recipients of list ORACLE-L
How do I check who is currently logging into database, where he is accessing
from and what he is doing?
Thanks,
David
--
Please see the of
Start with v$session.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 11:53 AM
> How do I check who is currently logging into database, where he is
accessing
> from and what he is
How do I check who is currently logging into database, where he is accessing
from and what he is doing?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 5
11 matches
Mail list logo
