RE: SQL ID -- what all times it got executed
From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Tue, 13 Oct 2015 06:50:02 +0100
Message-ID: <DUB408-EAS19240ED2D508F6B3B6F2B51A1300_at_phx.gbl>
For ALL times, audit sql statements or trace. AWR is aggregations, ASH is samples.
ASH if every execution is guaranteed to be executing continuously in the database for longer than the ASH sample time (1 sec for V$, 10 secs for DBA_HIST)
From: Anurag Verma<mailto:anuragdba_at_gmail.com> Sent: 13/10/2015 02:11
To: ORACLE-L<mailto:oracle-l_at_freelists.org> Subject: SQL ID -- what all times it got executed
Date: Tue, 13 Oct 2015 06:50:02 +0100
Message-ID: <DUB408-EAS19240ED2D508F6B3B6F2B51A1300_at_phx.gbl>
For ALL times, audit sql statements or trace. AWR is aggregations, ASH is samples.
ASH if every execution is guaranteed to be executing continuously in the database for longer than the ASH sample time (1 sec for V$, 10 secs for DBA_HIST)
Sent from my Windows Phone
From: Anurag Verma<mailto:anuragdba_at_gmail.com> Sent: 13/10/2015 02:11
To: ORACLE-L<mailto:oracle-l_at_freelists.org> Subject: SQL ID -- what all times it got executed
How to find a particular SQL ID got executed on which all times.
The database is 11.2.0.3
and AWR is running.
--
Anurag Verma,
Database Administrator
ERCOT
Texas 76574
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 13 2015 - 07:50:02 CEST