PacktLib: Oracle Database XE 11gR2 Jump Start Guide

Oracle Database XE 11gR2 Jump Start Guide

Credits

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Preface

Database Editions and Oracle Database XE

About Oracle

Oracle Database Express Edition (XE)

Summary

References

Installing and Uninstalling Oracle Database XE

Downloading Oracle Database 11g XE

Installing Oracle Database 11g XE on Windows XP (32-bit)

Uninstalling Oracle Database 11g XE on Windows XP (32-bit)

Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)

Uninstalling Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)

Summary

Connecting and Configuring Oracle Database 11g XE

Local database connections

Remote database connections

Changing SGA and PGA sizes

Summary

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

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

Developing Stored Subprograms and Triggers

PL/SQL data types

Stored subprograms

Creating stored subprograms

About packages

Exception handling

Wrapping up the PL/SQL stored programs

PL/SQL triggers

Summary

References

Building a Sample Application with Oracle Application Express

What is Oracle Application Express (APEX)?

Creating application users

Loading and unloading data to a text file

Application Express Dashboard

Summary

References

Managing Database and Database Storage

Memory structure

Automatic Memory Management

Important background processes

Physical and logical database structures

Managing the Flash Recovery Area

Summary

Moving Data between Oracle Databases

Exporting and importing data

Moving data between Oracle Database 10g XE and Oracle Database 11g XE

Exporting data using SQL Developer

Summary

Upgrading Oracle Database 11g XE to Other Database Editions

Upgrading Oracle Database 11g XE to Oracle Database 11g Enterprise Edition

Summary

Backup and Recovery

Introduction to backup and recovery

Recovery Manager

Connecting to Oracle Database XE using RMAN

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

Tuning Oracle Database 11g XE

Performance tuning

Performance tuning approach

Avoiding common pitfalls

Autotrace utility

Explain Plan

Using indexes

Dynamic performance views

Statspack

Summary

References

Features Available with Oracle Database 11g XE

Features Available with Oracle Database 11g XE

Features Available with Oracle Database 11g XE