How to get all the running process in oracle [message #437431] |
Mon, 04 January 2010 07:01  |
rumarani
Messages: 13 Registered: September 2009 Location: Bangalore
|
Junior Member |
|
|
Hi,
I have formulated this query which is used to display all the running process as below.
SELECT s.SID, s.STATUS, s.process, s.osuser, a.sql_text, p.program
FROM v$session s, v$sqlarea a, v$process p WHERE s.PREV_HASH_VALUE = a.hash_value
AND s.PREV_SQL_ADDR = a.address AND s.paddr = p.addr AND s.STATUS = 'ACTIVE'
Please let me know if this is correct.
|
|
|
|
Re: How to get all the running process in oracle [message #437442 is a reply to message #437431] |
Mon, 04 January 2010 07:30   |
rumarani
Messages: 13 Registered: September 2009 Location: Bangalore
|
Junior Member |
|
|
Hi Rainy,
Thanks for your quick reply.But what i need is an sql to get
all the running process,Because i need to pass the same sql in
a perl file and can't write the procs inside a perl file.
If you can help me in getting the sql or can i use the same sql.
Thanks,
|
|
|
|
|