Skip Headers
Oracle® Database Express Edition 2 Day DBA
10
g
Release 2 (10.2)
Part Number B25107-01
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
List of Figures
List of Tables
Title and Copyright Information
Preface
Documentation Topics
Audience
Documentation Accessibility
Related Documentation
Conventions
1
Introducing Oracle Database XE
Accessing the Database Home Page
Accessing the Database Home Page from the Desktop
Accessing the Database Home Page with Your Web Browser—Local User
Accessing the Database Home Page with Your Web Browser—Remote User
Getting Help
Navigating the Graphical User Interface
Navigating Using Icons or Menus
Navigating Using Breadcrumbs
2
Starting Up and Shutting Down
Starting Up the Database
Starting Up the Database from the Desktop
Starting Up the Database Using SQL Command Line
Shutting Down the Database
Shutting Down the Database from the Desktop
Shutting Down the Database Using SQL Command Line
3
Connecting to the Database
About Local and Remote Connections
About Local Connections
About Remote Connections
Setting Environment Variables
Setting Environment Variables on the Windows Platform
Setting Environment Variables on the Linux Platform
Connecting Locally with SQL Command Line
Connecting Remotely with SQL Command Line
Environment Variables Reference for Linux
4
Managing Network Connections
About Network Connections and the Oracle Net Listener
Viewing Listener Status
Stopping and Starting the Listener
Changing Listener Port Numbers
Changing the Listener Port Number for Database Connection Requests
Example: Changing Listener Port Number for Database Connection Requests
Changing the Listener Port Number for HTTP Connection Requests
Enabling Remote HTTP Connection to the Database
5
Managing Database Memory
About Memory Management
Memory Allocation Overview
SGA Components
SGA and PGA Sizes
Viewing Current Memory Allocation
Example: Changing SGA and PGA Aggregate Sizes
6
Managing Database Storage
About the Database Storage Structures
Database
Tablespaces
Datafiles and Tempfiles
Control File
Server Parameter File
Password File
Recovery-Related Structures in the Flash Recovery Area
Online Redo Log Files
Archived Redo Log Files
Monitoring Storage Space Usage
Compacting Storage
Viewing Tablespaces
Viewing Redo Log Files
Managing the Flash Recovery Area
Monitoring Space in the Flash Recovery Area
Setting Flash Recovery Area Location and Size
7
Managing Users and Security
About User Accounts
User Privileges and Roles
Internal User Accounts
About Administrative Accounts and Privileges
The SYS and SYSTEM Users
The SYSDBA System Privilege
Operating System Authentication
Logging In as an Administrator
Logging In as User SYSTEM
Logging In as a User with the DBA Role
Logging In and Connecting to the Database as SYSDBA
Changing Administrative User Passwords
Managing Database Users
Viewing Users
Creating Users
Example: Creating a User
Altering Users
Example: Altering a User
Locking and Unlocking User Accounts
Expiring a User Password
Example: Expiring a Password
Dropping Users
Example: Dropping a User
User Accounts Reference
Predefined User Accounts
User Account Icons
8
Monitoring the Database
Monitoring Sessions
Viewing Sessions
Killing (Terminating) a Session
Monitoring System Statistics
Viewing System Statistics
Viewing the Delta in System Statistics
Monitoring the Top SQL Statements
Monitoring Long Operations
9
Viewing Database Version and Settings
Viewing Database Version
Viewing Database Settings
10
Importing, Exporting, Loading, and Unloading Data
About Importing, Exporting, Loading, and Unloading Data
Choosing the Right Import/Export/Load/Unload Option
Unloading and Loading Data
Unloading and Loading Data with Wizards
Example: Unloading Data with the Unload Wizard
Example: Loading Data with the Load Wizard
Loading Data with SQL*Loader
Methods SQL*Loader Uses to Load Data
SQL*Loader Features
Example: Using SQL*Loader
Exporting and Importing Data
Exporting and Importing with Data Pump Export and Data Pump Import
Example: Using Data Pump Export and Data Pump Import
Exporting and Importing Data with the Export and Import Utilities
11
Backing Up and Recovering
Backing Up and Restoring the Database
About Backing Up and Restoring the Database
Enabling ARCHIVELOG Mode for Media Failure Protection
Viewing the Current ARCHIVELOG Mode Setting
Turning on ARCHIVELOG Mode
Backing Up the Database
Scheduling Automatic Backups
Restoring and Recovering the Database
Viewing and Restoring Historical Data with Flashback Query
About Flashback Query
Example: Recovering Data with Flashback Query
Tips for Using Flashback Query
Recovering Dropped Tables
About the Recycle Bin
Viewing Recycle Bin Contents
Example: Restoring a Table from the Recycle Bin
Purging the Recycle Bin
Index