Oracle 1Z0-031 Oracle9i Database: Fundamentals

What information is found in the DBA_EXTENTS data dictionary view?

a. descriptions of all of the extents that include information about one specified database object

b. descriptions of all of the extents that include information about objects that are owned by the current user

c. descriptions of all of the extents that include information about objects that are owned by a specified group of users

d. descriptions of all of the extents in a database


--------------------------------------------------------------------------------
Answer to yesterday's question:
Taken from CERT-1Z0-032
Related Exam: Oracle 1Z0-032 Oracle9i Database: Fundamentals II

Choice b is correct. If the FAST_START_IO_TARGET, FAST_START_MTTR_TARGET, LOG_CHECKPOINT_INTERVAL and LOG_CHECKPOINT_TIMEOUT parameters are specified in the init.ora file, then the FAST_START_MTTR_TARGET parameter will be overridden. The FAST_START_MTTR_TARGET parameter specifies the number of seconds that recovery should take to complete. Oracle internally calculates parameters so that the recovery time is as close as possible to the FAST_START_MTTR_TARGET parameter value. However, the FAST_START_MTTR_TARGET parameter is overridden by the FAST_START_IO_TARGET, LOG_CHECKPOINT_INTERVAL and LOG_CHECKPOINT_TIMEOUT parameters; these parameters should be disabled or removed if the FAST_START_MTTR_TARGET parameter is used.

The FAST_START_IO_TARGET parameter specifies the number of I/O operations that should be used for cache recovery. The LOG_CHECKPOINT_INTERVAL parameter specifies the maximum number of blocks between a checkpoint and the last redo log block. The LOG_CHECKPOINT_TIMEOUT parameter specifies the maximum number of seconds between a checkpoint and the last redo log block.

References:

F2EG, Chapter 8, Fast-start Checkpoints, p. 174.

Oracle9i Database Online Documentation Web Site, Oracle9i Database Performance Guide and Reference, Configuring Instance Recovery Performance.