Oracle Database 11g Oracle Real Application …

1 Oracle Database 11g Oracle real Application testing NEC 2006 7 IT IT IT real IT PLATFORM real IT PLATFORM NEC ( ) Oracle Database 10g Oracle GRID 2006 11 Oracle GRID Center ( ) Oracle Database 11g Oracle real Application testing ( RAT) NEC Oracle GRID Center ..2 1.. 4 2.. 5 5 .. 5 iStorage .. 6 WebSAM .. 7 Oracle real Application testing (RAT).

2 9 Transparent Data Encryption (TDE) .. 9 Oracle real Application Clusters (RAC)3.. 10 4.. 11 .. 11 .. 11 .. 13 .. 13 5.. 15 Database Replay .. 15 .. 15 .. 19 .. 29 6.. 30 Database Replay 1 (TDE ) .. 30 .. 30 .. 31 .. 35 7.. 37 Database Replay 2 (RAC ) .. 37 .. 37 .. 41 .. 46 8.. 47 SQL Performance Analyzer .. 47 .. 49 .. 51 .. 56 9.. 57 31. IT 7 8 Oracle Database 11g Oracle real Application testing ( RAT) Oracle Database 11g RAT RAT Database Replay SQL Performance Analyzer RAT 42.

3 SIGMABLADE-M NEC SIGMABLADE FAN FibreChannel LAN IT 2-1. SIGMABLADE-M iStorage D3-10 iStorage D3-10 - - - Web - ( )

4 5 - RAID-6 RAID-TM 2-2. ( ) WebSAM SigmaSystemCenter SigmaSystemCenter ( ) NEC OS TCO - OS OS 8 - 1 6 - GUI - Windows Linux HP-UX OS OS Windows XP SIGMABLADE

5 2-3. SSC Oracle real Application testing (RAT) Oracle real Application testing (RAT) Oracle real Application testing 2 Database Replay SQL Performance Analyzer Database Replay Database Replay (1) synchronization Transaction true false ( true) 7(2) connect_time_scale 100( ) (3) think_time_scale SQL 100( ) (4) think_time_auto_correct SQL SQL true false ( true) Oracle Enterprise Manager Oracle Database 11g 2-4.

6 Database Replay SQL Performance Analyzer SQL SQL Database Replay Oracle Enterprise Manager SQL 8 2-5. SQL Performance Analyzer Transparent Data Encryption (TDE) Transparent Data Encryption ( TDE) Oracle Database 10g Release 2 ( ) Oracle Advanced Security TDE / Oracle Database Oracle Wallet Oracle Database 11g Release 1 ( ) TDE Oracle real Application Clusters (RAC) Oracle real Application Clusters ( RAC)

7 Oracle Grid Computing RAC Oracle real Application Clusters 93. SIGMABLADE 8 CPU RAT Database Replay Database Replay Transparent Data Encryption TDE . Oracle real Application Clusters RAC SQL Performance Analyzer SQL Tuning Set Oracle Database 3-1.

8 ( ) 3-2. ( ) 104. 2-1. [ ] 2-1. Replay Client Database Test Program (Single or RAC) (Client) Database Replay n0c-13 n0c-11 n0c-13 Transparent Data Encryption TDE Database Replay real Application Clusters (RAC) n0c-12 n0c-15 18 n0c-15 n0c-12 n0c-14 N/A SQL Performance Analyzer 11 2-2. SIGMABLADE-M CPU Express5800 120Bb-6 8 CPU (R)Xeon(R) 5160 3 GHz 2 /CPU 8GB/CPU 2-3.

9 IStorage D3-10 400MB/s 2 4GB SAS 147GB(15,000rpm) 12 2-2. LUN 1 2-2 iStorage D3-10 147GB 10 RAID50 RAID1 LUN LU 2-4 . LUN 12 Oracle REDO ASM 2-5. OS Red Hat Enterprise Linux Version4 Update5 Advanced Server Kernel Oracle Clusterware 11g Release 1 ( ) Oracle Database 11g Release 1 ( ) Enterprise Edition Oracle real Application Clusters Option Oracle Advanced Security Option Oracle real Application testing Option WebSAM SigmaSystemCenter Oracle Enterprise Manager 11g Database Control ( ) 13 WebSAM SigmaSystemCenterOracle Enterprise Manager 10g Grid Control DB BLADEL2 SWITCH#0 2-3.

10 SIGMABLADE 8 CPU 4 SIGMABLADE 4 L2 4 NIC 1 NIC(Eth0) 2 NIC(Eth1 Eth2) Active-Standby bonding Oracle real Application Clusters Public LAN(eth0): 1000 Base-TX 1 Private LAN(eth1,2): 1000 BaseTX 2(Act-Standby bonding)L2 SWITCH#2L2 SWITCH#1 BLADEBLADEBLADEBLADEBLADEBLADEBLADE 145. Database Replay Database Replay user system CPU * synchronization - SQL * think_time_scale * think_time_auto_correct * * Oracle Database DB DB DB