RE: DBA_HIST_SQLSTAT
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "Christopher.Taylor2@xxxxxxxxxxxx" <Christopher.Taylor2@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Nov 2012 17:04:19 +0100
As I understand it, if you want the number of executions done in a certain
timeframe, you would need to sum the executions_delta for the snapshots in
that period.
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Christopher.Taylor2@xxxxxxxxxxxx
Sent: dinsdag 20 november 2012 16:43
To: oracle-l@xxxxxxxxxxxxx
Subject: DBA_HIST_SQLSTAT
Anyone done any data mining on this view?
I'm trying to understand how the EXECUTIONS_TOTAL, EXECUTIONS_DELTA,
ELAPSED_TIME_TOTAL, ELAPSED_TIME_DELTA roll up (if they do) from one snapshot
to the other.
I cannot determine if EXECUTIONS_TOTAL for a SNAP_ID are the executions during
that snapshot so that I would need to SUM the EXECUTIONS over multiple
snapshots, or if I should take the executions within that snapshot
independently as the total amount.
For example:
Snaps: 22995-22996
SQL_ID: c4pc3jhzjcmc7
Plan_Hash_Value: 5300452
22995: Executions Total = 2799, Executions Delta = 194, Elapsed Time Total =
530016, Elapsed Time Delta = 40284
22996: Executions Total = 2889, Executions Delta = 90, Elapsed Time Total =
544883, Elapsed Time Delta = 14867
From here I can take either the SUM of EXECUTIONS for both periods, or I can
take just the last row (snap: 22996) but it would be nice to know if the
executions are a rolling total or not.
Anyone know?
Chris Taylor
Oracle DBA
Parallon IT&S
christopher.taylor2@xxxxxxxxxxxx<mailto:christopher.taylor2@xxxxxxxxxxxx>
www.parallon.net
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
