How do we find out which SQLs were issued by a particular session.
V$SQL does not have the username that executed the SQL.
So, if I want to find out the SQLs issued by user ABC, how can we get this?
We have no ASH.
PS: Username ABC will have many sessions running in the DB at the same time issuing many SQLs. I want to get all those SQLs from all the ABC sessions.