11G
Database Replay using the Database Control
User Rating: / 0
- Details
-
Parent Category: Articles
-
Created on Sunday, 28 March 2010 22:08
-
Last Updated on Monday, 12 March 2012 13:54
-
Published on Sunday, 28 March 2010 22:08
-
Written by Guy Lambregts
-
Hits: 4104
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
STEP 2 : Phase 1 is about the Worload Capture, Phase 2 is the Pre Processing and Phase 3 is the Workload Replay
STEP 3 No explanation
STEP 4 : The Workload can be filtered ( with include and exclude options )
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
STEP 6 The Workload Capture starts
STEP 7 No explanation
STEP 8 : Setup the workload schema and simulate some load
STEP 9 The Workload is in progress
STEP 10 We stop the Workload Capture at will
STEP 11 We export the AWR data, note that AWR snapshots are automatically taken
STEP 12 We are ready for step 2 the pre processing
STEP 13 We refer to the directory which contains the Workload os files
STEP 14 The pre processing can start
STEP 15 The pre processing can start
STEP 16 The pre processing can start
STEP 17 The pre processing is done
STEP 18 Phase 3 the Database replay can start
STEP 19 Phase 3 the Database replay can start
STEP 20 Phase 3 the Database replay can start
STEP 21 Phase 3 the Database replay can start
STEP 22 Phase 3 the Database replay can start
STEP 23 Phase 3 the Database replay can start, configuration of replay clients
STEP 24 No additional explanation
STEP 25 No additional explanation
STEP 26 No additional explanation
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