■哪些参数可以用Alter System修改alter system 命令可以用来修改
数据库的初始化参数。
具体哪些参数可以修改,可以从v$parameter动态性能视图中的列ISSYS_MODIFIABLE中确定。
■alter system的语法
alter system 参数名 = 参数值 [ COMMENT 'text' ][ DEFERRED ][ SCOPE = { MEMORY | SPFILE | BOTH } ][ SID = { 'sid' | * } ]
1)comment 'text'表示要修改的参数的注释。
2)deferred 表示修改的参数应用到以后连接的session
3)scope={ MEMORY | SPFILE | BOTH }
表示所作的修改应用到哪里,内存,spfile文件,或是内存和spfile都修改.
4)SID = { 'sid' | * }
如果选择sid,那么表示修改的是某个session的参数。这个参数只是在真实应用集群环境下有效。
如果要修改所有sid的参数,设置sid='*'
如果要修改某个sid的参数,设置sid='sid' ,sid是指定的要修改的session的sid.
■SCOPE的详细含义SCOPE的设定取值有如下三种:
1. SCOPE = SPFILE
既适用于动态初始化参数的修改,也使用与静态初始化参数的修改。也是静态参数唯一可以使用的方式。
对参数的修改仅记录在
服务器初始化参数文件中,更改将在下次DB启动时生效。
2. SCOPE = MEMORY
只适用于动态初始化参数的修改。静态参数不允许。
对参数的修改仅在内存上,立即生效,但重启后将不再有效,因为并没有写入到初始化参数文件。
DB重启后这个修改会丢失,参数复原为修改前的参数值。
3. SCOPE = BOTH
只适用于动态初始化参数的修改。静态参数不允许。
对参数的修改同时既写入到初始化参数文件,也在内存上修改,立即生效。
★★★★★★★★★
注意:
1. 在修改静态初始化参数时,我们只能指定scope=spfile;
2. 在修改动态初始化参数时,我们可以指定 deferred 关键字来对所做的修改延迟到新的session产生时生效。
★★★★★★★★★
分享到:
相关推荐
create spfile from pfile,启动数据库即可, 也可以alter system set parametervalue=parametervalue scope = spfile 数据库重启后参数生效、 a. 从spfile生成pfile,修改pfile,再从pfile生成spfile b. 直接用VI...
alter system set sga_max_size=960M scope=spfile; shutdown immediate startup 此时的startup报错了,错误为: SQL> startup ORA-00844: Parameter not taking MEMORY_TARGET into account ORA-00851: SGA_MAX_...
SQL>alter system set control_files=’/u01/app/oracle/oradata/prod/ora_control1.ctl’,’/u01/app/oracle/oradata/prod/ora_control2.ctl’ scope=spfile; 解决方法: 1.show parameter spfile; 这时候可以...
有时不清楚一些参数的... alter system set “_db_block_cache_protect”=what scope=spfile * ERROR at line 1: ORA-00096: invalid value WHAT for parameter _db_block_cache_protect, must be from among TRUE, M
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=4294967296 SCOPE=BOTH; System altered. SQL> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down.
SQL> alter system set cluster_database=false scope=spfile sid='orcl1'; SQL> alter system set db_recovery_file_dest='+ORAFLASH' scope=spfile; SQL> alter system set db_recovery_file_dest_size=20g ...
alter system set utl_file_dir='d:\temp\a' scope=spfile; 安装 sqlplus /nolog conn /as sysdba @?/rdbms/admin/dbmslm.sql @?/rdbms/admin/dbmslmd.sql 使用LogMiner工具 9i: alter system set UTL_...
然后 更改系统连接数 alter system set processes=1000 scope=spfile; 下面是具体的操作步骤与说明问题描述:客户端连接数据库报错 ORA-12516: TNS: 监听程序无法找到匹配协议栈的可用句柄 解决过程: 1。查看当前...
直接如题查看当前数据库模式 连接进入数据库,键入以下命令: 代码如下: SQL> ...设置方式如下: 代码如下: SQL> alter system set log_archive_dest_1=”location=path” scope=both; 其中,path是存储归档日志文件
问题描述: ... 1、sql>alter system set "_ALLOW_RESETLOGS_CORRUPTION"=true scope=spfile; System altered. 2、sql>shutdown immediate ORA-01109:数据库未打开 已经卸载数据库 ORACLE
alter system set job_queue_processes=39 scope=spfile;//最大值不能超过1000 ;job_queue_interval = 10 //调度作业刷新频率秒为单位 job_queue_process 表示oracle能够并发的job的数量,可以通过语句 show ...
问题描述 Plsql developer执行一段sql报错: 经查alert log详细报错信息为: ORA-07445: exception encountered: core dump [evaopn2()+128] ...alter system set "_complex_view_merging"=false scope=both; 2、使
It also gives an overview of open research problems at the end of the chapter to provide the scope of future work toward fully dynamic multi-objective VM placement problems. The thirteenth chapter on...
they are outside its scope. The act of running a program using the Library is not restricted, and output from such a program is covered only if its contents constitute a work based on the Library ...
they are outside its scope. The act of running a program using the Library is not restricted, and output from such a program is covered only if its contents constitute a work based on the Library ...
they are outside its scope. The act of running the Program is not restricted, and the output from the Program is covered only if its contents constitute a work based on the Program (independent of ...
Table of Contents Header Files The #define Guard Header File Dependencies Inline Functions The -inl.h Files Function Parameter Ordering Names and Order of Includes Scoping Namespaces Nested Classes ...
purpose, including commercial applications, and to alter it and redistribute it freely, subject to the following restrictions: 1. The origin of this software must not be misrepresented, you must...