Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Oracle Database XE 11gR2 Jump Start Guide
  • Table Of Contents Toc
Oracle Database XE 11gR2 Jump Start Guide

Oracle Database XE 11gR2 Jump Start Guide

By : Asif Momen
4.3 (3)
Buy this Book
close
close
Oracle Database XE 11gR2 Jump Start Guide

Oracle Database XE 11gR2 Jump Start Guide

4.3 (3)
By: Asif Momen
Buy this Book

Overview of this book

Oracle Database XE 11gR2 is an excellent beginner-level database and is a great platform to learn database concepts. "Oracle Database XE 11gR2 Jump Start Guide" helps you to install, administer, maintain, tune, back up and upgrade your Oracle Database Express Edition. The book also helps you to build custom database applications using Oracle Application Express.Using this book, you will be able to install Oracle Database XE on Windows/Linux operating system.This book helps you understand different database editions and it guides you through the installation procedure with the aid of screenshots. You will learn to interact with the database objects. You will gain a solid understanding of stored sub-programs which is followed by an introduction to Oracle Application Express (APEX). Solid database performance tuning strategies are also discussed in this book followed by backup and recovery scenarios. All in all, "Oracle Database XE 11gR2 Jump Start Guide" delivers everything that you should know to get started with Oracle Database administration.
Table of Contents (20 chapters)
close
close
close
Oracle Database XE 11gR2 Jump Start Guide
Icon
Oracle Database XE 11gR2 Jump Start Guide
Credits
Icon
Credits
About the Author
Icon
About the Author
Acknowledgement
Icon
Acknowledgement
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Lock Free Chapter
1
Database Editions and Oracle Database XE
Icon
Database Editions and Oracle Database XE
Icon
About Oracle
Icon
Oracle Database Express Edition (XE)
Icon
Summary
Icon
References
2
Installing and Uninstalling Oracle Database XE
Icon
Installing and Uninstalling Oracle Database XE
Icon
Downloading Oracle Database 11g XE
Icon
Installing Oracle Database 11g XE on Windows XP (32-bit)
Icon
Uninstalling Oracle Database 11g XE on Windows XP (32-bit)
Icon
Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
Icon
Uninstalling Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
Icon
Summary
3
Connecting and Configuring Oracle Database 11g XE
Icon
Connecting and Configuring Oracle Database 11g XE
Icon
Local database connections
Icon
Remote database connections
Icon
Changing SGA and PGA sizes
Icon
Summary
4
Accessing Table Data, DML Statements, and Transactions
Icon
Accessing Table Data, DML Statements, and Transactions
Icon
Unlocking sample user accounts
Icon
Installing SQL Developer
Icon
Connecting SQL Developer to Oracle Database 11g XE
Icon
About TAB and DUAL
Icon
Writing simple queries
Icon
Selecting data from multiple tables
Icon
Exploring common functions
Icon
What are Transaction Control Statements?
Icon
Understanding DML statements
Icon
Summary
Icon
References
5
Creating and Managing Schema Objects
Icon
Creating and Managing Schema Objects
Icon
Data Definition Language
Icon
Creating and managing tables
Icon
Creating and managing indexes
Icon
Integrity constraints
Icon
Creating and managing views
Icon
Creating and managing synonyms
Icon
Creating and managing sequences
Icon
Gathering statistics
Icon
Summary
Icon
References
6
Developing Stored Subprograms and Triggers
Icon
Developing Stored Subprograms and Triggers
Icon
PL/SQL data types
Icon
Stored subprograms
Icon
Creating stored subprograms
Icon
About packages
Icon
Exception handling
Icon
Wrapping up the PL/SQL stored programs
Icon
PL/SQL triggers
Icon
Summary
Icon
References
7
Building a Sample Application with Oracle Application Express
Icon
Building a Sample Application with Oracle Application Express
Icon
What is Oracle Application Express (APEX)?
Icon
Creating application users
Icon
Loading and unloading data to a text file
Icon
Application Express Dashboard
Icon
Summary
Icon
References
8
Managing Database and Database Storage
Icon
Managing Database and Database Storage
Icon
Memory structure
Icon
Automatic Memory Management
Icon
Important background processes
Icon
Physical and logical database structures
Icon
Managing the Flash Recovery Area
Icon
Summary
9
Moving Data between Oracle Databases
Icon
Moving Data between Oracle Databases
Icon
Exporting and importing data
Icon
Moving data between Oracle Database 10g XE and Oracle Database 11g XE
Icon
Exporting data using SQL Developer
Icon
Summary
10
Upgrading Oracle Database 11g XE to Other Database Editions
Icon
Upgrading Oracle Database 11g XE to Other Database Editions
Icon
Upgrading Oracle Database 11g XE to Oracle Database 11g Enterprise Edition
Icon
Summary
11
Backup and Recovery
Icon
Backup and Recovery
Icon
Introduction to backup and recovery
Icon
Recovery Manager
Icon
Connecting to Oracle Database XE using RMAN
Icon
The ARCHIVELOG mode
Icon
Backing up a database (the NOARCHIVELOG mode)
Icon
Simulating a database failure (the NOARCHIVELOG mode)
Icon
Restoring the NOARCHIVELOG database
Icon
Configuring the RMAN environment
Icon
Backing up the ARCHIVELOG database
Icon
Simulating a database failure (the ARCHIVELOG mode)
Icon
Restoring the ARCHIVELOG database
Icon
Summary
Icon
References
12
Tuning Oracle Database 11g XE
chevron up
Icon
Tuning Oracle Database 11g XE
Icon
Performance tuning
Icon
Performance tuning approach
Icon
Avoiding common pitfalls
Icon
Autotrace utility
Icon
Explain Plan
Icon
Using indexes
Icon
Dynamic performance views
Icon
Statspack
Icon
Summary
Icon
References
1
Features Available with Oracle Database 11g XE
Icon
Features Available with Oracle Database 11g XE
Icon
Features available
Icon
Features not available

Explain Plan

The execution plan of a query is the sequence of operations that Oracle performs to execute a given statement. It is nothing but a tree which contains the order of steps and relationship between them. The Explain Plan statement displays the execution plan chosen by the Oracle Optimizer.

The Explain Plan generates an execution plan and saves it in the PLAN_TABLE. To create a PLAN_TABLE in your schema execute the ORACLE_HOME\rdbms\admin\utlxplan.sql script.

The following are the basic rules of the execution plan tree:

  1. 1. An execution plan will contain a root, which has no parent.

  2. 2. A parent can have one or more children.

  3. 3. A child has only one parent.

Let us create a dept table in our HR schema, add a foreign key to the emp table pointing to the dept table, and generate an execution plan for an SQL statement joining these two tables. This is done as follows:

-- Create DEPT table
SQL> CREATE TABLE dept (dept_no NUMBER(3) PRIMARY KEY, dept_name VARCHAR2(30));
-- Alter EMP table to...
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Oracle Database XE 11gR2 Jump Start Guide
End of Section 12
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon