Real Application Testing (RAT); questions
Hi,
We are currently working on a missing involving RAT, both SPA and DB Replay.
The customer raised some questions and I was wondering if anybody has more detailed information to share?
FYI: we are using in most cases the API calls, as we don’t have an EMGC 11G available, only Database control.
h4. Q1: If the DB capture runs out of space, what would be the impact on Prod database
My response would be: no impact on the database as the recorder stops
Best Practice: create a separate location to store the recording
h4. Q2: What could be missing with RAT (SPA/DB Replay) --> gap analysis.
Reduce as most as possible the time needed by ADM (Development Team) in order to validate database migration.
The database team wants to be as independent as possible of the development team in order to do the upgrade of the databases more autonomous. They want to have an idea on what they could be missing if they use SPA and DB Replay to make sure they don't miss anything which could have an impact on the developers after the upgrade. Are there any particular things that SPA and DB-replay would miss, and as a consequence aren't tested, which could lead to unhappy developers after the upgrade of the database.
h4. Q3: Difference between DB Replay and SPA (when to use which one)
h4. Q4: Oracle recommends shutting down database before recording workload, but may not be always possible (Web Banking), when and how to do it then?
My response was to start recording at a the lowest load time.
Any other ideas to minimize the impact of a running instance
h4. Q5: Does it need to filter out sys/system, rman,... Activities during captures?
h4. Q6: The capture report is showing 5 user calls captured with Errors, but I can’t find any related information on what went wrong.
To what is this related?
Captured Workload Statistics
• 'Value' represents the corresponding statistic aggregated across the entire captured database workload.
• '% Total' is the percentage of 'Value' over the corresponding system-wide aggregated total.
Statistic Name Value % Total
DB time (secs) 7.77 10.43
Average Active Sessions 0.03
User calls captured 1713 9.09
User calls captured with Errors+_ 5
Session logins 23 32.39
Transactions 33 3.74
h4. Q7: During the capture we can execute an export AWR, but we also need to do an import AWR somewhere, and this is not documented on how this is done in the RAT User Guide.
Can you comment on how this process is working in order to do some proper reporting.