set linesize 132 column logon_time format a18 heading "Logon Time" set pagesize 24 set feedback on select SADDR, SID, SERIAL#, substr(USERNAME,1,8) "USER", STATUS , SCHEMA#, OSUSER, PROCESS, to_char(logon_time, 'DD-MON-YY HH24:MI:SS') LOGON_TIME, -- substr(action,1,5) action, --to_char(LOGON_TIME,'MONDD HH24:MI') "LOGON_TIME", last_call_et from v$session where status = 'ACTIVE' and username not like 'SYS'
Regards Rafiq
Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 21 Mar 2003 07:38:45 -0800
Hi Gene,
The following where clause will work:
a.paddr=b.addr and a.status = 'ACTIVE' and a.username is not null
-----Original Message----- Sent: Friday, March 21, 2003 09:24 To: Multiple recipients of list ORACLE-L
Hi.
I'm trying to get a feel of the number of the queries executed at the same time against a database. I have been using the following script (actually this is a part of a script)
Select a.type, count(1) col1
from v$session a,
v$process b
where
a.paddr=b.addr
and a.status like 'ACTIVE%'
and a.type <> 'BACKGROUND'
and a.osuser <> 'oracle'I want to see only ACTIVE sessions, not-background and not executed by oracle. Does anyone see anything wrong with that?
thanks Gene
__________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BALA,PRAKASH (HP-USA,ex1) INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
