check out PARSING_SCHEMA_NAME on DBA_HIST_SQLSTAT
https://docs.oracle.com/database/121/REFRN/refrn23447.htm#REFRN23447
of course you can also mine DBA_HIST_ACTIVE_SESS_HISTORY
https://docs.oracle.com/database/121/REFRN/refrn23400.htm#REFRN23400
On Tue, May 5, 2015 at 8:43 PM, Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
Hi
Can someone help as how to find all SQL from AWR for a specific user ?
Thanks for the help
Sanjay
