驗證一個和 initialization parameters pfile有關的052考試題

7 、Which three statements are true about initialization parameters and files?

A) Session modifiable initialization parameters can only be changed by a user with the DBA role.

B) An idle instance must start with a pfile .

1. The ALTER SYSTEM command can be used to change parameter values for an instance started using a PFILE.

2. An SPFILE can be created from an idle instance.

3. System modifiable initialization parameters can only be changed by the SYS user.

4. The ALTER SYSTEM command can be used to change parameter values for an instance started using an SPFILE.

   G)    Session modifiable initialization parameters can only be changed once per session.

   Answer: CDF

--======================

SQL> show user
USER 為 "XYS"

SQL> alter system set processes=200 scope=spfile;

系統已更改。

SQL> show user
USER 為 "XYS"

 

下面操作是用SYS開了另外一個session：

SQL> show parameter pga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target                 big integer 90M
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> alter system set pga_aggregate_target=100m;

系統已更改。

SQL> shutdown immediate
資料庫已經關閉。
已經解除安裝資料庫。
ORACLE 例程已經關閉。
SQL> create spfile from pfile;

檔案已建立。

SQL>