Oracle 10g Database Administration I - Release 2培
Oracle 10g Database Administration I - Release 2培训
培训大纲：
1. Introduction
Basic concepts of a relational database
Core database administrator tasks
2. Installing Oracle Database 10g Software
System requirements
Use optimal flexible architecture
Install software with the Oracle Universal Installer
3. Create an Oracle Database
Oracle database architecture
Instance architecture
Use the management framework
Database Creation Assistant
4. Database Interfaces
Use structured query language (SQL)
Procedural Language/Structured Query Language (PL/SQL)
Java
Oracle C++ Call Interface (OCCI)
5. Controlling the Database
Start and stop the agent
Enterprise manager database console
Listener
Start up and shut down the database
6. Storage Structures
Purpose of tablespaces and data files
Create and manage tablespaces
Use Oracle Managed Files (OMF)
Obtain tablespace information
7. Administering Users
Create and manage database user accounts
Manage roles
Grant and revoke privileges
Control resource usage by users
8. Managing Schema Objects
Create and modify tables, indexes, and views
Define constraints
View the attributes and the contents of a table
9. Managing Data
Manipulating data through SQL
Import
Export
Data pump
SQL Loader
10. PL/SQL
PL/SQL objects
Triggers and triggering events
Configuration options that affect PL/SQL performance
11. Oracle Database Security
Principal of least privilege
Manage default user accounts
Implement standard password security features
Audit database activity
12. Oracle Net Services
Oracle Net concepts
Use Oracle Net Manager to create and configure listeners
Configure client and middle-tier connection
Use the listener control utility to control the Oracle Net Listener
Use TNSPING to test Oracle Net connectivity
13. Oracle Shared Server
When to use Oracle Shared Servers
Configure and monitor Oracle Shared Servers
14. Performance Monitoring
Troubleshoot invalid and unusable objects
Gather optimizer statistics
View performance metrics
React to performance issues
15. Proactive Maintenance: Objectives
Set warning and critical alert thresholds
Collect and use baseline metrics
Tuning and diagnostic advisors
Automatic Database Diagnostic Monitor (ADDM)
Manage the automatic workload repository
16. Undo Management
Monitor and administer undo information
Configure and guarantee undo retention
Use the undo advisor
17. Monitoring and Resolving Lock Conflicts
Detect and resolve lock conflicts
Manage deadlocks
18. Backup and Recovery Concepts
Basics of database backup, restore, and recovery
Types of failure that may occur in an Oracle Database
Ways to tune instance recovery
Importance of checkpoints, redo log files, and archived log file
Configure ARCHIVELOG mode
19. Database Backups
Consistent database backups
Incremental backups
Automate database backups
Monitor the flash recovery area
Back your database up without shutting it down
20. Database Recovery
Loss of a control file
Loss of a redo log file
Loss of a data file
21. A Day in the Life of a DBA
Daily tasks
Weekly tasks
Monthly tasks
As-needed tasks