Oracle 9i New Features
High Availability
Scalability
Performance
Security
Manageability
Unsupported and Deprecated Features
Oracle Overview and Architecture
Logical Structures
Physical Structures
Memory Structures
Background Processes
Connecting
Processing SQL Statements
Installing and Managing Oracle
The Oracle Universal Installer
Enterprise Manager
Optimal Flexible Architecture (OFA)
Administrator Authentication Methods
Starting up
Managing Sessions
Shutting Down
Instance messages and alerts
Oracle Managed Files
Creating a Database and Data Dictionary
Creating a Database
Preparing Resources
Parameters
Environment Variables
The CREATE DATABASE command
Using OMF to create a database
Creating an SPFILE
The Data Dictionary
Creating the Dictionary
Administering Stored Procedures & Packages
Completing the Database Creation
The Database Configuration Assistant
Control and Redo Log Files
Maintaining the Control Files
Maintaining and Monitoring Redo Log Files
Logical & Physical Database Structures
Tablespaces & Datafiles
Managing Tablespaces
Managing Datafiles
Segments & Storage Structures
Data Blocks
Extents
Segments
Managing Undo Segments
Managing Tables, Indexes and Constraints
Storing Data
Managing Indexes
Managing Constraints
Managing Users, Security and Globalisation Support
Profiles
Users
Managing Privileges
Managing Roles
Querying Role information
Auditing the database
Glaobalisation support
|