list all connections or sessions
711052Oct 6 2010 — edited Oct 6 2010is there a simple way to list all the session and their status in Oracle.
I see all hefty tool which probably could do that like toad etc... EM has everything but a simple screen which will show all the session and what they are running...
would this be a comple query? it seems to be a simple and very common request when one is checking the database - cant find anything worthy out of google in this scenerio