Application Server iplatform
Oracle9 A P P L I C A T I O N S E R V E R i Improving Performance and Scalability with Oracle9iAS Cache
Oracle9i Application Server Cache...
Oracle9i Application Server Web Caching Services Communication Services Presentation Services Business Logic Services Data Caching Services Servlets/JSPs Java Stored Procedures Web Cache Oracle HTTP Server Oracle Wireless Services XML/XSL PL/SQL PERL Portal Internet File System Discoverer Viewer Reports EJBs CORBA BC4J PL/SQL Database Cache 9i Oracle DB non-oracle DB Forms System Services Enterprise Manager, Advanced Security, OID (client)
Oracle9i Application Server Caching Technologies Web Cache Database Cache Internet / HTTP HTTP RDBMS Relational SQL Relational Replication Servlets EJB Oracle9iAS Web Cache Apache PL/SQL SQL Oracle9iAS Database Cache 9i
Oracle9i Application Server Web Caching Overview Oracle9iAS
Oracle9iAS Web Cache 3 Key Points
? / - Fail-Over #, URL In-memory hash table : http://store.oracle.com 9i Web Cache App Servers Database
? / - Fail-Over Subsequent requests are served from the Web Cache #, URL In-memory hash table 9i http://store.oracle.com : Web Cache App Servers Database
(Reverse Proxy) LAN Clients Proxy Cache at Firewall Server Acceleration with Oracle9iAS Web Cache Content Publisher A Corporate Intranet Content Publisher B Internet ISP Data Center Content Publisher C Proxy Cache at ISP Dial-up Clients
Client Browser Internet 9i JSPs Servlets/ EJB 100s Milliseconds per request Stored Procedures
: Dynamic Caching Client Browser Oracle9i Database Internet Oracle9iAS Web Cache Web App Servers 9i 0.2 Milliseconds per request request request.
Oracle Web Cache - Key Concepts
/ - / GET URL - http://www.foo.com?user_name=john&session_id=14291 - - personalization gzip
Cacheable vs. Non-Cacheable Cacheable with v 1.x Non Cacheable with v 1.x Text - HTML, XML, Word, etc. Images - GIF, JPEG, etc. Audio files, Video files, Applets Popular query results Dynamically created pages - ASPs, PSPs, JSPs, Servlets, CGI - HTTP requests with parameters - session ID embedded pages - pages with cookies - some personalized pages Update transactions Highly personalized pages (shopping cart views, account information) Streaming content (for now) HTTPS requests (for now) Multipart PDF (for now) FTP, NNTP, LDAP, etc. Partial pages (for now)
Multi-version page with Same URLs url - URL + cookie/client info = unique page - url - - HTTP request - : ( ) user_type : Employee/Customer Same URL Different cookie value $0.00 $30.00 Employee Customer : http://store.oracle.com 9i Web Cache App Servers Database
Multi-version URLs URL, $0.00 $39.95
Session-Encoded URLs URL url - http://www.foo.com/catalog.html?session_id=14213 - http://www.foo.com/catalog.html?session_id=21428 - URL + Session A http://store.oracle.com/cec/cstage?session_id=33436 Session B http://store.oracle.com/cec/cstage?session_id=33437
Session-Encoded URLs Session A http://store.oracle.com/cec/cstage?session_id=33436 Session B http://store.oracle.com/cec/cstage?session_id=33437
In-cache Personalization personalized attributes -, - HTML Tag - WEB CACHE TAG - personalized attribute url - & personalized attribute - - URL
In-cache Personalization <HTML> Welcome to the Oracle Store <!-- WEBCACHETAG= user_name"--> anonymous <!-- WEBCACHEEND-->... </HTML> The URL/Cookie has the Personal Value http://machine:port/zyz?username=
Consistency Client Browser Programmatic Trigger Internet 9i Web Cache App Servers Database Invalidation - - Manual or Scripted Admin Console Data Center HTTP Invalidation,,, DB XML
- refresh. - refresh. - refresh. Site Capacity requests/sec 7500 100 7500 Previous content 100 Invalidation Invalidation With Heuristics Without Heuristics Time Time New content
- & Fail-Over App Servers 100 App Servers Oracle Web Cache Oracle Web Cache 9i 9i
GUI
Oracle9iAS Customer at Work Oracle9iAS powers Oracle.com The fastest site on the Internet! 25% increase # visitors, 33% increase # hits 300% increase in average response time 100% of traffic served through Oracle9iAS
Oracle.com - Fastest Site on the Internet Deployed Oracle Web Cache
Summary Try it! Download Oracle Web Cache from http://otn.oracle.com
Oracle9i Application Server Database Caching Overview Oracle9iAS
? SQL Query DB. 9i : http://store.oracle.com Oracle9iAS Database Cache
Oracle9iAS DB Main-memory Databases : Import/export of data Synchronization Customer : Import/export of data Synchronization
How does it work? Web Server Tier Internet Web Server / Application Round trip network hop Intranet JDBC, ODBC, OCI, OLE Miss SQL Analyzer Web Clients IPC call Hit Cache Instance Refresh Cached data Advanced Synchronization Origin Database
Oracle9iAS Database Cache - Key Concepts Cache hits / misses PL/SQL
Cache Hit / Miss DB (Hit)/ (Miss) Miss no data found. Join Miss DML & DDL Miss Stored procedures Read only PL/SQL anonymous These will fail if DML or DDL exist Java Stored Procedures.
. Routing at OCI layer - OCI Miss Cache Local. Hit Cache Failure Hit Web Server + Application JDBC, ODBC, OCI, OLE Database Cache Cache Miss Origin Database Web Client Tier Web Server Tier Database Tier
PL/SQL DB Studio. freespace.
basic ( snapshot ) replication technology read-only materialized view. Configured via: DBA Studio Command Line(srvmgr, sqlplus) API calls refresh : When Scheduled Immediate Refresh Type Complete Incremental
OEM : Viewing Hit / Miss Statistics Hit/Miss Status SQL query count SQL query text User
OEM : Viewing Hit / Miss Performance Cache Hits/Misses Percentages Rates System Utilization Cache Utilization
Command line DBMS_ICACHE Database Cache. Command line svrmgrl sqlplus. API : DBMS_ICACHE.add_table( schema, table ) DBMS_ICACHE.add_plsql_object( schema, object ) : dbms_icache SQLPLUS> describe dbms_icache
Database Cache Query read-only
Oracle Database Cache Summary Is / Does: Is NOT / Does NOT:.. read-only DML. Is for applications to process SQL....
Oracle9iAS Cache Summary Oracle9iAS....