验证一个和 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>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19602/viewspace-2158796/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/19602/viewspace-2158796/