Exam 13: Performance Monitoring

SQL ____ allows for generation of trace files for Oracle Database.

Altering tables in a production database is always risky and should be avoided if possible.

ASH stands for ______________________________.

In Oracle 10g the default for statistics collection is ____________________,which is achieved by setting the STATISTICS_LEVEL configuration parameter to TYPICAL or ALL.

A transaction is terminated on the execution of a(n)____ command (explicit or implicit),or when a ROLLBACK command is issued.

Statistics in an Oracle database can be schema statistics or system statistics.

Setting dynamic sampling to ____ switches it off.

____________________ in SQL*Plus displays a query plan in SQL*Plus every time a query is executed.

Oracle recommends not using the Database Control for tuning.

Rule-based optimization is obsolete in Oracle 10g and ____________________ optimization is now the only option.

____ is a particular tool that is very good for monitoring performance of busy production databases.

Automated statistics works (by default on database creation),using the ____ job.

____ statistics parameters generate system statistics essential to tuning.

You can use the V$ performance views and the Oracle Wait Event Interface to detect locks.

That metadata and statistical record of an Oracle database can be used to describe,and thus also monitor,how well the database is performing.

The ____ option of the ANALYZE command calculates statistics for all rows and columns in an object,an object being a table or index.

A(n)____________________ in Oracle Database is a special type of statistic,defined as a measure of a rate of change on a cumulative statistic.

Generally,____________________ statistics record the number of rows in tables and the physical size of data.

Some databases benefit more than others from automation,such as those with a very large data warehouse.

Dynamic ____________________ can be a good substitute for tables excluded from automated statistics gathering.