PowerPoint Presentation

Size: px

Start display at page:

Download "PowerPoint Presentation"

지유 이
5 years ago
Views:

1 Oracle 10g Platform in Windows Platform

3 ,, Oracle 10g Application Server Oracle 10g.NET Oracle 10g. Why not?

5 Enterprise Manager Grid Control Application Server Grid Database Grid Storage Grid

7 Server 1 Instance A Server 2 Instance B Database SERVER failure - your database remains available

9 STATISTICS_LEVEL = TYPICAL or ALL EM SQL*Plus (SGA) Fixed Dictionary view view MMON Workload Repository ADDM

10 Automatic Storage Management (Striping) 3 rd Party

11 Oracle RAC 10g Failure Notification ( with Oracle Application Server 10g) Database App. Server Total Failover Detection Recovery Time Oracle9i < minute minutes minutes Oracle 10g seconds seconds seconds

13 ORACLE 10g ias IS AN ENTERPRISE APP SERVER

14 Business Applications Oracle ebusiness Suite Collaborative Applications Oracle Collaboration Suite Enterprise Portal Oracle JDeveloper 10g Any Data Source Mobile & Wireless S Y S T E M S Mgmt. Application Dev. Framework Portal Bus. Intelligence Integration Broker Enterprise Application Server Grid Computing Infrastructure S E C U R I T Y & ID Mgmt. Web Services B2B Business Intelligence Oracle Application Server 10g Applications

16 J2EE Applications Business Intelligence Web Services Wireless Enterprise Integration Portals

17 Browser Wireless & Mobile Web Cache Netscape IIS OHS Apache Servlet / JSP EJB / BC4J Perl / PHP C/C++ PL/SQL XML / XSL Forms Packaged Apps Any Data Source

18 Browser Wireless & Mobile Business-to- Business SOAP HTTP/S UDDI Registries Apache SOAP Handler Servlet SOAP Handler Servlet SOAP Handler Servlet Transactions Messaging Stateless Java Class Stateful Java Class Stateless Session EJB PL/SQL Stored Proc. Message Driven EJB Naming / Directory Security JDBC JMS JCA HTTP Pooling Any Data Source Packaged Apps HTML / XML Streams

19 E-Business Suite Business Activity Monitoring Exchanges Business Process Management Application Adapters Transaction Management Intelligent Routing 3 rd Party Apps Transformation Any Data Source Logging Validation Security Monitoring Custom Apps Messaging Systems.NET products are not integrated Need 12 products for equivalent Oracle10g functionality

