Oracle Internals

Book description

If you are a typical Oracle professional, you don't have the luxury of time to keep up with new technology and read all the new manuals to understand each new feature of the latest release from Oracle. You need a comprehensive source of information and in-depth tips and techniques for using the new technology. You need Oracle Internals: Tips, Tricks, and Techniques for DBAs. Oracle has evolved from a simple relational database into one of the most complex e-commerce platforms ever devised. It's not enough for you to understand just the Oracle database. You must also understand the components of the Web server technology, XML, Oracle Security, Oracle and Java, and a host of other issues in order to do your job properly. This book is a compendium of the best and most useful articles from Oracle Internals, Auerbach Publications' newsletter for Oracle database administrators and other Oracle professionals. Edited by Oracle guru Don Burleson, it provides the type of in-depth, highly technical information not found in any other book, information only available from peers and consultants. The chapters focus on the truly tough stuff - proven techniques learned in the trenches. You could get this information from other sources, but you'd have to hunt and peck for it. Can you afford that kind of time? Oracle Internals: Tips, Tricks, and Techniques for DBAs gives you knowledge and advice directly applicable to your work in one easy-to-use resource.

Table of contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. Contributors
  5. Introduction
  6. I: ORACLE APPLICATIONS DEVELOPMENT TECHNIQUES
    1. Chapter 1
      1. A Practical Example of Data Conversion
    2. Chapter 2
      1. Using Wizards in an Oracle Developer 6i Form
    3. Chapter 3
      1. Using Oracle’s Developer 6i to Create a Record Directory
    4. Chapter 4
      1. Using Hierarchical Tree Items in Oracle’s Developer 6i
    5. Chapter 5
      1. Populating Oracle Form Hierarchies Incrementally at Runtime
    6. Chapter 6
      1. Oracle Designer 2.1.2.API: Enforcing Column Naming Standards
  7. II: ORACLE WEB DEVELOPMENT
    1. Chapter 7
      1. Building a .com from the Ground Up
    2. Chapter 8
      1. Rapid Web Deployment with WebDB
    3. Chapter 9
      1. Introduction to iAS for the OAS Administrator
    4. Chapter 10
      1. Viewing Performance Data with OAS
    5. Chapter 11
      1. Top DBA Scripts for Web Developers
    6. Chapter 12
      1. Web-Based Testing and Capacity Planning
    7. Chapter 13
      1. HTTP Listeners
    8. Chapter 14
      1. Introduction to UTL_HTTP
    9. Chapter 15
      1. Portal 3.0: Moving Folders Across Content Areas with Its API
    10. Chapter 16
      1. Not WebDB 3.0, Not iPortal, But Oracle Portal
  8. III: JAVA AND ORACLE
    1. Chapter 17
      1. The Fast Track to Java with Oracle
    2. Chapter 18
      1. Building a Java Applet for Monitoring Oracle
  9. IV: ORACLE AND UNIX
    1. Chapter 19
      1. UNIX Scripts for Oracle Administration
    2. Chapter 20
      1. UNIX Tips and Tricks for the Oracle DBA
    3. Chapter 21
      1. File Exchange Solutions: SQL*Loader, PL/SQL, and Pro*C
    4. Chapter 22
      1. Gauging How Linux May Change the DBMS Market
  10. V: ORACLE BACKUP AND RECOVERY
    1. Chapter 23
      1. Strategies for an Archives Management Program
    2. Chapter 24
      1. Scripting Oracle Backups with RMAN and EBU
    3. Chapter 25
      1. Alert Mechanisms for RMAN Backups
    4. Chapter 26
      1. Tips and Scripts for Implementing RMAN
    5. Chapter 27
      1. Paging People with Oracle8i Out of the Box
  11. VI: ORACLE SQL TUNING
    1. Chapter 28
      1. Cost-Based Optimization: Whys and Hows
    2. Chapter 29
      1. Analytic Functions
    3. Chapter 30
      1. Piranhas in the Pool: Investigations into Literal SQL and Oracle Shared Pool Performance
    4. Chapter 31
      1. Managing Database Objects in Sets
    5. Chapter 32
      1. Oracle’s Joins
    6. Chapter 33
      1. To_Format
  12. VII: ORACLE DISK MANAGEMENT
    1. Chapter 34
      1. Exploring Disk Size and Oracle Disk I/O Performance
    2. Chapter 35
      1. Adaptive Strategies for Disk Performance in Oracle
    3. Chapter 36
      1. RAID and Oracle
    4. Chapter 37
      1. Visualizing the I/O Signature
  13. VIII: DISTRIBUTED ORACLE SYSTEMS
    1. Chapter 38
      1. Automating Distribution of Oracle Client Software
    2. Chapter 39
      1. SQL*Net Diagnostics and Performance Tuning
  14. IX: ORACLE BUFFER AND SGA MANAGEMENT
    1. Chapter 40
      1. Pinning Packages in the SGA
    2. Chapter 41
      1. Investigating the Multiple Buffer Pool Feature of Oracle8
    3. Chapter 42
      1. Diving into the Shared Pool
    4. Chapter 43
      1. Managing Multiple Buffer Pools in Oracle8
    5. Chapter 44
      1. Oracle8i Buffer Cache: New Features
  15. X: ORACLE TABLE MANAGEMENT
    1. Chapter 45
      1. How I Reorganized a Large Database
    2. Chapter 46
      1. Partition and Conquer
    3. Chapter 47
      1. Eliminating Space Reorganizations in Oracle8i
    4. Chapter 48
      1. Determining the Table Rebuild Ratio for Oracle Tables
    5. Chapter 49
      1. Oracle Parallel Query
    6. Chapter 50
      1. Managing Oracle Table Freelists
  16. XI: ORACLE SECURITY
    1. Chapter 51
      1. Using Roles in Oracle Security
    2. Chapter 52
      1. Managing Row-Level Security in Oracle8i
    3. Chapter 53
      1. Auditing Oracle
  17. XII: ORACLE DATA WAREHOUSING
    1. Chapter 54
      1. What’s Wrong with My Data?
    2. Chapter 55
      1. Oracle Express Development in the Enterprise
    3. Chapter 56
      1. An Approach to Load Analysis and Stress Testing
    4. Chapter 57
      1. Undocumented Express
    5. Chapter 58
      1. Enterprise Transformation and Data Management
  18. XIII: ORACLE DATABASE INTERNALS MANAGEMENT
    1. Chapter 59
      1. Getting a Quick Start with Oracle8i
    2. Chapter 60
      1. Oracle Sessions Monitoring
    3. Chapter 61
      1. The Object/Relational Features of Oracle8
    4. Chapter 62
      1. Hardware Considerations
    5. Chapter 63
      1. Oracle Extras
    6. Chapter 64
      1. Oracle’s Triggers
    7. Chapter 65
      1. Concurrency
    8. Chapter 66
      1. The Supporting GROUPS
    9. Chapter 67
      1. Registering a Metadata Schema
    10. Chapter 68
      1. ORADEBUG: A Useful (Undocumented?) Utility
    11. Chapter 69
      1. Using the DBMS_LOCK Built-In Package

Product information

  • Title: Oracle Internals
  • Author(s): Donald K. Burleson
  • Release date: July 2017
  • Publisher(s): Auerbach Publications
  • ISBN: 9781135514655