04 | 11 | 2024
Latest Articles
Popular Articles

11G

Database Replay using the Database Control

User Rating:  / 0
PoorBest 

Database replay using the Database Control

 

SQL> startup;

ORACLE instance started.

Total System Global Area  313860096 bytes
Fixed Size                  1347020 bytes
Variable Size             192938548 bytes
Database Buffers          113246208 bytes
Redo Buffers                6328320 bytes
Database mounted.
Database opened.
SQL> show parameter memory_target

NAME                                 TYPE        VALUE


memory_target                        big integer 300M
SQL> show parameter db_file_multiblock_read_count

NAME                                 TYPE        VALUE


db_file_multiblock_read_count        integer     16
SQL> create restore point before_workload_08 guarantee flashback database;

Restore point created.

 

STEP 1 On the "Software and Support" page we find the "Database Replay" option

Replay1

 

STEP 2 : Phase 1 is about the Worload Capture, Phase 2 is the Pre Processing and Phase 3 is the Workload Replay

Replay2

STEP 3 No explanation

Replay3

STEP 4 : The Workload can be filtered ( with include and exclude options )

Replay4

STEP 5 Note that the capture process will write files to a OS file system which must be known as a directory at database level

Replay5

STEP 6 The Workload Capture starts

Replay6

STEP 7 No explanation

Replay7

 

STEP 8 : Setup the workload schema and simulate some load

STEP 9 The Workload is in progress

Replay8

STEP 10 We stop the Workload Capture at will

Replay9

STEP 11 We export the AWR data, note that AWR snapshots are automatically taken

Replay10

STEP 12 We are ready for step 2 the pre processing

Replay11

STEP 13 We refer to the directory which contains the Workload os files

Replay12

STEP 14 The pre processing can start

Replay13

STEP 15 The pre processing can start

Replay14

STEP 16 The pre processing can start

Replay15

STEP 17 The pre processing is done

Replay16

STEP 18  Phase 3 the Database replay can start

Replay17

STEP 19 Phase 3 the Database replay can start

Replay18

STEP 20 Phase 3 the Database replay can start

Replay19

STEP 21 Phase 3 the Database replay can start

Replay20

STEP 22 Phase 3 the Database replay can start

Replay21

STEP 23 Phase 3 the Database replay can start, configuration of replay clients

Replay22

STEP 24 No additional explanation

Replay23

STEP 25 No additional explanation

Replay24

STEP 26 No additional explanation

Replay25

 

At this stage it hanged and I was forced to continue using the CLI

Session 1

C:\Users\Guy>wrc mode=calibrate replaydir=C:\oracle\Workload

Workload Replay Client: Release 11.1.0.7.0 - Production on Thu Jul 23 22:13:46 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Report for Workload in: C:\oracle\Workload


Recommendation:
Consider using at least 1 clients divided among 1 CPU(s)
You will need at least 7 MB of memory per client process.
If your machine(s) cannot match that number, consider using more clients.

Workload Characteristics:
- max concurrency: 2 sessions
- total number of sessions: 2

Assumptions:
- 1 client process per 50 concurrent sessions
- 4 client process per CPU
- 256 KB of memory cache per concurrent session
- think time scale = 100
- connect time scale = 100
- synchronization = TRUE


C:\Users\Guy>wrc system/[email protected] mode=replay replaydir=C:\oracle\Workload

Workload Replay Client: Release 11.1.0.7.0 - Production on Thu Jul 23 22:14:16 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Wait for the replay to start (22:14:16)
Replay started (22:15:06)
Replay finished (22:21:28)




session 2

SQL> begin
2  dbms_workload_replay.start_replay;
3  end;
4  /




PL/SQL procedure successfully completed.


Replay25



SQL> select id,name,status from  dba_workload_replays;

ID

NAME


STATUS

5
WORKLOAD_02
COMPLETED

3
REPLAY-PLATINUM-20090706214153
COMPLETED

16
REPLAY-PLATINUM-20090723220620
COMPLETED




DECLARE
l_report  CLOB;
BEGIN
l_report := DBMS_WORKLOAD_REPLAY.report(replay_id => 16,
format     => DBMS_WORKLOAD_REPLAY.TYPE_HTML);
END;
/



SQL> spool c:\oracle\workload\replay_report.html
SQL> select dbms_workload_replay.report(16,'HTML') from dual;
SQL> spool off