Installing oracle 10g database software
·
Identify database system requirements
·
The optimal flexible architecture (of a)
·
Configure the installation environment
·
Installation using the universal installer
·
More about enterprise manager
Exploring
the oracle database architecture
·
General database architecture
·
Database instance memory architecture
Database
instance process architecture
·
About the instance process architecture
·
Instance background processes
·
Sql
execution processes
Creating
an oracle database
·
Create a database
·
Configure & drop a database
·
Manage dbca templates
·
Manually creating a database
Controlling
the database environment
·
Starting & Stopping Database Control
·
Starting & Stopping Isql*Plus
·
Starting & Stopping The Database Listener
·
Starting & Stopping The Database
·
More About The Database Files
·
Handling Parameter Files & Parameter Settings
Storage
structures: tablespaces
·
About Tablespaces
·
Tablespace
Management
Storage
structures: advanced tablespaces
·
More About Temporary Tablespaces
·
About Temporary Tablespace Groups
·
More About Permanent Tablespaces
·
More About Bigfile Tablespaces
·
More About The Sysaux Tablespace
Storage
structures: data files & temp files
·
Managing Data Files
·
Managing Temp Files
·
About Oracle-Managed Files (Omf)
Undo
management
·
About Undo Space Management
·
Configure Undo Management
·
Guarantee Undo Retention
·
Monitor Undo Space
·
Use The Undo Advisor
Database
security
·
Database System Privileges
·
Database Object Privileges
·
Audit Database Activity
·
Register For Security Updates
Administering
users
·
Create & Manage Database Accounts
·
Grant & Revoke Database Privileges
·
Resource Limits Via Profiles
·
Password Management Via Profiles
·
About Role-Based Security
Managing
data: loading data with sql loader
·
About The Database Utilities
·
Using The Loader
·
Understanding The Loader Process
·
Control File Options
·
Direct Path Loads
Managing
data: exporting & importing data
·
Create Directory Objects
·
Expdp
·
Impdp
Oracle
Net Services
·
What Is Oracle Net Services?
·
Oracle Net Manager
·
listener configuration
·
Listener Administration
·
Lsnrctl
Commands
·
Configuring Client Parameters
·
Isolating The Problem
·
Oracle Trace Assistant
·
Network Troubleshooting Utilities
Oracle
shared servers
·
Shared Servers Architecture
·
Configuration Of Shared Server Mode
Monitoring
& resolving lock conflicts
·
About Latches & Locks
·
More About Latches
·
More About Locks
Backup
& recovery concepts
·
About Database Backup & Recovery
·
About Redo Data
·
Redo Log File Maintenance
·
Managing The Archive Options
·
More About The Control File
