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
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-lReceived on Wed May 06 2015 - 18:40:41 CEST