Which three values can be specified for the SCOPE clause?

You decided to increase the value for the SHARED_SERVERS parameter by using the following
command:
SQL> ALTER SYSTEM SET SHARED_SERVERS=3 SCOPE=?;
Which three values can be specified for the SCOPE clause? (Choose three.)

You decided to increase the value for the SHARED_SERVERS parameter by using the following
command:
SQL> ALTER SYSTEM SET SHARED_SERVERS=3 SCOPE=?;
Which three values can be specified for the SCOPE clause? (Choose three.)

A.
ALL

B.
PFILE

C.
BOTH

D.
NONE

E.
SPFILE

F.
MEMORY

G.
INSTANCE

H.
DATABASE

Show Hint

Leave a Reply 1

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

jean

jean

As with other parameters, this command can be used to change the current instance. If an SPFILE is in use, the parameter can be changed for future instances as well. For example, to activate three shared servers in the current instance and the SPFILE, enter this command:

SQL> ALTER SYSTEM SET SHARED_SERVERS=3 SCOPE=BOTH;

SCOPE
The SCOPE clause lets you specify when the change takes effect. Scope depends on whether you started up the database using a traditional plain-text parameter file (pfile) or server parameter file (spfile).

MEMORY indicates that the change is made in memory, takes effect immediately, and persists until the database is shut down. If you started up the database using a parameter file (pfile), then this is the only scope you can specify.

SPFILE indicates that the change is made in the server parameter file. The new setting takes effect when the database is next shut down and started up again. You must specify SPFILE when changing the value of a static parameter that is described as not modifiable in Oracle Database Reference.

BOTH indicates that the change is made in memory and in the server parameter file. The new setting takes effect immediately and persists after the database is shut down and started up again.

Reply