|
OVERVIEW OF ORACLE 10g
ADMINISTRATION
Responsibilities as an Oracle DBA
Configuring Oracle 10g databases
Controlling user access and operations
Monitoring system usage
Ensuring database availability
The Oracle 10g architecture
Instances vs. databases
Oracle processes and memory usage
Determining database file structure
Processing transactions with Oracle 10g
CONSTRUCTING AN ORACLE
10g DATABASE
Creating and dropping the database
Setting the initialization parameters
Dynamic and static parameters
Creating control files and log files
Reducing administration with Oracle managed
files
Defining tablespace structure
Supporting applications that require multiple
block sizes
Creating UNDO and SYSAUX tablespaces
Starting and stopping the database
Mounting and opening the database
Text-based and server parameter files
Connecting with SYSDBA privilege
PERFORMING SPACE
MANAGEMENT
Logical and physical storage structures
Improving sort performance with temporary
tablespace groups
Bigfile and locally managed tablespaces
Controlling storage for database objects
Managing space with PCTFREE/PCTUSED
Moving and redefining tables online
Shrinking tables online to regain space
Resuming operations after failures
Managing LOB storage with chunks
AUTOMATING DATABASE
MANAGEMENT WITH ORACLE ENTERPRISE MANAGER (OEM)
10g DATABASE CONTROL
The OEM architecture
Strengths and weaknesses of OEM
Navigating the graphical interface
Administering with Database Control
Setting thresholds and generating alerts
Verifying changes in the data dictionary
MANAGING USERS AND
RESOURCES
Creating user accounts
Implementing password controls
Allocating space quotas on tablespaces
Limiting resource usage with profiles
Maintaining security
System and object privileges
Setting up and working with roles
Transparently encrypting data
ENHANCING AVAILABILITY
AND ADMINISTRATION WITH PARTITIONS
Building table partitions and subpartitions
Partitioning types: range, hash and list
Tailoring storage for individual partitions
Splitting and merging partitions
Configuring index partitions
Deploying local, global, prefixed and
non-prefixed indexes
Rebuilding unusable indexes
BACKING UP AND
RECOVERING THE DATABASE
Safeguarding the database
Role of the redo log and control file
Ensuring recovery using archiving
Protecting and tracing the control file
Selecting a backup strategy
Implementing hot and cold backups
Partial online and offline backups
Restoring tables with Data Pump
Performing recovery of the database
Recovering corrupted tablespaces
Tracking row history with flashback
Restoring dropped tables from the recycle bin
FUNDAMENTAL TUNING
CONCEPTS
Sizing the buffer cache and shared pool
Balancing disk I/O and memory allocation
Index storage considerations |
