052-228(新增70题2018)

最新推荐文章于 2025-05-28 23:39:14 发布

dieqiao8331

最新推荐文章于 2025-05-28 23:39:14 发布

阅读量91

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/Babylon/p/8618591.html

版权

本文讲解了如何在Oracle数据库中使用ALTER SYSTEM命令调整SHARED_SERVERS参数，并详细解释了SCOPE子句的不同选项，包括SPFILE、MEMORY和INSTANCE。同时，文章提供了查询参数是否可立即修改的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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
Answer: CEF

SQL> select  issys_modifiable from v$parameter where NAME='shared_servers';
ISSYS_MODIFIABLE
----------------
IMMEDIATE
--可以在内存里修改

SHARED_SERVERS

Modifiable　　ALTER SYSTEM
If you are using shared server architecture or if the DISPATCHERSparameter is set such that the total number of dispatchers is more than 0, then the default value is 1.默认值是0或者1
0, meaning that shared server is not on.

SCOPE=SPFILE：