Oracle8 Server Unleashed:Table of Contents
To access the contents, click the chapter and section titles.
Oracle8 Server Unleashed
(Imprint: Sams)
(Publisher: Macmillan Computer Publishing)
Author: Joe Greene
ISBN: 0672312077
- Introduction
- About the Authors
- Part 1Oracle8 Server
- Chapter 1Oracle8
- The Latest Oracle
- Major Improvements
- The Oracle8 Product Family
- Fitting Oracle8 into an Application Environment
- Summary
- Chapter 2Oracle Database Architecture
- Database Architecture
- Instances
- Oracle Processes
- User Processes
- Data Writing Processes
- Logging Processes
- Monitoring Processes
- Memory and Speed
- Software Code Areas
- System Global Area (SGA)
- Program Global Area (PGA)
- Sort Areas
- Disk Storage
- Data Files
- Log Files
- Supporting Files
- Control Files
- SGA Definition File
- Log and Error Files
- Interfacing with the DBMS
- Multiprocessor Configurations
- Fault Tolerance
- Microsoft Windows NT Configurations
- Oracle8 Under Windows NT
- Summary
- Chapter 3Oracle8 Network Computing
- The Emergence of Network Computing
- Convergence
- The Web Changes Everything
- Pitfalls of PC Computing
- Network Centricity and Network Computing
- The Appeal of Network Computing
- Emerging Technologies
- The Benefits of Object Technology
- Java
- CORBA
- Enterprise JavaBeans
- An Architecture for Network Computing
- Network Computing Architecture
- From 2-tier to 3-tier Computing
- Client
- Application Server
- Database Server
- The Network Computer
- A Typical NC
- The NC Reference Specification
- Open Issues
- Summary
- Chapter 4Oracle8 Servers and Options
- So Many OptionsSo Little Time
- ScaleBambi Meets Godzilla
- ArchitectureWelcome to the Jungle
- UtilityTaking Care of Business
- The Oracle8 Server
- The Movement Towards Object-Oriented Paradigms
- The Growing Complexity of Computer Architecture
- The Proliferation of Internet Business
- Oracle8 and Data Warehousing
- Oracle8 Enterprise EditionLuxury and Performance
- Enterprise Manager Performance Pack
- Incremental and Parallel Backups
- Point In Time Tablespaces
- Bit-Mapped Indexes
- Parallel Query
- Parallel DML
- Parallel Index Scans
- Parallel Bit-Mapped Star Query Joins
- Oracle LiteTastes Great, Less Calories
- Operating System WarsUNIX Versus NT
- Microsoft NT and How It Compares to UNIX
- Summary
- Part IIInstallation, Upgrade, and Migration
- Chapter 5Implementation PlanningPC to Enterprise Server
- Overview of the Installation Planning Process
- Starting with Business Needs
- The Installation Documentation
- The README File
- Developing Your Own Installation Plan
- Some Good Reviewers
- System Hardware
- Software Module Planning
- Optimal Flexible Architecture (OFA)
- Administrative Directories
- Local Directories
- Data and Log Directories
- Memory Allocation and Alternatives
- Logical Database Design
- Physical Database Design
- RAID and Other Storage Alternatives
- Processing Options
- Upgrades Versus New Installations
- Other Factors to Consider
- The Backout Plan
- Lining Up Support
- A Sample Plan
- Summary
- Chapter 6Installation and Upgrades
- Overview of the Installation Process for Sun Solaris
- Hardware and Software Requirements
- Software Requirements for Networking Products
- Optimal Flexible Architecture (OFA)
- Installation Preparation and Installation
- Installing Documentation
- Post-Installation Steps for Oracle8 Server
- New InstallationsRecovery Manager
- New InstallationsTime Series Cartridge
- Migration to Oracle8
- Copying Data
- Develop a Testing Plan
- Migration Utility
- Migration Preparation
- Backup of the Existing System
- Common Problems and Troubleshooting
- Summary
- Chapter 7Migrating from Non-Oracle Databases
- System MigrationThe Sum of All Our Fears
- The Realities of System Migration
- The Myth of ANSI SQL
- The Great Operating System Barrier
- Oracle AllianceDesign and Migration Services to the Rescue
- Common Migration Scenarios
- Downsizing
- Front-End Considerations
- Database Considerations
- Management Considerations
- Using Oracles Data Conversion ToolDCT
- What the Conversion Tool Is and What It Is Not
- A Step-by-Step Tour of a Data Migration Using the DCT
- Migrating a Front-End Using DCT and Oracle*Forms 4.5
- Oracle DCTIs It Worth It?
- Summary
- Chapter 8Coexisting with Non-Oracle Databases
- Sleeping with the Enemy
- Different Operating Systems
- Different Hardware Vendors
- Different RDBMS Vendors
- Different Paradigms
- The Gateway to Everywhere
- What Kind of Gateway Do You Need?
- Coexistence and Replication
- Replicating What Is Different
- Features of Oracle Replication Services
- Summary
- Part IIIOracle8 Components and Objects
- Chapter 9Oracle Processes
- Map of the Oracle Processes
- The Main Oracle Processes
- System Monitor
- Process Monitor
- Database Writer
- Log Writer
- Optional Processes
- Archiver
- Recoverer
- Lock Writer
- Dedicated Server Processes
- Net8 Processes
- Parallel Query Processes
- Web Server Processes
- Summary
- Chapter 10Oracle Memory Areas
- Uses of Memory Within Oracle8
- Virtual Memory
- System Global Area
- Sharing Memory
- System Global Area (SGA)
- Database Buffer Cache
- Shared Pool
- Program Global Area (PGA)
- User Work Spaces
- Oracle Application Software Memory
- Summary
- Chapter 11Oracle Files
- Oracle Files and Their Purposes
- Data Files
- Log Files
- Control Files
- Initialization and Configuration Files
- Log and Trace Files
- Automatic Resizing of Files
- Distribution of Data for Tuning
- Standard File Locations
- Summary
- Chapter 12Oracle Database Objects
- Oracle8 Database Objects
- Tables
- Indexes
- Views
- Synonyms
- Stored Procedures and Packages
- Clusters
- Sequences
- Tablespaces
- Partitions
- Object Datatypes
- Constraints
- Summary
- Chapter 13Oracle System and Object Privileges
- Overview of Oracle Security
- System Privileges
- Object Privileges
- Table Privileges
- View Privileges
- Sequence Privileges
- Procedure Privileges
- Column Privileges
- User Privileges
- Developer Privileges
- DBA Privileges
- The Database Maintenance Privileges
- Monitoring Privileges
- Default Privileges
- Connecting Internally
- Dummy Object Owners
- A Typical Privilege Scheme
- Summary
- Chapter 14Roles and Grants
- Managing Grants and Roles
- Grants
- Roles
- Grants Without Roles
- Use of Scripts to Capture Privilege Sets
- Enterprise Manager Role and Grant Management
- Command Line Role and Grant Management
- A Typical Privilege Scheme
- Summary
- Chapter 15Object-Oriented Extensions in Oracle8
- Introduction
- The Basic Elements of an Object
- Methods
- Object Ordering
- Map Methods
- Order Methods
- Type Versus Instantiation of a Type
- REFs
- Nested Tables and VARRAYs
- Nested Tables
- VARRAYs
- Using Base Types
- Object Views
- INSTEAD OF Triggers
- Large Objects
- BLOB
- CLOB
- NCLOB
- BFILE
- Summary
- Chapter 16Replication
- Replication: Why Ask Why?
- Replication and the Data Warehouse
- Read-Only Replications and Snapshots
- Snapshot Logs
- Remote Databases
- Complex ReplicationDistributed Databases
- Replication and the World of Virtual Databases
- Creating a Replicated Environment Replication God
- Managing Your Replication and the Mystery of the Two-Phase Commit
- Conflict Resolution
- Types of Conflicts
- Managing Update Conflicts
- Creating Column Groups
- Defining a Conflict Resolution Method for a Column Group
- Survivability
- The Advantages of Oracle8 and the Replication Manager
- Summary
- Chapter 17Query and Transaction Processing
- Transaction Processing
- SQL Statement Processing
- Cursor Creation
- Statement Parsing
- Query Processing
- Bind Variables
- Statement Execution
- Parallelization
- Fetch Rows to Be Returned
- Using the Oracle Optimizer
- How the Optimizer Works
- Optimizer Initialization Parameters
- Optimization Methods
- Using the ANALYZE Command
- How to Run the ANALYZE Command
- Data Dictionary Statistics
- Analyzing SQL Statements
- Using EXPLAIN PLAN and SQL Trace
- SQL Trace
- Using EXPLAIN PLAN
- Designing New SQL Statements
- Using Indexes
- Clusters
- Hash Clusters
- Range Partitioning
- Packages, Procedures, and Functions
- Using Hints
- Summary
- Chapter 18Supplied PL/SQL Packages
- Introduction to Supplied Packages
- Creating the Packages
- Package Summaries
- Reading From and Writing To Files
- Working with LOB Data
- Issuing Dynamic SQL and Data Definition Language Statements
- Communicating Between Processes
- Advanced Queuing
- Scheduling Jobs
- Summary
- Part IVOracle8 Administration
- Chapter 19Oracle8 Administrative Requirements
- Overview of Oracle8 Administration
- Backup and Recovery Concepts
- Security and Access Concepts
- Overview of Oracle8 Permissions and Profiles
- Overview of SQL*Net, Net8, and Connection Manager
- Tablespace Maintenance Concepts
- Importance of Organization
- Tuning Through Distribution
- Sizing Defaults
- Fragmentation and Design Considerations
- Schema Maintenance Concepts
- Object Maintenance
- Referential Integrity
- Loading/Unloading Tables
- Sizing Defaults
- Estimating the Size of Objects
- Tuning Concepts
- Who Is Responsible for Tuning Tasks?
- Four Levels of Tuning
- Miscellaneous Tasks
- Monitoring
- Troubleshooting
- Summary
- Chapter 20Routine Maintenance and Scheduling Tasks
- User, System, and Batch Processing
- User Processing
- System Processing
- Monitoring Processes
- Initializing Processes
- Scheduling Batch Processes
- Auditing
- Enabling and Disabling Auditing
- The Operating System Audit Trail
- The Database Audit Trail
- The AUDIT Command
- Types of Auditing
- Audit Options
- Managing the Audit Trail
- Sample Audit Queries
- Common Monitoring Scripts
- Types of Monitoring
- What to Monitor
- Sample Monitoring Scripts
- Monitoring with Oracle Tools
- Scheduling Jobs
- Managing Job Queues
- Submitting and Manipulating Jobs
- Job Queue Information in the Data Dictionary
- Summary
- Chapter 21Administration Using Enterprise Manager
- Introduction to Oracle Enterprise Manager
- Installing Oracle Enterprise Manager
- Configuring Enterprise Manager
- Building the Repository
- Configuring the Intelligent Agent
- Discovering New Services
- Setting Preferences
- Managing Events
- Creating and Modifying Event Sets
- Registering an Event Set
- Event Notification
- Managing Jobs
- Preparing to Run Jobs
- Creating a Job
- Creating a Fixit Job
- Managing Database Instances
- Preparing for Remote Administration
- Shutting Down an Instance
- Starting an Instance
- Editing Stored Configurations
- Managing Schema Objects
- Creating Tables
- Creating Object Types
- Creating a VARRAY
- Creating a Nested Table
- Creating an Object Table
- Managing Security
- Managing Storage
- Diagnostic and Performance Tools
- Oracle Performance Manager
- Oracle Lock Manager
- Oracle Expert and SQL Analyze
- Sample Net8 Configuration Files
- Summary
- Chapter 22Oracle8 Tools
- Overview of Oracle8 Tools
- Server Manager
- Export/Import
- Data Movement
- Incremental Backups
- SQL*Loader
- SQL*Plus
- SQL*Plus Execute Commands
- SQL*Plus Editing Commands
- SQL*Plus Formatting Commands
- Miscellaneous Commands
- SQL*Plus Reporting Techniques
- Advanced Reporting Techniques
- SQL*Plus Additional Functionality
- Third-Party Products
- Database Administration
- Data Movement
- Tablespace Reorganization
- Tuning Aids
- Monitoring
- Summary
- Chapter 23Backup and Recovery
- Overview of Oracle Data Availability Requirements
- Acceptable Data Loss
- 24×7 Needs
- Data Warehouse Requirements
- Scheduled Maintenance
- Overview of Oracle Backup and Recovery Processes
- ARCHIVELOG Mode
- Cold and Hot Backups
- Incremental Backups
- High Availability Options
- Backup Schemes
- Overview of Various Backup Schemes
- Deciding Which Scheme Is Best
- Automating Backup Schemes
- Summary
- Chapter 24Oracle8 Database Tuning
- Tuning Overview
- Who Is Responsible?
- Proactive Tuning Versus Reactive Tuning
- Levels of Tuning
- Operating System-Level Tuning
- Oracle RDBMS-Level Tuning
- Database Design-Level Tuning
- Table/Index Relationships and Tablespaces
- Partitioning
- Controlling Fragmentation
- SQL-Level Tuning
- Application Code
- Indexing
- Parsing
- Optimizers
- SQL Tuning
- Tuning Checklist
- Summary
- Chapter 25Oracle8 Application Tuning
- Factors Designers Can Control
- The Rule-Based Optimizer
- The Cost-Based Optimizer
- Execution Plans
- Hints
- Index Design
- General Guidelines
- The Value of Experimentation
- Summary
- PART VOracle8 and the Web
- Chapter 26ODBC/JDBC
- Overview of ODBC
- ODBCs Purpose
- ODBCs Evolution
- RDO, DAO, OLE DB, ADO, and Other Acronyms
- Oracles ODBC Evolution
- ODBC Architecture
- ODBC Setup, Usage, and Limitations
- Oracle8 ODBC Setup
- Connecting to Oracle8
- Oracle ODBC Driver Capabilities and Limitations (V8.0.3)
- ODBC Functions Not Supported
- SQL Syntax Not Supported
- Oracle8 ODBC Optimization and Troubleshooting
- Performance, General
- Update Performance
- Select Performance
- Troubleshooting via Logging
- Last Words on ODBC
- Overview of JDBC
- JDBCs Purpose
- JDBCs Evolution
- Oracles JDBC Evolution
- JDBC Thin
- SQLJ
- JDBC Architecture
- JDBC Setup, Usage, and Limitations
- Oracle8 JDBC Setup
- Installing Oracle8 JDBC Drivers
- Configuring Oracle8 JDBC Drivers
- Capabilities and Limitations
- JDBC, General
- JDBC Thin
- Oracle-Specific Functions
- Refcursors as ResultSets
- Execution Batching
- PL/SQL Stored Procedures
- Database Metadata
- Streaming Data
- prefetch
- Define Query Columns
- Last Words on JDBC
- Summary
- Chapter 27Oracle Web Application Server
- Background: The Internet, the WWW, and Intranets
- Web Architecture
- Hypertext Transport Protocol (HTTP)
- Hypertext Markup Language (HTML)
- Java
- JavaScript
- Network Computing Architecture
- Background
- Oracle Web Application Server Architecture
- Web Listener
- Dispatchers
- Web Request Broker (WRB)
- Cartridges
- Accessing Non-Oracle Databases
- Web Security
- User Authentication
- Persistent User Verification
- Secure Sockets Layer (SSL)
- General Guidelines
- Developer/2000 and the Oracle WAS
- Forms
- Reports
- Graphics
- Designer/2000 and the Oracle WAS
- WAS Product Purchase
- Standard Version
- Advanced Version
- Web Developer Suite
- The Future of Oracle Web Application Server
- Summary
- Part VIImplementation of Oracle8
- Chapter 28Oracle8 Cartridges
- Overview of Oracle8 Cartridges
- NCA Cartridges
- Cartridge Architecture
- Application Designing Using NCA Cartridges
- Data Cartridge Components
- Developing Cartridges
- Designing a Data Cartridge
- Oracle8s Extensibility Feature
- External Procedures
- Example: Step by Step Data Cartridge Development
- Testing the Developed Data Cartridge
- Deploying Cartridges
- Data Cartridge Installation and Operation
- Definition of Libraries
- Installation Flow
- Summary
- Chapter 29Using Oracle8 Objects in PL/SQL and SQL
- The Advantages of Using PL/SQL Within Java
- Different Ways That Java Can Package PL/SQL
- The Language of Cartridges
- RMIDistributed Computing Tool
- The FutureJ/SQL
- Summary
- Chapter 30Data Warehouses
- Introduction
- What Is a Data Warehouse?
- Why Would a Company Need a Data Warehouse?
- The Six Steps to Creating a Data Warehouse
- Document the Operational Environment
- Choosing the Data Warehousing Technologies
- Designing the Data Warehouse Model
- The Star Schema
- Designing the Data Refresh Process
- Scalability
- Utilizing Oracle8 Features in the Data Warehouse
- Monitoring Tools
- Develop the Extraction and Scrubbing Routines
- Auditing Logs
- Full Refreshes with Data Selection Performed Inside the Data Warehouse
- Code Changes in the Existing Applications
- What About Data Marts?
- Metadata
- System Metadata
- Management Metadata
- Business Metadata
- Executive Information Systems
- Easy to Use
- Easy to Access
- Fast
- Client- or Server-Based
- External Data
- Data Mining (Panning for Gold)
- Data Mining Models
- Summary
- Chapter 31Large Online Transaction Processing Systems
- Online Transaction Processing (OLTP) Overview
- OLTP Database Design
- Parallel Server Architecture Review
- Parallel Server Design Practices
- Database Configuration Issues
- UNIX Configuration Issues
- Database Schema Design Practices
- OLTP Application Development
- Application Design and Coding Practices
- Application Security
- OLTP Administration and Maintenance Considerations
- Backups and Recovery Considerations
- Batch Data Loading
- Object Fragmentation
- Periodic Maintenance
- OLTP Implementation Issues
- Stress Testing
- Project Management and Planning Issues
- Summary
- Chapter 32Media and Complex Data Servers
- What Is a Media Server?
- New Uses of Media Objects That Will Change Business
- Presentations
- Online Training
- Help Desk Support
- Kiosks
- Video on Demand (VOD)
- Home Shopping
- Electronic Banking
- Personalized News Service
- Games
- Reference
- Oracles Answer to Media Data
- The Oracle Media Server
- Oracle Media Net
- Oracle Media Objects
- The Components of Oracles Media Objects
- Oracle Video Custom Control
- Oracles Media Cartridge
- Summary
- Chapter 33Working with Very Large Databases
- Introduction
- Oracle8 and High-End Database Systems
- Partitioned Tables and Indexes
- Managing a Large Number of Users
- Deferred Transaction Support
- Parallel Query Enhancements
- Parallel Server Enhancements
- Oracle8 Features for Large Databases
- Table Partitioning
- Partitioned Indexes
- Index-Only Tables
- Parallel DML (PDML)
- Bitmap Indexes
- Index Fast Full Scans
- Reverse Key Indexes
- Tuning for Very Large Databases
- Transaction Management in VLDB Systems
- Rollback Segment Considerations
- Archiving Considerations
- Operation of a Large Database
- Rollback Segments Design
- Backup and Recovery Using Recovery Manager (RMAN)
- types Within types
- Object Views
- VARRAY
- Summary
Index
|