|
Architecture &
Administration
Architecture & Background Processes
Oracle files: Parameter, Spfile, Control, Alert,
Trace,
Password file
Startup & Shutdown
Managing Redo Log Files
Managing UNDO [Rollback] Segments
Table spaces & Data files
Managing Storage structure
Manage Temporary segments
Manage Tables: Regular, Partitioned, Cluster,
IOTs.
Index and Integrity constraints
Manage Users.
Manage Profiles.
Manage Privileges and Roles.
Oracle Utilities: SQL*Loader, IMPORT, EXPORT.
Auditing
BACKUP and RECOVERY
Backup & Recovery considerations
Backup Options:
Cold Backup
Hot Backup
Init.ora
Control File
Redo Log File.
Data Files
Recovery of datafile No Archive log
Recovery of datafile Archive log.
Recover Database Crash while taking HOT BACKUP
Recovery of datafile No Backup available
Recovery of datafile Rollback Segment
Recovery of datafile Temp Segment
Recovery of datafile SYSTEM
Recovery of Redo Log File
Recovery of Control File
Recovery of Password file
Utilities
Incomplete recovery
Time Based
Change Based
Cancel Based
RMAN
PERFORMANCE TUNING
Introduction & Overview
Tuning information and events
Tuning SHARED POOL
Tuning DATABASE BUFFERS
Tuning REDO LOG BUFFER
Tuning I/O
Tuning SORTS
Tuning Undo [RBS] Segments
Tuning APPLICATIONS
Monitoring Locks
DATABASE CREATION
MANUAL NETWORKING
Introduction
Basic NET8 architecture
Server-side configuration
Client-side configuration
Configuring Shared Server |