Exam 13: Performance Monitoring

The DBMS_STATS package can be used to gather statistics at all object layers of an Oracle database,such as for tables,indexes,even for a whole schema or an entire database.

(True/False)

4.9/5

(29)

Question 21

ADDM stands for ___________________________________.

(Short Answer)

4.8/5

(32)

Question 22

The ANALYZE command is a little more complex to use than the DBMS_STATS package to generate statistics.

(True/False)

4.9/5

(41)

Question 23

The internal Oracle 10g Scheduler executes the GATHER_STATS_JOB job on a daily basis,by default.

(True/False)

4.9/5

(47)

Question 24

The ____ option of the ANALYZE command calculates statistics on a sample number or percentage of rows,defaulted to 1,064 rows.

(Multiple Choice)

4.8/5

(34)

Question 25

The ____ provides an easy-to-use interface into performance data stored in an Oracle database.

(Multiple Choice)

4.8/5

(37)

Question 26

The reason for a deadlock is that a pending ____________________ request cannot be serviced,because the lock required will never be released.

(Short Answer)

4.7/5

(35)

Question 27

The Windows Performance ____________________ displays graphical representations of resource usage.

(Short Answer)

4.8/5

(38)

Question 28

The heart of automated statistics gathering and management for Oracle 10g is in the ____________________ browser interface.

(Short Answer)

4.9/5

(37)

Question 29

What is the role of the TopNNNN tools?

(Essay)

4.8/5

(33)

Question 30

There are two easy ways to find invalid objects in Oracle 10g: (1)use the ____ metadata view and check the STATUS column,and (2)the metrics contained within the Database Control for finding invalid objects.

(Multiple Choice)

4.9/5

(31)

Question 31

Statistics can be gathered manually using a command-line tool such as SQL*Plus,with the ____ command or the DBMS_STATS package.

(Multiple Choice)

4.9/5

(37)

Question 32

From a purely performance perspective V$ views provide a picture of statistics,and the ability to drill-down into those statistics.

(True/False)

4.8/5

(34)

Question 33

AWR stands for ______________________________.

(Short Answer)

4.9/5

(40)

Question 34

Performance is really a measure of how quickly a database reacts to at a given request or activity.

(True/False)

4.8/5

(43)

Question 35

The ____ option of the ANALYZE command collects only system statistics,not user schema statistics.

(Multiple Choice)

4.8/5

(39)

Question 36

____________________ reads a small number of blocks in a table to make a best guess at the statistical picture of data in a table.

(Short Answer)

4.8/5

(43)

Question 37

The ____ utility can be used to join the trace activity of a single session,from multiple trace files,when using a shared server configuration.

(Multiple Choice)

4.7/5

(33)

Question 38

A(n)____________________ is the state of all data,in an entire database,at a specific point in time.

(Short Answer)

4.7/5

(33)

Question 39

In general you should resolve lock conflicts manually when those conflicts are caused by applications.

(True/False)

4.8/5

(31)

Question 40

Showing 21 - 40 of 84

The DBMS_STATS package can be used to gather statistics at all object layers of an Oracle database,such as for tables,indexes,even for a whole schema or an entire database.

ADDM stands for ___________________________________.

The ANALYZE command is a little more complex to use than the DBMS_STATS package to generate statistics.

The internal Oracle 10g Scheduler executes the GATHER_STATS_JOB job on a daily basis,by default.

The ____ option of the ANALYZE command calculates statistics on a sample number or percentage of rows,defaulted to 1,064 rows.

The ____ provides an easy-to-use interface into performance data stored in an Oracle database.

The reason for a deadlock is that a pending ____________________ request cannot be serviced,because the lock required will never be released.

The Windows Performance ____________________ displays graphical representations of resource usage.

The heart of automated statistics gathering and management for Oracle 10g is in the ____________________ browser interface.

What is the role of the TopNNNN tools?

There are two easy ways to find invalid objects in Oracle 10g: (1)use the ____ metadata view and check the STATUS column,and (2)the metrics contained within the Database Control for finding invalid objects.

Statistics can be gathered manually using a command-line tool such as SQL*Plus,with the ____ command or the DBMS_STATS package.

From a purely performance perspective V$ views provide a picture of statistics,and the ability to drill-down into those statistics.

AWR stands for ______________________________.

Performance is really a measure of how quickly a database reacts to at a given request or activity.

The ____ option of the ANALYZE command collects only system statistics,not user schema statistics.

____________________ reads a small number of blocks in a table to make a best guess at the statistical picture of data in a table.

The ____ utility can be used to join the trace activity of a single session,from multiple trace files,when using a shared server configuration.

A(n)____________________ is the state of all data,in an entire database,at a specific point in time.

In general you should resolve lock conflicts manually when those conflicts are caused by applications.

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