O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle Database XE 11gR2 Jump Start Guide

Book Description

Build and manage your Oracle Database 11g XE environment with this fast paced, practical guide with this book and ebook.

  • Install and configure Oracle Database XE on Windows and Linux
  • Develop database applications using Oracle Application Express
  • Back up, restore, and tune your database
  • Includes clear step-by-step instructions and examples

In Detail

Install and uninstall Oracle Database XE on Windows and Linux environment

Set up local and remote database connections and resize Oracle SGA

Install SQL Developer, access table data, modify table data, understand transaction control statements and most commonly used SQL functions

Create and manage database objects like tables, indexes, constraints, views, sequences, and synonyms

Develop PL/SQL stored subprograms

Understand Oracle logical and physical components such as SGA, PGA, Tablespaces, and Flash Recovery Area

Move data between different Oracle Database XE versions

Upgrade Oracle Database Express Edition to other Oracle Database Editions

Protect and recover your database

Tune the database for optimal performance


Table of Contents

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