1Z0-052 · Question #187
View the Exhibit and examine the output of the query. What do you infer from this?
The correct answer is C. The server parameter file (SPFILE) was used to start the instance. The query exhibit shows the SPFILE parameter with a non-null path value, confirming the instance was started using a server parameter file (SPFILE) rather than a text-based PFILE.
Question
View the Exhibit and examine the output of the query. What do you infer from this?
Exhibit
Options
- AThe SGA_TARGET is a static parameter.
- BThe instance is started, but the database is not yet open.
- CThe server parameter file (SPFILE) was used to start the instance.
- DThe SGA_TARGET parameter does not have any effect on the database instance until the SGA_MAX_SIZE
How the community answered
(32 responses)- A16% (5)
- B3% (1)
- C72% (23)
- D9% (3)
Why each option
The query exhibit shows the SPFILE parameter with a non-null path value, confirming the instance was started using a server parameter file (SPFILE) rather than a text-based PFILE.
SGA_TARGET is a dynamic parameter with ISSYS_MODIFIABLE = IMMEDIATE, meaning it can be changed without restarting the instance; it is not a static parameter.
If the instance were started but the database not yet open (MOUNT state), the query against V$PARAMETER would still return results, but mount state is determined from V$INSTANCE or V$DATABASE, not from the SPFILE parameter value.
When the output of SHOW PARAMETER SPFILE or a query on V$PARAMETER displays a non-null, non-empty value for the spfile parameter, it definitively means the instance was started with an SPFILE. An SPFILE-started instance automatically persists changes made via ALTER SYSTEM to the binary parameter file, and the SPFILE path is visible in V$PARAMETER.
SGA_TARGET is fully effective when set; it controls Automatic Shared Memory Management (ASMM) by directing Oracle to automatically size SGA components within the SGA_MAX_SIZE boundary.
Concept tested: Identifying SPFILE usage via V$PARAMETER output
Source: https://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams252.htm
Topics
Community Discussion
No community discussion yet for this question.
