How to Identify User and SQLs in an Oracle database?

This is a very common scenario for a DBA to be in a situation where a DBA needs to find out one of the following: Which user is running which SQL? A particular SQL is being run by which user? A particular user is running which SQL? As it is evident from these questions – […]