Re: All SQL from AWR for a user

From: Thomas P S <royxavier_at_yahoo.com>
Date: Wed, 06 May 2015 16:40:41 +0000
Message-ID: <1487092863.1233177.1430930440082.JavaMail.yahoo_at_mail.yahoo.com>



I will try this simple SQL..  add more details if you need.. select distinct INSTANCE_NUMBER,SNAP_ID,sql_idfrom DBA_HIST_ACTIVE_SESS_HISTORY dh,dba_users duwhere du.user_id=dh.user_id anddu.username='&username'; Thanks, ThomasThomas Saviour's Blog

|   |
|   | |   |   |   |   |   |
| Thomas Saviour's BlogMy Oracle Life |
| |
| View on ora600tom.wordpress... | Preview by Yahoo |
| |
|   |

    

     On Wednesday, May 6, 2015 12:34 PM, Dominic Brooks <dombrooks_at_hotmail.com> wrote:    

  The requirement is flawed.

Sent from my Windows PhoneFrom:Sanjay Mishra Sent:‎06/‎05/‎2015 02:45
To:Oracle-l Digest Users
Subject:All SQL from AWR for a user

Hi
Can someone help as how to find all SQL from AWR for a specific user ? Thanks for the help
Sanjay   

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 06 2015 - 18:40:41 CEST

Original text of this message