Gang's Tech Stuff

Archive for November 2010

Query to see what each session is doing in Oracle

Posted by: Gangadhar on: November 25, 2010

One might face a situation where he wants to know what all queries are running on an Oracle DB or may be there is a lock on a table due to a update/delete query and you want to kill that query. In such cases, you can use following query to display all the sessions, the [...]


Follow

Get every new post delivered to your Inbox.