Exam 14: Proactive Maintenance

The ______________________________ advisor advises on the usage and sizing of the different memory buffers,including the entire SGA,and session connection memory-PGA.

The PGA is controlled by the PGA_AGGREGATE_TARGET parameter;setting this parameter to TRUE enables automated PGA memory management.

When an SQL Access Advisor job that has been scheduled has completed executing,an status of ____ is indicated in the Database Control.

The ____advisor performs automated SQL tuning activities.

Setting the Java pool to zero if Java is in use is a waste of memory resources.

If you want to make sure that you always retain changes for possible undo,you should set undo retention to the ____.

The SGA ____ contains the dictionary cache and the library cache.

Automated SGA memory management was introduced in Oracle9i.

PGA stands for ____________________.

SGA manages memory operations on a database server,such as sorting,creating bitmaps,and creating hash tables.

Proactive maintenance is all about forecasting and perhaps preventing running out of disk space before it happens.

Proactive maintenance can be managed from within ____.

Undo space allows for ____ consistency.

A(n)____________________ is essentially a measure of a rate of change.

The ____advisor is generally used for materialized view analysis and usually in data warehouses.

AWR stands for ______________________________.

____ is NOT an advisor available within the Advisor Central of the Database Control.

In a ____ baseline you select a specific period.

____ is the session connection memory that is shared by connections to the database server.

You can click the Help link at the ____________________ corner of the Database Control page,and read about the contents of the current page.