Oracle Database IBM DB2 UDB : 2005 9
Oracle Database IBM DB2 UDB :... 3... 4 Oracle Database Oracle Database IBM DB2... 4... 5... 5... 6... 7... 9... 10... 10 Oracle Database 10g Oracle Real Application Clusters... 10 DB2... 11... 11 OLTP... 12... 14... 16... 16... 17 Oracle... 17 DB2... 18 :... 19... 19 AWR... 20 ADDM... 20 SQL... 21... 21 Oracle Database IBM DB2 UDB : 2
Oracle Database IBM DB2 UDB : Oracle Database IBM DB2 UDB Oracle Database ISV Oracle Oracle Database IBM DB2 UDB : 3
Oracle Database DB2 Oracle Database DB2 UDB Real Application Clusters DB2ESE B SQL MTTR SQL I/O 1: Oracle Database Oracle Database IBM DB2 Oracle Database IBM DB2 1 Oracle Database IBM DB2 UDB : 4
DB2 UDB Enterprise Server Edition (ESE) Version 8.2 DB2 DB2 UDB DB2 UDB ESE Version 8.2 Oracle Oracle Database Oracle Database 10g Oracle Database Oracle Database 10g Enterprise Edition 2 OLTP Oracle Database Oracle Database DB2 Oracle Oracle Database DB2 Oracle DB2 1 Oracle Oracle Oracle Oracle Database Winter Corporation 1 10 Unix OLTP 1 Oracle 1 DB2 1 http://www.wintercorp.com/vldb/2003_topten_survey/toptenwinners.asp Oracle Database IBM DB2 UDB : 5
Oracle Database 10g DB2 2: 2 1 2 Oracle UNDO Oracle UNDO DB2 DB2 1 Oracle Database IBM DB2 UDB : 6
DB2 IBM DB2 UDB UR 2 Oracle Oracle SAP DB2 SAP SAP SAP Oracle Oracle Oracle DB2 DB2 3 2 IBM DB2 Universal Database Poring Guide, Oracle to DB2 UDB for Windows, OS/2 and Unix, Version7.2 p. 51 http://www-106.ibm.com/developerworks/db2/library/techarticle/0205wilkins/0205wilkins.pdf 3 IBM DB2 Universal DatabaseAdministration Guide: Performance, Version 8 p. 49 Oracle Database IBM DB2 UDB : 7
4 DB2 T1 T1 T1 5 DB2 Magazine ERP 1 6 OS/390 DB2 Unix Windows DB2 DB2 LOCKLIST 7 2 8 1 Oracle DB2 UDB Oracle to DB2 Migration Comparison p.58 Oracle DB2 UDB OracleDB2 UDB DB2 UDB 1 4 IBM Redbooks DB2 UDB/WebSphere Performance Tuning Guide p. 128 http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246417.pdf 5 IBM DB2 Universal Database Poring Guide, Oracle to DB2 UDB for Windows, OS/2 and Unix, Version7.2 p. 52 http://www-106.ibm.com/developerworks/db2/library/techarticle/0205wilkins/0205wilkins.pdf 6 DB2 Magazine http://www.db2mag.com/db_area/archives/1999/q2/99sp_yevich.shtml 7 IBM Redbooks DB2 UDB/WebSphere Performance Tuning Guide p. 116 http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246417.pdf 8 IBM DB2 Universal Database Administration Guide: Performance, Version 8 p. 51 Oracle Database IBM DB2 UDB : 8
9 Oracle Oracle I/O Oracle DB2 B Oracle Oracle Oracle OLTP DB2 B 10 DB2 Oracle DB2 - - - - 3: Oracle 1 2 B DB2 DB2 Oracle Oracle DB2 9 IBM DB2 Universal Database Poring Guide, Oracle to DB2 UDB for Windows, OS/2 and Unix, Version7.2 p. 52 http://www-106.ibm.com/developerworks/db2/library/techarticle/0205wilkins/0205wilkins.pdf 10 Bloor Research 2001 Database Report p.84 DB2 B Oracle Database IBM DB2 UDB : 9
ROWID ROWID LOB DB2 DB2 Oracle DB2 Oracle Database 10g Oracle Real Application Clusters Real Application Clusters RAC Oracle Database Oracle Database 10g Oracle Real Application Clusters Oracle Database 10g Real Application Clusters Cache Fusion OLTP DSS Oracle Cache Fusion Cache Fusion Oracle Database IBM DB2 UDB : 10
I/O DB2 DB2 1 1 Oracle Database 10g Oracle Real Application Clusters OLTP DSS Oracle E-Business Suite DB2 DB2 UDB ESE Oracle Database IBM DB2 UDB : 11
OLTP 2 Oracle Database 10g Oracle Real Application Clusters DB2 EEE 2 2 IPC 4: 2 DB2 2 DB2 2 1 1 2 OLTP Oracle Database 10g Real Application Clusters I/O Real Application Clusters SAP Sales 5% Real Application Clusters GCS Real Application Clusters DB2 Oracle Database IBM DB2 UDB : 12
DB2 DB2 Real Application Clusters B DB2 2 1 2 Real Application Clusters Real Application Clusters Oracle Net DB2 Real Application Clusters DB2 DB2 Oracle Database IBM DB2 UDB : 13
OLTP Oracle SAP PeopleSoft Siebel 2 2 11 SAP PeopleSoft Oracle E-Business Suite PeopleSoft SAP DB2 Oracle Database 10g Real Application Clusters OracleReal Application Clusters RAC[ ][ ] RAC Oracle9i RAC 12 11 DB2 UDB EEE as an OLTP DatabaseGene Kligerman DB2 and Business Intelligence Technical Conference Las Vegas Nevada 2000 10 16-20 12 IBM Redpaper Implementing Oracle9i RAC with Linux on IBM @server xseries servers P.3 http://publib-b.boulder.ibm.com/cgi-bin/searchsite.cgi?query=linux+and+oracle Oracle Database IBM DB2 UDB : 14
1: Oracle Database Real Application Clusters Oracle E-Business Suite Oracle Applications 2 2 4 2 2296 4 4368 1.9 2: Oracle Database Real Application Clusters SAP SAP R/3 SD 1 2 2 4 1.8 2001 5 Orlando International DB2 User's Group Conference IBM Gene Kligerman DB2 EEE as an OLTP Database OLTP DB2 Kligerman 2 4 1 Oracle Database IBM DB2 UDB : 15
Oracle Database 10g Oracle ROWID 1 ROWID WHERE 2 DB2 RID RID Oracle BB I/O 13 13 Oracle10g: Oracle Database IBM DB2 UDB : 16
Oracle 2 DML Oracle Oracle Database 10g 14 Oracle -- Oracle 3 14 Oracle DatabasePartitioning in Oracle Database 10g Oracle Database IBM DB2 UDB : 17
1 1 1 Oracle / DB2 Oracle DB2 Oracle DB2 5: DB2 15 Oracle Oracle DB2 DB2 15 IBM DB2 Universal Database, SQL Reference, Volume 2, Version 8 p.373 http://ftp.software.ibm.com/ps/products/db2/info/vr8/pdf/letter/db2s2e80.pdf Oracle Database IBM DB2 UDB : 18
DB2 OLTP DB2 16 : Oracle ETL 1 SQL SQL 1 DML INSERT...SELECT 17 1 SQL DB2 INSERT Oracle DB2 Oracle Database 10g Oracle Oracle Database what-if MTTR / DB2 DB2 16 DB2 http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0405wilkins/index.html 17 OracleDSSOracle9i http://otndnld.oracle.co.jp/products/iserver/oracle9i/pdf/dss_enviroment_9i.pdf Oracle Database IBM DB2 UDB : 19
DB2 Oracle Oracle DB2 Oracle Database 10g SQL DB2 6: AWR Oracle DatabaseAWR Oracle Database AWR Oracle Database 10g 18 DB2 ADDM ADDM AWR ADDM DB SQL 10g ADDM ADDM ADDM DB DB2 18 AWR ADDM Oracle Oracle Database IBM DB2 UDB : 20
SQL Oracle Database 10g SQL 19 SQL Automatic Tuning Optimizer Oracle Query Optimizer SQL Automatic Tuning OptimizerSQL Automatic Tuning Optimizer SQL SQL 20 Automatic Tuning Optimizer SQL 1 SQL SQL SQL DB2 SQL SQL Oracle Database 10g Oracle Database 10g Oracle 19 SQL Oracle SQL 20 Oracle SQL Oracle Database IBM DB2 UDB : 21
Oracle Database IBM DB2 UDB : 2005 9 : Hervé Lejeune : Jenny Tsai Valerie Kane Vineet Buch Bill Kehoe Sashikanth Chandrasekaran Ray Glasstone Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. : : +1.650.506.7000 : +1.650.506.7200 www.oracle.com Oracle Copyright 2005 Oracle Corporation All rights reserved. Oracle Oracle Corporation