 |
 |
- Use the SQL Performance Analyzer
- Upgrade your database to 11g Release 1
- Record and replay workloads
|
|
| |
|
| | |
 |
|
- Install Oracle Database 11g software and create a database
- Administer users and security
- Back up and recover the Oracle database
|
|
| |
|
| | |
| |
 |
|
- Describe Oracle Database Architecture
- Install and configure Oracle Database 11g
- Configure Oracle Net services
|
|
| |
|
| | |
 |
|
- Back up and recover a database using RMAN and Enterprise Manager
- Configure Oracle Database for optimal recovery for any environment
|
|
| |
|
| | |
| |
 |
|
- Use Database Statistics and Metrics to identify a performance problem
- Interpret Tuning diagnostics
- Identify and eliminate performance issues
|
|
| |
|
| | |
 |
|
- Login to Oracle Application Express
- Develop a database-centric Web application
- Add Page Processing components
|
|
| |
|
| | |
| |
 |
|
- Install Oracle Database 10g and configure a database
- Manage the Oracle instance
- Manage the Database storage structures
|
|
| |
|
| | |
 |
|
- Use RMAN to create and manage backup sets and image copies
- Recover the database to a previous point in time
- Implement a secure database
|
|
| |
|
| | |
| |
 |
|
- Use Data Guard to achieve a highly available Oracle Database
- Describe the Data Guard architecture
- Modify the Data Guard services
|
|
| |
|
| | |
 |
|
- Optimally configure Linux for an Oracle Database installation
- Customize the database to take advantage of Linux features
- Monitor memory, CPU, and I/O activity and performance
|
|
| |
|
| | |
| |
 |
|
- Use the Oracle Database tuning methodology appropriate to the available tool
- Utilize database advisors to proactively tune an Oracle database
- Use Statspack reports to tune the database
|
|
| |
|
| | |
 |
|
- Create Executable Section and write Control Structures
- Create and manage Procedures, Functions, Packages and Triggers
- Including Exception Handling
|
|
| |
|
| | |
| |
 |
|
- Identify Real Application Clusters components
- Install, create, administer, and monitor a Real Application Clusters database
- Review high availability best practices
|
|
| |
|
| | |
 |
|
- Use SQL Statements to retrieve data from tables
- Create and manage tables, and other schema objects
- Control privileges at the object and system level
|
|
| |
|
| | |
| |
 |
|
- Monitor and manage your Grid Control framework
- Create Systems and Services
- Create Administrators and Roles
|
|
| |
|
| | |
|
| |
|
|
|
|
