Cache_cny.ppt [읽기 전용]

Size: px

Start display at page:

Download "Cache_cny.ppt [읽기 전용]"

인화 가
5 years ago
Views:

2 Application Server iplatform

3 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

4 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

5 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)

6 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

7 Oracle9i Application Server Web Caching Overview Oracle9iAS

8 Oracle9iAS Web Cache 3 Key Points

9 ? / - Fail-Over #, URL In-memory hash table : 9i Web Cache App Servers Database

10 ? / - Fail-Over Subsequent requests are served from the Web Cache #, URL In-memory hash table 9i : Web Cache App Servers Database

11 (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

12 Client Browser Internet 9i JSPs Servlets/ EJB 100s Milliseconds per request Stored Procedures

13 : Dynamic Caching Client Browser Oracle9i Database Internet Oracle9iAS Web Cache Web App Servers 9i 0.2 Milliseconds per request request request.

14 Oracle Web Cache - Key Concepts

15 / - / GET URL personalization gzip

16 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)

Employee/Customer Same URL Different cookie value $0.00 $30.

17 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 : 9i Web Cache App Servers Database

18 Multi-version URLs URL, $0.00 $39.95

19 Session-Encoded URLs URL url URL + Session A Session B

Session-Encoded URLs Session A http://store.oracle.com/cec/cstage?

20 Session-Encoded URLs Session A Session B

21 In-cache Personalization personalized attributes -, - HTML Tag - WEB CACHE TAG - personalized attribute url - & personalized attribute - - URL

22 In-cache Personalization <HTML> Welcome to the Oracle Store  anonymous ... </HTML> The URL/Cookie has the Personal Value

23 Consistency Client Browser Programmatic Trigger Internet 9i Web Cache App Servers Database Invalidation - - Manual or Scripted Admin Console Data Center HTTP Invalidation,,, DB XML

24 - refresh. - refresh. - refresh. Site Capacity requests/sec Previous content 100 Invalidation Invalidation With Heuristics Without Heuristics Time Time New content

25 - & Fail-Over App Servers 100 App Servers Oracle Web Cache Oracle Web Cache 9i 9i

26 GUI

27 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

28 Oracle.com - Fastest Site on the Internet Deployed Oracle Web Cache

29 Summary Try it! Download Oracle Web Cache from

30 Oracle9i Application Server Database Caching Overview Oracle9iAS

31 ? SQL Query DB. 9i : Oracle9iAS Database Cache

32 Oracle9iAS DB Main-memory Databases : Import/export of data Synchronization Customer : Import/export of data Synchronization

33 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

34 Oracle9iAS Database Cache - Key Concepts Cache hits / misses PL/SQL

35 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.

36 . 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

37 PL/SQL DB Studio. freespace.

38 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

39 OEM : Viewing Hit / Miss Statistics Hit/Miss Status SQL query count SQL query text User

40 OEM : Viewing Hit / Miss Performance Cache Hits/Misses Percentages Rates System Utilization Cache Utilization

41 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

42 Database Cache Query read-only

43 Oracle Database Cache Summary Is / Does: Is NOT / Does NOT:.. read-only DML. Is for applications to process SQL....

44 Oracle9iAS Cache Summary Oracle9iAS....

Portal_9iAS.ppt [읽기 전용]

Portal_9iAS.ppt [읽기 전용] Application Server iplatform Oracle9 A P P L I C A T I O N S E R V E R i Oracle9i Application Server e-business Portal Client Database Server e-business Portals B2C, B2B, B2E, WebsiteX B2Me GUI ID B2C