Monday, 16 July 2012

Terminating Concurrent program sessions

One way of finding the session id for concurrent is through discussed in my earlier post
But there is another easy way...

select sid,serial#,MODULE,ACTION,status from V$session

the module will contain the concurrent program short name...If only one instance of the concurrent program is running
we can easily identify the sessions of it..

If we terminate the program and the session not got released..simply find th session

and use the command
alter sytem kill session 'SID,SERIAL#'
Please the values you got from the above query

No comments:

Post a Comment