20 Packaged Apps Internet / intranet Users Page Assembly Engine Personalization Portal Portlet Engine Runtime (User, Session, Management Any Data Source Wireless & Mobile Any Web Site

21 SMS Enterprise Apps THTML Device Transformers Content Adapters WML Runtime Any Database CHTML Personalization Service Manager HTML Any Web Site

22 Oracle Reports Adhoc Query Custom Reports Discoverer OracleAS Personalization Data Sources: CRM ERP Data Marts Databases OLAP Data Mining Web Server logs ClickStream Intelligence.NET weak on BI [Microsoft SQL Server] lacks sophisticated data mining tools and algorithms -

23 Caching Performance Scalability Systems User Availability Management /Security Management

26 Database edition Max Processors Min Users Real Application Clusters Standard Edtion One 2 5 N/A Standard Edition 4 5 Included Enterprise Edition Unlimited 25 Option Oracle Database 10g Rated "Excellent" by InfoWorld Excellent 8.8 criteria score weight Manageability 9 25% Performance 8 25% Availability 9 20% Scalability 9 20% Value 9 10%

28 No of Users 5 10 No of Processors 1 Oracle SE1 $745 $1,490 Oracle SE1 $4,995 SS SE $1,489 $2,249 SS SE $4,999 Component List Price Support Upgrades SE1 $4,995 $350 $750 1 $6,095 SS SE $4,999 $1,225 $1,250 $7,474 2 $9,990 $9,998 5 $10,490 $17,374

30 No of Users 5 10 No of Processors 3 4 Oracle Database 10g Standard Edition $1,500 $3,000 Oracle Database 10g Standard Edition $45,000 $60,000 SQL Server 2000 Enterprise Edition $7,112 $7,842 SQL Server 2000 Enterprise Edition $59,997 $79,996

31 ORACLE10g RAC MS Federated SQL Server A-Z A-F A-E G-L F-K M-R L-P S-Z Q-S T-Z

33 Database Edition EE & Options EE SE SE One Personal Lite Size of Business/Use Large (4+ CPU s) Large (4+ CPU s) Medium sized (4 CPU s) Small/departmental (1-2 CPU s) Laptop, Desktop PDA s, Mobile Devices No of Users > 1,000 > 1, ,000 <

34 Annual Database Security Cost (Per User) Oracle Database $13 Microsoft SQL Server $53 0 $20 $40 $60 * : INPUT, November 2002

35 TOPS $/TOPS OAS 10G (Linux) 1037 BEA WL (Win2K) 695 BEA WL (Linux) 448 IBM WS (Win2K) $151 OAS 10G (Linux) $200 BEA WL (Win2K) $263 BEA WL (Linux) $648 IBM WS (Win2K)

36 Oracle ias Microsoft.NET Application Server $80,000 $4,000 - Windows Server 2003 Enterprise Portal Included $35,800 - SharePoint Portal Server B2B Integration Included $25,000 - BizTalk Server Legacy Integration Included $2,500 - Host Integration Server Business Intelligence Included $13,000 - Commerce Server Load balancing Included $3,000 - Application Center Database $40,000 * $20,000 - SQL Server Operating System $4,000 * Included - Windows Server 2003 Total $64,000 $103,300 * Oracle deployment includes Oracle Database & Windows Server 2003 All prices are list; Configuration: 100 users, 4 CPUs, 4 developers Source: Public sources

37 Gartner MQ : Oracle is Leader & the World s Fastest Growing APS

39 Oracle process SGA SGA contains db buffers, log buffers shared pool, other memory allocations Code Each thread consists of PGA, stack, other memory allocations Background and foreground threads

42 Component ORACLE Multi-version read consistency Non-Escalating row-level locking B-Tree indexes Index-organized Tables Bitmap indexes Bitmap Join Indexes Range,Hash, List and Composite Partitioning Local and global indexes SS SE Shared read locks or dirty reads Locks escalate RAC B-Tree indexes Clustered Indexes Not supported Not supported Not supported local indexes Queries,INSERT,DELETE,UPDATE Materilized Views MERGE Multi-table INSERT Pipelined table Functions QUERY Only Indexed Views Not supported Not supported Not supported

43 ½

Oracle is 12% faster and 12% cheaper than Microsoft on identical 4 processor HP hardware Version Performance Price Performance Oracle 10g 136,110.98 $4.09 Microsoft 2000 121,065.13 $4.

44 Oracle is 12% faster and 12% cheaper than Microsoft on identical 4 processor HP hardware Version Performance Price Performance Oracle 10g 136, $4.09 Microsoft , $4.79 Platform CPUs OS Date HP rx5670 HP rx Itanium 2 1.5GHz 4 Itanium 2 1.5GHz Red Hat Linux Windows AS /5/2003 4/24/2003 Source: Transaction Processing Council ( As of September 19, 2003: 1 HP Integrity rx5670, (Oracle Database 10g Standard Edition), 136, tpmc, $3.94/tpmC, available March 5, HP Integrity rx5670, (Microsoft SQL Server bit), 121, tpmc, $4.49/tpmC, available August 1, 2003.

45 Source: Transaction Processing Council (TPC) A N N O U N C E M E N T World Record TPC-C Benchmark The world record TPC-C non-clustered Linux result of 609,467 tpmc, $6.78/tpmC was achieved on a NEC Express5800/Xd server with 32 Intel Itanium 2 processors at 1.5 GHz running Oracle Database 10g with SUSE LINUX Enterprise Server 9. This result outperforms the previously published Microsoft SQL Server 2000 result on the same server and is the best TPC-C 32-way result on Intel processors.

46 Intel Processors TPC-C 32-way Database Software Oracle Microsoft Performance (tpmc) Price Performance ($/tpmc) Platform Number of CPUs CPU type OS

49 ERP WEB DW CRM

50 ORACLE RAC MS SQL Server A-Z A-F A-E G-L F-K M-R L-P S-Z Q-S T-Z

51 High-Speed Interconnect Node A Database buffers BSP Data transfer Database buffers Database file Node B Select Request for Block Cache A Read Read Write Write Lock Status Block in Cache B Read Write Read Write

52 Browser Wireless & Mobile Load Balancers (or Web Cache) Cluster 1 J2EE Application A Session State Shared Data Sources Apache Web Servers w/ Load Balancing Internet / intranet Users Cluster 2 J2EE Application B Session State Shared

53 Web Server Service Reporting Order_Entry O10G1 O10G2 O10G3 O10G4 O10G5 O10G6 Preferred Available DB_NAME

54 Reporting Test Order Entry

55 Reporting Order Entry

56 Reporting Order Entry

57 Reporting Test Order Entry

58 Reporting Test Order Entry

59 Reporting Order Entry

60 Reporting Order Entry

61 Reporting Order Entry

62 DEMO node13

63 Browser Wireless & Mobile Load Balancers (or Web Caches) Cluster 1 J2EE Application A Session State Shared Oracle HTTP Server w/ Load Balancing Oracle10g RAC Internet / intranet Users

66 ASP.NET VB.NET C# C++.NET Any.NET Client OLE DB.NET Oracle OLE DB ODBC.NET Oracle ODBC Oracle.NET Data Provider Oracle Database 10g

71 using System; using Oracle.DataAccess.Client; class Example { OracleConnection con; void Connect() { con = new OracleConnection(); con.connectionstring = "User Id=scott;" + "Password=tiger;" + "Data Source=oracle"; con.open(); Console.WriteLine( "Connected to Oracle" + con.serverversion); } void Close() { con.close(); con.dispose(); } static void Main() { Example example = new Example(); example.connect(); example.close(); } }

72 ODP.NET powered by TAF DEMO SharpDevelop.NET framework ODP.NET O10G1 Oracle 10g O10G2 Oracle 10g

76 10gAS Grid Control

77 DB + OS Monitor

78 Schema Management Memory Management Data Export & Import Database Parameter Management User Management Grid Control Backup & Recovery Space Management

79 SQL? SQL? SQL Workload DBA SQL DBA

80 & SQL Database Management

81 DEMO A D D M Automatic Tasks Grid Control Automatic Workload Repository

82 Buffer Cache Large Pool SQL Cache Java Pool sort Buffer Cache Large Pool SQL Cache Java Pool sort SGA Pool PGA Pool DB_CACHE_SIZE SHARED_POOL_SIZE LARGE_POOL_SIZE JAVA_POOL_SIZE SGA_TARGET

83 Management Interface Oracle Mgmt UI Other Mgt UI s User Defined/4GL HTML Oracle Management Service Tiny HTML Web Server EM2Go App JSP s ( Cabo framework) OC4J Container Management Console Custom Servlets Management Servlets JDBC Management Repository Custom Servlets

84 DEMO

86 System Visitors Historical Diagnostics Transaction Tracing

Ask The Expert

Ask The Expert Net Web Grid CPU, Main Memory Hard Disk Hardware, DB Hyper Text WWW DB,. Source : http://www.gridforumkorea.org, http://www.hpcnet.ne.kr/ http://www.accessgrid.or.kr/ Search for ExtraTerrestrial Intelligence