Outline of Oracle Database 11g: Administration I Training 1. Enterprise edition installation
- Identify system requirements
- The optimal flexible architecture (ofa)
- Oracle_base
- Oracle_home
- Configure the installation environment
- Enterprise edition installation
- Dbca
2. The administrator interface
- Enterprise manager tour
- Using em sql worksheet
- Duties of a database administrator
- Exploring the oracle database architecture: general
3. The oracle enterprise architecture 4. Exploring the oracle database architecture: instance memory
- What is an oracle database instance?
- More about the system global area (sga)
- About the pga
- Managing memory
5. Exploring the oracle database architecture: instance processes
- Instance background processes
- Sql execution processes
6. Creating an oracle database
- Create a new database
- Configure an existing database
- Drop a database
- Manage dbca templates
- Manually create a database
7. Managing the database instance
- Configuring a linux environment
- Starting & stopping database control
- Starting & stopping the database listener
- Starting & stopping the database instance
- More about the database files
8. Manage database storage structures: tablespaces
- About tablespaces
- Tablespace management
- Drop tablespace
- Alter tablespace
9. Manage database 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
10. Manage database storage structures
- Data files & temp files
- Managing data files
- Managing temp files
- Enable oracle-managed files (omf)
11. Managing undo data
- About undo space management
- Configure automatic undo management
- Undo_management
- Undo_tablespace
- Undo_retention
- Guarantee undo retention
- Monitor undo space
- Use the undo advisor
12. Network environment: oracle shared servers
- Shared servers architecture
- Configure shared servers
- Monitor shared servers
- V$SHARED_SERVER
- V$SHARED_SERVER_MONITOR
- V$SESSION
- V$CIRCUIT
- V$DISPATCHER & V$DISPATCHER_CONFIG
- V$QUEUE
13. Security: implementing database security
- Database system privileges
- Database object privileges
- Administrator auditing of database activity
- Enhanced default security settings
14. Security: administering user security
- Create & manage database accounts
- Grant & revoke database privileges
- Resource limits via profiles
- Alter profile
- Drop profile
- Password management via profiles
- About role-based security
- With admin option
- Alter user...default role
- Set role
15. Moving data: sql loader
- Loader concepts
- Control file options
- Load methods
- Using the em interface
16. Moving data: export & import
- Manage directory objects
- About the data pump architecture
- Data pump export
- Data pump import
- Data pump data dictionary views
17. Database maintenance & performance management
- The management & advisory framework
- Manage the automatic workload repository
- Automatic database diagnostic monitor
- Use metrics & alert thresholds
- Automatic maintenance tasks
18. Managing concurrency & locks
- About latches & locks
- Manage & monitor latches
- Manage & monitor locks
- V$LOCK
- V$LOCKED_OBJECT
- V$SESSION_WAIT
- DBA_BLOCKERS & DBA_WAITERS
- DBA_DML_LOCKS & DBA_DDL_LOCKS
- DML_LOCKS
19. Backup & recovery concepts & configuration
- About database backup & recovery structures
- Managing redo data
- Managing archival data
- Automatic crash recovery
- Creating a basic backup strategy