AWR Report - number of executions
Hi
Setup:
Oracle 10.2.0.3 on Redhat Linux (Sun servers)
We're trying to establish the performance impact of increasing the SGA in our prod DB by running tests in one of our other environments.
1. We produced an AWR report for the prod batch
2. then copied the prod DB prod (at file level) to our test server
3. ran the batch (Test 1) with no changes to SGA size
4. and generated the AWR report there
5. Then reverted back to the state before the batch on the test server, applied the SGA changes and reran the batch (Test 2)
6. and the generated another AWR report
The batch is kicked off with a call to one package with the identical parameters we used in prod. What I find odd is the number of executions for several SQL statements (2 shown here):
c2wr7xtqk46q4 - SELECT /*+ INDEX(B PERIODICLOADACC_IDX2) */ A.FUNDID, A.FROMENTITY, A.TOENTITY ...
Prod: 577 executions Test 1: 1440 executions Test 2: 2938 executions
169ajawwm0m8q - ELECT NVL(MIN(PRICEDATE), :B6 ) FROM UHBALLEDGERTBL WHERE FUNDID ...
Prod: 2907 executions Test 1: 1455 executions Test 2: 2898 executions
I would expect the number of executions to be identical in each.
I have run several similar exercises before, and the number of executions for a SQL statement for the same batches (with minor performance tweaking) have always been the same in comparative AWR reports.
(Although even there I have found the occasional discrepancy, but usually out by 1 or 2, never double as was the case this time. Is it possible for AWR to 'mis-count' executions?)
Thanks,
Andreas