nerdexam
Oracle

1Z0-062 · Question #247

Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change thevalue of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET…

The correct answer is B. It returns an error because the value of this parameter cannot be changed dynamically. The LOG_BUFFER initialization parameter is static, meaning its value cannot be changed dynamically using ALTER SYSTEM while the database instance is running.

Managing the Database Instance

Question

Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change thevalue of the LOG_BUFFER initialization parameter:

ALTER SYSTEM SET LOG_BUFFER=32 M; What is the outcome of this command?

Options

  • AThe parameter value is changed and it comes into effect as soon as space becomes available in
  • BIt returns an error because the value of this parameter cannot be changed dynamically.
  • CThe parameter value is changed and it comes into effect at the next instance startup.
  • DIt returns an error because SCOPE should be set to MEMORY.

How the community answered

(45 responses)
  • A
    2% (1)
  • B
    89% (40)
  • C
    2% (1)
  • D
    7% (3)

Why each option

The `LOG_BUFFER` initialization parameter is static, meaning its value cannot be changed dynamically using `ALTER SYSTEM` while the database instance is running.

AThe parameter value is changed and it comes into effect as soon as space becomes available in

`LOG_BUFFER` is a static parameter and cannot be changed dynamically regardless of memory availability.

BIt returns an error because the value of this parameter cannot be changed dynamically.Correct

The `LOG_BUFFER` parameter defines the fixed size of the redo log buffer, which is allocated at instance startup. As a static parameter, it cannot be modified dynamically using `ALTER SYSTEM` while the database is running; such an attempt will result in an error.

CThe parameter value is changed and it comes into effect at the next instance startup.

Although changes to static parameters in the SPFILE take effect upon the next instance startup, attempting to change `LOG_BUFFER` with `ALTER SYSTEM SET` when it's a static parameter will fail immediately with an error, it will not just defer the effect.

DIt returns an error because SCOPE should be set to MEMORY.

Even with `SCOPE=MEMORY`, `LOG_BUFFER` cannot be changed because it is a static parameter, and an error would still occur indicating that dynamic modification is not permitted.

Concept tested: Static vs. dynamic initialization parameters

Source: https://docs.oracle.com/en/database/oracle/oracle-database/21/admin/managing-initialization-parameters.html#GUID-FCABF074-E09B-40F3-9D5C-376B13576C78

Topics

#initialization parameters#SPFILE#dynamic parameters#LOG_BUFFER

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice