Exam 14: Proactive Maintenance

The advice performance tools (Advice Central section within the Database Control)are new in Oracle 10g.

The objective of proactive maintenance is to prevent critical problems ____________________ they occur and damage a database.

The streams pool is usually the most critical buffer for any Oracle database.

Changing baseline metrics involves altering the threshold values.

The ____advisor performs automated diagnostics,by comparing multiple statistical snapshots taken against the database.

An increase in shared pool size may harm performance.

The undo advisor works best with ____________________ undo.

The schema advisor tells you about disk space,how it is used,how it should not be used,and what you might want to alter to help everything run smoothly.

A ____ baseline moves with the current date setting for your database server,from today backwards in time,for whatever period is specified.

A data warehouse does not need to utilize the database buffer cache nearly as much as an OLTP database so it can be set as small as software will allow.Why?

The shared pool is the most highly concurrent section of memory for an Oracle database.

The available scope options for the segment advisor are Tablespaces and ____.

A(n)____________________ metric is an established,expected,or even hoped for value.

The SGA ____ is used for odd tasks like backups and parallel processing.

In most database engines,the execution of a COMMIT or ROLLBACK command simply removes the potential for rollback.

Typically snapshots are created when the database is operating normally.

Much of proactive activity is related to performance tuning a database in one way or another.

The SGA ____ provides for processing that requires occasional large chunks of memory.

_________________________ is really all about setting up the Database Control to predict and track performance problems.

The ____ is made up of various buffers including the shared pool and the database buffer cache.