hi i want to find out database sid,sql text,query start time from os pid for the long running query and request that are submitted from front end.
many times some request is not shows in front end (application) but it is running in backend. in that condition we have to kill such type of request manually from backend.
but i don't know how can i findout such type of request from backed.
plz provide such type query to findout sid from os pid..
regares
pritesh ranjan