|
 |
Introduction: |
 |
Why Oracle? |
|
Choosing the right Oracle product. |
|
Concepts of a relational database |
|
|
Installing Oracle database 10g/11g software: |
|
Basic System requirements. |
|
Use Oracle Optimal Flexible Architecture (OFA) |
|
Install software with the Oracle Universal Installer. |
|
Create an Oracle database: |
|
Oracle Database Architecture. |
|
Oracle instance architecture. |
|
Use the Database Creation Assistant. |
|
Controlling the database: |
|
Startup and shutdown the database |
|
Start and stop the listener |
|
Storage Structures |
|
Defining the tablespaces and data files |
|
Create tablespaces |
|
Manage tablespaces |
|
Obtain tablespace information |
|
Create and manage tablespace |
|
|
Administering users: |
|
Create and manage database user accounts |
|
Create and manage roles |
|
Grant and revoke privileges |
|
Manage Database security |
|
|
Managing schema objects |
|
Create and modify tables |
|
Define constraints |
|
View the attributes of a table |
|
View the contents of a table |
|
Create indexes and views |
|
|
Data Transfers |
|
Using Import |
|
Using Export |
|
Using SQL Loader |
|
|
Oracle Net Services |
|
Understand Oracle Net concepts |
|
Use Oracle Net Manager to create and configure listeners |
|
Use the listener control utility to control the Oracle Net Listener |
|
Use the Oracle Net Manager to configure client and middle-tier connection |
|
Use TNSPING to test Oracle Net connectivity |
|
Performance Monitoring |
|
Troubleshoot invalid and unusable objects |
|
Gather optimizer statistics |
|
View performance metrics |
|
React to performance issues |
|
Undo Management |
|
Monitor and administer undo |
|
Monitor and administer undo |
|
Configure undo retention |
|
Guarantee undo retention |
|
Use the undo advisor |
|
Monitoring and Resolving Lock Conflicts |
|
Detect and resolve lock conflicts
|
|
Manage deadlocks |
|
Backup and Recovery |
|
Describe the basics of database backup, restore and recovery |
|
List the types of failure that may occur in an Oracle Database |
|
Describe ways to tune instance recovery |
|
Identify the importance of checkpoints, redo log files, and archived log file |
|
Configure ARCHIVELOG mode |
|
Database backups |
|
Create consistent database backups |
|
Back your database up without shutting it down |
|
Create incremental backups |
|
Automate database backups |
|
Monitor the flash recovery area |
|
Database Recovery |
|
Recover from loss of a control file |
|
Recover from loss of a redo log file |
|
Recover from loss of a data file |
|
Full Database recovery |
|
Diagnostic Sources |
|
The Alert Log |
|
Alerts Notification |
|
Trace Files |
|
Monitoring and Managing Memory |
|
Oracle Memory Structures |
|
Automatic PGA Memory Management |
|
Using the Memory Advisor |
|
Using Automatic Shared Memory Management to avoid long running query issues |
