Oracle 10g Platform in Windows Platform
,, Oracle 10g Application Server Oracle 10g.NET Oracle 10g. Why not?
Enterprise Manager Grid Control Application Server Grid Database Grid Storage Grid
Server 1 Instance A Server 2 Instance B Database SERVER failure - your database remains available
STATISTICS_LEVEL = TYPICAL or ALL EM SQL*Plus (SGA) Fixed Dictionary view view MMON Workload Repository ADDM
Automatic Storage Management (Striping) 3 rd Party
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
ORACLE 10g ias IS AN ENTERPRISE APP SERVER
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
J2EE Applications Business Intelligence Web Services Wireless Enterprise Integration Portals
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
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
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
Packaged Apps Internet / intranet Users Page Assembly Engine Personalization Portal Portlet Engine Runtime (User, Session, Management Any Data Source Wireless & Mobile Any Web Site
SMS Enterprise Apps THTML Device Transformers Content Adapters WML Runtime Any Database CHTML Personalization Service Manager HTML Any Web Site email
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 -
Caching Performance Scalability Systems User Availability Management /Security Management
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%
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
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
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
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 400 1,000 < 400 1 1
Annual Database Security Cost (Per User) Oracle Database $13 Microsoft SQL Server $53 0 $20 $40 $60 * : INPUT, November 2002
TOPS $/TOPS 1200 1000 800 600 400 200 0 1165 OAS 10G (Linux) 1037 BEA WL (Win2K) 695 BEA WL (Linux) 448 IBM WS (Win2K) 700 600 500 400 300 200 100 0 $151 OAS 10G (Linux) $200 BEA WL (Win2K) $263 BEA WL (Linux) $648 IBM WS (Win2K) http://www.spec.org/osg/jappserver2002
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
Gartner MQ : Oracle is Leader & the World s Fastest Growing APS
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
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
½
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.79 Platform CPUs OS Date HP rx5670 HP rx5670 4 Itanium 2 1.5GHz 4 Itanium 2 1.5GHz Red Hat Linux Windows AS 2003 9/5/2003 4/24/2003 Source: Transaction Processing Council (http://www.tpc.org). As of September 19, 2003: 1 HP Integrity rx5670, (Oracle Database 10g Standard Edition), 136,110.98 tpmc, $3.94/tpmC, available March 5, 2004. 2 HP Integrity rx5670, (Microsoft SQL Server 2000 64-bit), 121,065.13 tpmc, $4.49/tpmC, available August 1, 2003.
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.
Intel Processors TPC-C 32-way Database Software Oracle Microsoft Performance (tpmc) Price Performance ($/tpmc) Platform Number of CPUs CPU type OS
ERP WEB DW CRM
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
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
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
Web Server jdbc:oracle:oci@reporting jdbc:oracle:oci@order_entry Service Reporting Order_Entry O10G1 O10G2 O10G3 O10G4 O10G5 O10G6 Preferred Available DB_NAME
Reporting Test Order Entry
Reporting Order Entry
Reporting Order Entry
Reporting Test Order Entry
Reporting Test Order Entry
Reporting Order Entry
Reporting Order Entry
Reporting Order Entry
DEMO node13
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
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
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(); } }
ODP.NET powered by TAF DEMO SharpDevelop.NET framework ODP.NET O10G1 Oracle 10g O10G2 Oracle 10g
10gAS Grid Control
DB + OS Monitor
Schema Management Memory Management Data Export & Import Database Parameter Management User Management Grid Control Backup & Recovery Space Management
SQL? SQL? SQL Workload DBA SQL DBA
& SQL Database Management
DEMO A D D M Automatic Tasks Grid Control Automatic Workload Repository
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
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
DEMO
System Visitors Historical Diagnostics Transaction Tracing