1 / 80

Release 11 i Apps DBA

Release 11 i Apps DBA. Teaching An Old Dog New Tricks. NCOAUG – Summer 2001 Chicago, IL Randy Giefer rgiefer@solutionbeacon.com. Welcome !. Welcome Overview (Apps DBA Delta Training For 11i) Audience Survey Presenter Introduction. Intended Audience. Technical

ady
Download Presentation

Release 11 i Apps DBA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Release 11i Apps DBA Teaching An Old Dog New Tricks NCOAUG – Summer 2001 Chicago, IL Randy Giefer rgiefer@solutionbeacon.com

  2. Welcome ! • Welcome • Overview (Apps DBA Delta Training For 11i) • Audience Survey • Presenter Introduction

  3. Intended Audience • Technical • - Database Administrator • - Apps System Administrator • - Developer • Current Application Release • - Release 10.7, 11.0.x, 11i (11.5.1 – 11.5.4) • Current User Interface(s) - Character, SmartClient, Citrix, OADM, NCA

  4. Today’s Goals • Educate • - High Level Summary • - Not The Complete, Exhaustive Source • - Provide Guidance And Direction • - Information To Build A Training Plan • Awareness, Try Not To Scare • Reference Materials ( Whitepaper available upon request ) rgiefer@solutionbeacon.com www.solutionbeacon.com

  5. What is Release 11i? The Biggest and Most Complex Release Ever ! • Increased Functionality • New Technology

  6. What is Release 11i? Increased Functionality … • Products – Applications Release 11i - over 152 162 products - over 15 17 product families • Workflow – Enabled (over 15 products) • Self-Service Web Apps • BIS • CRM

  7. What is Release 11i? New Technology … • Oracle 8i • Internet Computing Architecture • Java-Enabled!!! Combined Together… = Release 11i Technology Stack

  8. What is Release 11i? • Release 11i Technology Stack - Internet Computing Architecture (ICA) - Oracle 8i and 8i New Features • Release 11i Functionality

  9. What is Release 11i? • Release 11i Technology Stack -Internet Computing Architecture (ICA) - Oracle 8i and 8i New Features • Release 11i Functionality

  10. Release 11i Technology Stack Client Tier Middle Tier Database Server Tier

  11. Release 11i Technology Stack 8i Database Client Tier Middle Tier Database Server Tier

  12. Release 11i Technology Stack 8i Database JInitiator Client Tier Middle Tier Database Server Tier 8i ORACLE_HOME

  13. Release 11i Technology Stack 8i Database JInitiator Client Tier Middle Tier Simple so far, right? Database Server Tier 8i ORACLE_HOME

  14. Release 11i Technology Stack 8.1.6 Database Concurrent JInitiator Admin Apache Processing Server Server Forms Reports WebDB 2.2 Discoverer Server Server Listener Server * !! Release 11.5.1 !! Client Tier Applications Technology Stack Web HTTP Servers WebDB 2.5 Middle Tier * Optional 8.0.6 ORACLE_HOME 8.1.6 Web ORACLE_HOME Database Server Tier 8.1.6 ORACLE_HOME

  15. Release 11i Technology Stack 8.1.6 Database Concurrent JInitiator Admin Apache Processing Server Server Forms Reports Discoverer Server Server Server * !! Release 11.5.2, 11.5.3 !! Client Tier Applications Technology Stack Web HTTP Servers Middle Tier * Optional 8.0.6 ORACLE_HOME 8.1.6 iAS ORACLE_HOME Database Server Tier 8.1.6 ORACLE_HOME

  16. Release 11i Technology Stack 8.1.7 Database Concurrent JInitiator Admin Apache Processing Server Server Forms Reports Discoverer Server Server Server * !! Release 11.5.4 !! Client Tier Applications Technology Stack Web HTTP Servers Middle Tier * Optional 8.1.6 iAS ORACLE_HOME 8.0.6 ORACLE_HOME Database Server Tier 8.1.7 ORACLE_HOME

  17. Technology Stack Products !! Release 11.5.1 !! • Oracle8iEnterprise Edition 8.1.6 • Other Oracle Homes – App(8.0.6), WebDB(8.1.6) • WebDB 2.2 and WebDB 2.5 ! • JRE (Java Runtime Environment) 1.1.8 • JDK (Java Development Kit) 1.1.8 • Oracle Web Discoverer 3.3.48 (Optional) • Oracle JInitiator (1.1.7) On The Client • Oracle Forms 6i • Oracle Reports 6i • Oracle Graphics

  18. Technology Stack Products !! Release 11.5.2, 11.5.3 !! • Oracle8iEnterprise Edition 8.1.6 • Other Oracle Homes – App(8.0.6), iAS(8.1.6) • WebDB 2.2 and WebDB 2.5 ! • Apache Web Server (1.3.9, Full - jsp, jServ) • JServ (1.1) • JRE (Java Runtime Environment) 1.1.8 • JDK (Java Development Kit) 1.1.8 • Oracle Web Discoverer 3.3.48 (Optional) • Oracle JInitiator (1.1.7) On The Client • Oracle Forms 6i • Oracle Reports 6i • Oracle Graphics

  19. Technology Stack Products !! Release 11.5.4 !! • Oracle8iEnterprise Edition 8.1.6 8.1.7 • Other Oracle Homes - App(8.0.6), iAS(8.1.6) • WebDB 2.2 and WebDB 2.5 ! • Apache Web Server (1.3.9, Full - jsp, jServ) • JServ (1.1) • JRE (Java Runtime Environment) 1.1.8 • JDK (Java Development Kit) 1.1.8 1.2.2 • Oracle Web Discoverer 3.3.48 (Optional) • Oracle JInitiator ( 1.1.7 1.1.8.7 ) • Oracle Forms 6i • Oracle Reports 6i • Oracle Graphics

  20. Technology Stack Notes • Install is More Complex (# products), But Easier Than 10.7 NCA • More Products (All Products Get Installed, Regardless Of Licensing) • Server Partitioning (TWO_TASK) • Driven By Many, Many Configuration Files !!!

  21. Technology Stack Notes • Tech Stack – More Complex to Administer • Administrator Profile “Roles” • DB – Database Administrator (8.1.7) • App – Applications Administrator (8.0.6) • Web – Web Administrator (iAS/8.1.6) • Numerous Start/Stop Scripts

  22. Technology Stack Notes More Complex to Administer $COMN_TOP/admin/scripts • adalnctl.sh Apps Listener • adcmctl.sh Concurrent Managers • adrepctl.sh Reports Server • adtcfctl.sh TCF Server • adfrmctl.sh Forms Server • adfmsctl.sh Forms Metric Server • adfmcctl.sh Forms Metric Client • adapcctl.sh Apache

  23. Technology Stack Notes $ORACLE_HOME/appsutil/scripts • addbctl.sh Database • addlnctl.sh Database Listener

  24. Technology Stack – Many Ports

  25. R11i Tools To Assist You Oracle Applications Environment Manager (oaem) • Facilitates .profile Establishment • ( DB, App, Web ) • No Need For Multiple UNIX .profile Scripts • Provides Start / Stop / Status – All Components • Download From Solution Beacon Website www.solutionbeacon.com

  26. What is Release 11i? • Release 11i Technology Stack - Internet Computing Architecture (ICA) - Oracle 8i and 8i New Features • Release 11i Functionality

  27. Oracle8i – New Features • Materialized Views • Cost-based Optimization • Database Resource Manager • Partitioned Tables • Temporary Tables • Invoker Rights • Cache Fusion • Locally Managed Tablespaces • Function-based Indexes • STATSPACK • RMAN • Log Miner

  28. Materialized Views • Summarize, Precompute, Aggregate Data • Stored Data (Not A View) • Snapshot • query_rewrite_enabled -> CBO

  29. Cost-Based Optimization • Optimization Based on Hints & Statistics • Optimizer Reviews Potential Execution Plans • Compares Execution Plans • Chooses Lowest Cost • Release 11i, optimizer_mode = choose • Refer To Whitepaper For init.ora Parameters • $FND_TOP/sql/AFCHKCBO.sql

  30. Cost-Based Optimization Need To Keep Statistics Current ! • FND_STATS (Not ANALYZE, DBMS_STATS) • Oracle Provided Concurrent Programs • Analyze All Index Columns • Gather Table Statistics • Backup Table Statistics • Restore Table Statistics • Gather Column Statistics (Obsolete !!) • Gather All Column Statistics (Obsolete !!) • Gather Schema Statistics

  31. Database Resource Manager • Gives DBA More Control Of System Resources • Consumer Groups And Resource Plans • Allocate And Assign Priorities • Limited To CPU Resources • See Oracle Note 106948.1 For Examples

  32. Partitioned Tables • Tables Sub-divided Into Smaller Segments • More Manageable Than A Large Table • Separate Indexes, Segments • Balance I/O • Two Partitioning Methods • Range Partitioning • Hash Partitioning

  33. Temporary Tables • Name Says A Lot • Exists Only For Duration Of A Session • No REDO For SQL To Temporary Tables • No DML Locks • INV And GL Starting To Use

  34. Invoker Rights • Invoke Or Execute Procedures/Pkgs As If You Were The Owner • One Instance/Occurrence Of A Package In APPS Schema • No More Multiple Sets Of Books Architecture (MSOBA) or Multiple Reporting Currencies (MRC) Schema Duplication

  35. Cache Fusion • Parallel Server Environments • Increases Performance and Availability • Shares the Cache Across OPS Nodes • Big Feature of Oracle 9i (Real Application Clusters)

  36. Locally Managed Tablespaces • Tablespaces That Manage Their Own Extents • Bitmap In Each Datafile • Each Bit Signifies A Data Block • Reduced Contention On The Data Dictionary

  37. Function-Based Indexes • Create Index Using A Function On Column • After Creation, Just Like Normal Index • Use This As A Tuning Aid create index ap_chrg_allocations_n99 on ap_chrg_allocations_all (abs(allocated_amount));

  38. STATSPACK • Historical Data Collection • BSTAT/ESTAT On Steroids • 100+ Metrics • Stores Data In Database • Checkout Whitepaper For More Info

  39. RMAN • Catalog-based Backup & Recovery Tool • Automatically Determines: Database Files, Archive Logs, Control Files • No Other OS files • Compresses Datafiles – Only Used Blocks • Incremental Backups – Only Changed Blocks • More Info - Oracle8i Recovery Manager User's Guide and Reference

  40. Log Miner • Finally! • Readable Interface Into The REDO Logs • Generates DML SQL From Logs (No DDL) • “Supported” Oracle Analysis Tool • Aids in: • Determining Trends • Capacity Planning • Point-in-Time Recovery

  41. Oracle8i – New Features • Materialized Views • Cost-based Optimization • Database Resource Manager • Partitioned Tables • Temporary Tables • Invoker Rights • Cache Fusion • Locally Managed Tablespaces • Function-based Indexes • STATSPACK • RMAN • Log Miner

  42. Oracle8i – New Features What do these new features give you?

  43. Oracle8i – New Features, Summary • Flexibility • Power • Performance “These new Oracle 8i features provide flexibility to Apps DBAs and Developers, which gives them more control and power over the environment. By correctly and efficiently applying these features, greater performance can be obtained.” • Ladder Commercial “Just because you have the power, doesn’t mean you should use it.”

  44. What is Release 11i? • Release 11i Technology Stack • - Internet Computing Architecture (ICA) • - Oracle 8i and 8i New Features • Release 11i Functionality

  45. New Look And Feel • Required Fields Are Color Highlighted • LOV Indicator • Bubble Help • Context Sensitive Help • Right Mouse Click – Popup Menus • Better Colors! • Folder Tab Metaphor - Alternate Regions Displayed As Folder Tabs • For 10.7/11 NCA Installs, No More Floating Toolbar!

  46. Workflow-Enabled Applications • Purchasing • General Ledger • Payables • Project Accounting • Receivables • HR • Account Generator • Oracle Business Intelligence • Oracle Service

  47. Workflow-Enabled Applications • Oracle Engineering • Oracle Inventory • Oracle Web Employees • Oracle Web Customers • Oracle Web Suppliers • Implementation Wizard • Oracle CRM

  48. Workflow-Enabled Applications • WF_PURGE Package • Oracle Note: 132254.1 • Performance-Related Profile Options: - Account Generator: Run in Debug Mode - Purchasing: Workflow Processing Mode

  49. System Admin Screen Changes • Some, Not All • Define Concurrent Program • Define Concurrent Manager • Session Control Dialog • Network Test Screen

  50. Conc Program - Screen Changes

More Related