ORACLE alter system 命令 scope解释
来源:互联网 发布:圣剑神域全套完整源码 编辑:程序博客网 时间:2024/06/08 12:02
alter system 命令 scope解释:
SCOPE
The SCOPE clause lets you specify when the change takes effect. Scope depends on whether you started up the database using a client-side parameter file (pfile) or server parameter file (spfile).
scope可指定对system的修改何时生效,scope=memory|spfile|both ,值取决于数据库使用pfile还是spfile启动
MEMORY
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.
scope=memory,表示修改立即生效,持续到数据库关闭为止,若数据库使用pfile启动,这是唯一可选值,也是默认值。
SPFILE
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.
scope=spfile ,会修改spfile参数,新设置只有在重新使用spfile启动数据库的时候生效。
另外,若是修改静态参数(不能直接生效的参数),必须指定scope=spfile,否则若指定memory或者both会报如下错误:
ORA-02095: specified initialization parameter cannot be modified
因为静态参数不能直接通过修改内存而生效,只能通过修改spfile然后重启数据库生效。
BOTH (若)
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.
scope=both,表示修改会发生在内存上立即生效,并修改spfile保证数据库重启后也生效。
If a server parameter file was used to start up the database, then BOTH is the default. If a parameter file was used to start up the database, then MEMORY is the default, as well as the only scope you can specify.
若数据库使用spfile启动,则scope=both是默认值
若数据库使用pfile启动,则scope=memory是默认值,也是唯一值。
静态参数,不能通过修改内存(默认scope值或scope=memory或scope=both)来生效,要通过修改spfile(),重启数据库来生效。
- ORACLE alter system 命令 scope解释
- ORACLE alter system 命令 scope解释
- Oracle中alter system命令参数之scope(转载)
- Oracle中control_file_record_keep_time及alter system命令参数之scope
- alter system set ...scope.... 杂谈
- alter databas/alter system/alter session命令区别
- Oracle alert log ALTER SYSTEM SET service_names='','SYS$SYS.KUPC$C_...' SCOPE=MEMORY SID='' 说明
- alter system修改oracle参数
- Oracle命令--alter 操作
- Oracle alter session命令
- oracle alter命令大全
- oracle alter session和alter system的参数详解
- ALTER SYSTEM CHECK DATAFILES命令的使用
- alter system flush "oracle的缓存"
- 说说Oracle监听器( alter system register)
- alter system flush“oracle的缓存”
- oracle 中 alter system set|reset
- alter system flush "oracle的缓存"
- 用电视盒看电视经常黑屏
- Round #1 B. Spreadsheets
- disable_irq 和 disable_irq_nosync
- 归并排序(JAVA版)
- hdu 2089 不要62(数位dp入门)
- ORACLE alter system 命令 scope解释
- tomcat链接mysql时超时报错java.io.EOFException: Can not read response from server. Expected to read 4 bytes,
- windows通过vnc连接linux
- sql打开使某一列按照指定数据
- 一步一步学数据结构之1--1(栈--单链表实现)
- 用户登录AD0 0x80040e31
- 关于MFC中窗口最大化
- Codeforces Beta Round #74 (Div. 2 Only) A题
- 展讯 sensor