Exam 13: Performance Monitoring

Lock ____________________ that require manual resolution are usually caused in error,such as executing a DDL command on an active production database,and locking a busy table.

(Short Answer)

4.9/5

(36)

Question 61

System statistics gathering is controlled by the TIMED_STATISTICS and ____ configuration parameters.

(Multiple Choice)

4.9/5

(35)

Question 62

The ANALYZE command is complex and hard to use.

(True/False)

4.9/5

(34)

Question 63

The ____ command is used to examine potential query plans that the optimizer may utilize,when executing a particular query of DML statement.

(Multiple Choice)

4.7/5

(36)

Question 64

The P$ Views are also known as the Oracle database performance views.

(True/False)

4.8/5

(36)

Question 65

____ is not a view that can be used for tracking locks.

(Multiple Choice)

4.7/5

(30)

Question 66

Performance monitoring is most easily performed with software tools custom built for the job.

(True/False)

5.0/5

(34)

Question 67

Statistics are very important to the way in which the ____ assesses the best way to execute a query.

(Multiple Choice)

4.8/5

(34)

Question 68

The primary objective of automation in statistics gathering for Oracle 10g,is to avoid situations of ____________________ or non-generated statistics.

(Short Answer)

4.8/5

(28)

Question 69

The ANALYZE command is more versatile and potentially faster than using the DBMS_STATS package to generate statistics.

(True/False)

4.8/5

(38)

Question 70

Autotrace can be enabled using the SET AUTOTRACE ENABLE EXPLAIN command,executed from within SQL*Plus.

(True/False)

4.8/5

(36)

Question 71

What is the role of the SAMPLE clause in automated statistics gathering?

(Essay)

4.9/5

(41)

Question 72

To monitor the performance of an Oracle database you must use any of the numerous third-party tools offered by companies for this purpose.

(True/False)

4.9/5

(40)

Question 73

Some locking is inevitable,especially in busy,highly concurrent OLTP databases.

(True/False)

4.9/5

(39)

Question 74

Solaris utilities such as sar,vmstat,mpstat,and iostat show CPU usage,I / O activity,and memory usage.

(True/False)

4.9/5

(36)

Question 75

Metrics can be found in many of the V$ performance views.

(True/False)

4.8/5

(47)

Question 76

____ is simply a formatting tool used to make the content of trace files readable to the human eye.

(Multiple Choice)

4.8/5

(50)

Question 77

In terms of an Oracle 10g database,____________________ is a measure of how fast the database reacts to access data in the database.

(Short Answer)

4.9/5

(35)

Question 78

A(n)____ lock partially locks data where there is still partial access allowed to data by other sessions.

(Multiple Choice)

4.9/5

(42)

Question 79

Statistics are a computation or estimation of the exact size and placement of data in tables and indexes.

(True/False)

4.8/5

(38)

Question 80

Showing 61 - 80 of 84

Lock ____________________ that require manual resolution are usually caused in error,such as executing a DDL command on an active production database,and locking a busy table.

System statistics gathering is controlled by the TIMED_STATISTICS and ____ configuration parameters.

The ANALYZE command is complex and hard to use.

The ____ command is used to examine potential query plans that the optimizer may utilize,when executing a particular query of DML statement.

The P$ Views are also known as the Oracle database performance views.

____ is not a view that can be used for tracking locks.

Performance monitoring is most easily performed with software tools custom built for the job.

Statistics are very important to the way in which the ____ assesses the best way to execute a query.

The primary objective of automation in statistics gathering for Oracle 10g,is to avoid situations of ____________________ or non-generated statistics.

The ANALYZE command is more versatile and potentially faster than using the DBMS_STATS package to generate statistics.

Autotrace can be enabled using the SET AUTOTRACE ENABLE EXPLAIN command,executed from within SQL*Plus.

What is the role of the SAMPLE clause in automated statistics gathering?

To monitor the performance of an Oracle database you must use any of the numerous third-party tools offered by companies for this purpose.

Some locking is inevitable,especially in busy,highly concurrent OLTP databases.

Solaris utilities such as sar,vmstat,mpstat,and iostat show CPU usage,I / O activity,and memory usage.

Metrics can be found in many of the V$ performance views.

____ is simply a formatting tool used to make the content of trace files readable to the human eye.

In terms of an Oracle 10g database,____________________ is a measure of how fast the database reacts to access data in the database.

A(n)____ lock partially locks data where there is still partial access allowed to data by other sessions.

Statistics are a computation or estimation of the exact size and placement of data in tables and indexes.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Proactive Maintenance

Backup and Recovery

Filters