Exam 13: Performance Monitoring

A(n)____________________ is where two interdependent rows are both locked and both rows require the release of the lock on the other row to continue processing.

____ is a set of scripts used to take a snapshot of a database.

The STATSPACK is the recommended tool for statistics generation in Oracle 10g.

Describe the files generated by SQL Trace.

The ____ clause can effectively lock everything within a transaction until the transaction is completed by a commit or rollback.

____ can cause serious performance issues,effectively locking down data.

There are operating system tools that provide information about the resources of an underlying Oracle database.

The DBMS_STATS package can be used to copy statistics between databases,allowing accurate simulated tuning between testing and production databases.

SQL Trace controls how much information is generated into trace files (BASIC,TYPICAL,or ____________________).

Automatic SQL tuning is new to Oracle 10g Database where the optimizer can be switched from normal mode to a tuning mode.

____ is superseded by the AWR and the ADDM.

A(n)____ lock completely prohibits changes to data,but still allows read access.

_________________________ is the action of monitoring the speed of a database.

Database performance views are also known as ____________________ performance views because they change constantly,depending on the state of a database.

You can manually gather statistics for snapshot comparison use,using both STATSPACK and the Database Control.

The DBMS_STATS package is the Oracle recommended method for manual statistic gathering because it is ____________________ executable.

A(n)____________________ is when one thing is waiting for another,but that other thing is also waiting for something else,or even the first thing.

The ____________________ is a method of using the V$ performance views,to drill down into database statistics,available in the views.

What is the role of system statistics in an Oracle database?

It is recommended to leave the STATISTICS_LEVEL parameter permanently set to ALL.