Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository?

Which of the following initialization parameters have been deprecated in Oracle 11g because of
the introduction of the Automatic Workload Repository? (Choose all that apply.)

Which of the following initialization parameters have been deprecated in Oracle 11g because of
the introduction of the Automatic Workload Repository? (Choose all that apply.)

A.
BACKGROUND_DUMP_DEST

B.
FOREGROUND_DUMP_DEST

C.
CORE_DUMP_DEST

D.
USER_DUMP_DEST

E.
DIAGNOSTIC_DEST

F.
All of the above

Show Hint

Leave a Reply 5

Your email address will not be published. Required fields are marked *

15 − 10 =

Helcio

Helcio

Initialization Parameters Deprecated in Oracle Database 11g Release 1 (11.1)

The following initialization parameters were deprecated in Oracle Database 11g Release 1 (11.1). To get a list of all deprecated initialization parameters, issue the following SQL statement:

SQL> SELECT name FROM v$parameter
WHERE isdeprecated = ‘TRUE’;
A deprecated parameter behaves the same way as a regular parameter, except that a warning message is displayed at instance startup if a deprecated parameter is specified in the parameter file. In addition, all deprecated parameters are logged to the alert log at instance startup.

BACKGROUND_DUMP_DEST (replaced by DIAGNOSTIC_DEST)
COMMIT_WRITE
CURSOR_SPACE_FOR_TIME
INSTANCE_GROUPS
LOG_ARCHIVE_LOCAL_FIRST
PLSQL_DEBUG (replaced by PLSQL_OPTIMIZE_LEVEL)
PLSQL_V2_COMPATIBILITY
REMOTE_OS_AUTHENT
RESOURCE_MANAGER_CPU_ALLOCATION
STANDBY_ARCHIVE_DEST
TRANSACTION_LAG attribute (of the CQ_NOTIFICATION$_REG_INFO object)
USER_DUMP_DEST (replaced by DIAGNOSTIC_DEST)

Reply

Helcio

Helcio

Initialization Parameters Deprecated in Oracle Database 11g Release 2 (11.2)

The following initialization parameters were deprecated in Oracle Database 11g Release 2 (11.2). To get a list of all deprecated initialization parameters, issue the following SQL statement:

SQL> SELECT name FROM v$parameter
WHERE isdeprecated = ‘TRUE’;
A deprecated parameter behaves the same way as a regular parameter, except that a warning message is displayed at instance startup if a deprecated parameter is specified in the parameter file. In addition, all deprecated parameters are logged to the alert log at instance startup.

ACTIVE_INSTANCE_COUNT
PARALLEL_IO_CAP_ENABLED

Reply

Helcio

Helcio

But I find this:

Starting in Oracle11g we not longer have many of the original OFA file system structures and we see that the ancient dump destination init.ora parms (core_dump_dest, background_dump_dest, user_dump_dest) are placed by a single diagnostic_dest parameter, the place to go when Oracle wants to take a dump.

Reply

Helcio

Helcio

The wording of the question is wrong. Where are you reading Automatic Workload Repository, read Automatic Diagnostic Repository (ADR).

Reply