[  ]

Describe the dependency between tuning in different development phases

[  ]

Describe appropriate tuning goals

[  ]

Describe the most common tuning problems

[  ]

Describe how the alert.log file is used

[  ]

Describe the statistics kept in the dynamic performance views

[  ]

Collect statistics using StatsPack

[  ]

Use other tuning tools

[  ]

Diagnose tablespace usage problems

[  ]

Describe how checkpoints work

[  ]

Monitor and tune checkpoints

[  ]

Monitor and tune redo logs

[  ]

Measure and tune the library cache hit ratio

[  ]

Measure and tune the dictionary cache hit ratio

[  ]

Size and pin objects in the shared pool

[  ]

Tune the shared pool reserved space

[  ]

Describe the user global area (UGA) and session memory considerations

[  ]

Explain other tuning issues related to the shared pool

[  ]

Describe how the buffer cache is used by different Oracle processes

[  ]

Describe the tuning issues related to the buffer cache

[  ]

Monitor the use of buffer cache, and the different pools within buffer cache

[  ]

Implement dynamic SGA allocation

[  ]

Set the DB_CACHE_ADVICE parameter

[  ]

Create and size multiple buffer pools

[  ]

Detect and resolve free list contention

[  ]

Monitor and size the redo log buffer

[  ]

Monitor and size the java pool

[  ]

Identify the SQL operations which require sorts

[  ]

Create and monitor temporary tablespaces

[  ]

Reduce total sorts and disk sorts

[  ]

Describe how the Optimizer is used

[  ]

Use stored outlines

[  ]

Use SQL Trace and TKPROF

[  ]

Collect statistics on indexes and tables

[  ]

Copy statistics between databases

[  ]

Describe the correct usage of extents and Oracle blocks

[  ]

Explain space usage and the high-water mark

[  ]

Recover space from sparsely populated segments

[  ]

Describe and detect chaining and migration of Oracle blocks

[  ]

Perform index reorganization

[  ]

Monitor indexes to determine usage

[  ]

Explain the different types of indexes

[  ]

Describe materialized views and the use of query rewrites

[  ]

Define levels of locking

[  ]

List possible causes of contention

[  ]

Use Oracle utilities to detect lock contention

[  ]

Resolve contention in an emergency

[  ]

Prevent locking problems

[  ]

Describe the basics of database backup, restore and recovery

[  ]

List the types of failure that may occur in an Oracle environment

[  ]

Define a backup and recovery strategy

[  ]

Identify the importance of checkpoints, redo log files, and archived log files

[  ]

Describe the differences between Archivelog and Noarchivelog modes

[  ]

Configure a database for Archivelog mode

[  ]

Enable automatic archiving

[  ]

Describe user-managed backup and recovery operations

[  ]

Perform closed database backups

[  ]

Perform open database backups

[  ]

Back up the control file

[  ]

Perform recovery in Noarchivelog mode

[  ]

Perform complete recovery in Archivelog mode

[  ]

Restore datafiles to different locations

[  ]

Relocate and recover a tablespace by using archived redo logfiles

[  ]

Describe read-only tablespace recovery

[  ]

Describe the steps of incomplete recovery

[  ]

Perform an incomplete database recovery

[  ]

Identify the loss of current online redo log files

[  ]

Describe the uses of the Export and Import utilities

[  ]

Describe Export and Import concepts and structures

[  ]

Perform simple Export and Import operations

[  ]

Demonstrate usage of direct-load insert operations

[  ]

Describe the usage of SQL*Loader

[  ]

Perform basic SQL*Loader operations