Home » RDBMS Server » Server Administration » displaying of running processes (
displaying of running processes [message #420815] Wed, 02 September 2009 07:05 Go to next message
Messages: 13
Registered: September 2009
Location: Bangalore
Junior Member
I am using this sql to see the current running process in oracle.
Can u please help in identifying an unique process from this query
                 s.serial#			SERIAL, 
                 s.username			DBUSER ,
        	 s.osuser			OSUSER, 
        	 s.module			MODULE, 
        	 s.terminal			TERMINAL,
                 s.program 			S_PROGRAMM, 
        	 p.program 			P_PROGRAMM,
                 to_char(s.logon_time,'dd.mm.yyyy hh24:mi:ss') LOGON, 
        	 lockwait			LOCKWAIT,
                 si.physical_reads	PHYS_READ, 
        	 si.block_gets		BLOCK_GETS,
                 si.consistent_gets	CONS_GETS,
                 si.block_changes	BLOCK_CHANGES,
                 si.consistent_changes CONST_CHANGES, 
        	 s.process			PROCESS,
                 p.spid				SPID, 
        	 p.pid				PID, 
        	 si.sid				SID, 
        	 s.sql_address		SQL_ADRESS,
                 s.sql_hash_value	SQL_HASH_VALUE, 
        	 s.action			ACTION
            FROM v$session s, v$process p, sys.v$sess_io si
           WHERE s.paddr = p.addr(+)
             AND si.sid(+) = s.sid
             AND (s.username IS NOT NULL)
             AND (NVL (s.osuser, 'x') <> 'SYSTEM')
             AND (s.TYPE <> 'BACKGROUND')[color=purple][/color] 8o 
        	AND s.username='CRES2BATCH'
        ORDER BY s.logon_time desc

[Mod Edit:Added Code Tags]

[Updated on: Wed, 02 September 2009 07:07] by Moderator

Report message to a moderator

Re: displaying of running processes [message #420818 is a reply to message #420815] Wed, 02 September 2009 07:22 Go to previous message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
identifying an unique process

What does this mean? Explain.

Previous Topic: error ora-12546 TNS permission denied(3 merged)
Next Topic: ORA-01562: failed to extend rollback segment
Goto Forum:

Current Time: Mon Jul 24 18:05:46 CDT 2017

Total time taken to generate the page: 0.10010 seconds