Oracle Database XE 11gR2 Jump Start Guide. Build and manage your Oracle Database 11g XE environment with this fast paced, practical guide with this book and

Spis treści ebooka

• Oracle Database XE 11gR2 Jump Start Guide
  • Table of Contents
  • Oracle Database XE 11gR2 Jump Start Guide
  • Credits
  • About the Author
  • Acknowledgement
  • About the Reviewers
  • www.PacktPub.com
    • Support files, eBooks, discount offers and more
      • Why Subscribe?
      • Free Access for Packt account holders
      • Instant Updates on New Packt Books
  • Preface
    • What this book covers
    • What you need for this book
    • Who this book is for
    • Conventions
    • Reader feedback
    • Customer support
      • Downloading the example code
      • Errata
      • Piracy
      • Questions
  • 1. Database Editions and Oracle Database XE
    • About Oracle
      • Available database editions
    • Oracle Database Express Edition (XE)
    • Summary
    • References
  • 2. Installing and Uninstalling Oracle Database XE
    • Downloading Oracle Database 11g XE
    • Installing Oracle Database 11g XE on Windows XP (32-bit)
      • Starting and stopping Oracle Database XE in Windows
    • Uninstalling Oracle Database 11g XE on Windows XP (32-bit)
    • Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
      • Starting and stopping Oracle Database XE in Linux
    • Uninstalling Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
    • Summary
  • 3. Connecting and Configuring Oracle Database 11g XE
    • Local database connections
      • Oracle Net Listener
        • Configuring Oracle Net Listener
        • Viewing the status of Oracle Net Listener
        • Starting and stopping the listener
        • Configuring the tnsnames.ora file
    • Remote database connections
    • Changing SGA and PGA sizes
    • Summary
  • 4. Accessing Table Data, DML Statements, and Transactions
    • Unlocking sample user accounts
    • Installing SQL Developer
    • Connecting SQL Developer to Oracle Database 11g XE
    • About TAB and DUAL
    • Writing simple queries
    • Selecting data from multiple tables
    • Exploring common functions
    • What are Transaction Control Statements?
    • Understanding DML statements
    • Summary
    • References
  • 5. Creating and Managing Schema Objects
    • Data Definition Language
    • Creating and managing tables
    • Creating and managing indexes
    • Integrity constraints
    • Creating and managing views
    • Creating and managing synonyms
    • Creating and managing sequences
    • Gathering statistics
    • Summary
    • References
  • 6. Developing Stored Subprograms and Triggers
    • PL/SQL data types
    • Stored subprograms
    • Creating stored subprograms
    • About packages
      • Creating packages
    • Exception handling
    • Wrapping up the PL/SQL stored programs
    • PL/SQL triggers
    • Summary
    • References
  • 7. Building a Sample Application with Oracle Application Express
    • What is Oracle Application Express (APEX)?
      • Getting started with Oracle Application Express
      • Application Express components
      • Prerequisites for a sample application
      • Creating a sample application
      • Adding a page to the existing application
    • Creating application users
    • Loading and unloading data to a text file
      • Unloading the EMP table to a text file
      • Loading text file to the EMP_LOAD table
    • Application Express Dashboard
    • Summary
    • References
  • 8. Managing Database and Database Storage
    • Memory structure
      • System Global Area
      • Process Global Area
    • Automatic Memory Management
    • Important background processes
    • Physical and logical database structures
      • Creating a tablespace
        • Adding datafiles to a tablespace
      • Dropping a tablespace
      • Viewing the tablespace usage
    • Managing the Flash Recovery Area
    • Summary
  • 9. Moving Data between Oracle Databases
    • Exporting and importing data
      • Traditional Export and Import (exp/imp) utilities
      • Data Pump Export/Import (expdp/impdp) utilities
    • Moving data between Oracle Database 10g XE and Oracle Database 11g XE
    • Exporting data using SQL Developer
    • Summary
  • 10. Upgrading Oracle Database 11g XE to Other Database Editions
    • Upgrading Oracle Database 11g XE to Oracle Database 11g Enterprise Edition
    • Summary
  • 11. Backup and Recovery
    • Introduction to backup and recovery
    • Recovery Manager
    • Connecting to Oracle Database XE using RMAN
    • The ARCHIVELOG mode
      • Placing a database in the ARCHIVELOG mode
    • Backing up a database (the NOARCHIVELOG mode)
    • Simulating a database failure (the NOARCHIVELOG mode)
    • Restoring the NOARCHIVELOG database
    • Configuring the RMAN environment
    • Backing up the ARCHIVELOG database
    • Simulating a database failure (the ARCHIVELOG mode)
    • Restoring the ARCHIVELOG database
    • Summary
    • References
  • 12. Tuning Oracle Database 11g XE
    • Performance tuning
    • Performance tuning approach
    • Avoiding common pitfalls
      • Database connection management
      • Cursors and the shared pool
      • Suboptimal SQL
      • Incorrect redo log sizing
    • Autotrace utility
    • Explain Plan
    • Using indexes
      • Index monitoring
    • Dynamic performance views
    • Statspack
      • Installing Statspack
      • Gathering statistics
      • Running the statistics report
      • Recommended blogs
    • Summary
    • References
  • A. Features Available with Oracle Database 11g XE
    • Features available
    • Features not available
  • Index

pokaż cały spis treści

ukryj recenzje