Oracle Database XE 11gR2 Jump Start Guide电子书

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