www.Orasql.Com
 
用户名: 密码:  验证码: 注册|找回密码 oracleawen's blog  
 
         当前位置 >> 技术论坛  发表帖子     论坛版块     查找帖子
spfile设置scope问题-技术论坛||Oracle高手之路—Orasql.Com!
            spfile设置scope问题
 
发贴人:oracle_awen
oracleawen@gmail.com448315233127.0.0.1
用户级别:管理员
发贴总数:1245
注册时间:2011-05-05 09:23:03
2011-06-01 08:15:45
spfile设置scope问题 系统rhel4as4 数据库oracle10g 1系统修改前 查看系统spfile文件 [oracle@sphost dbs]$ more spfileora10.ora .audit_file_dest='/home/oracle/admin/ora10/adump' .background_dump_dest='/home/oracle/admin/ora10/bdump' .compatible='10.2.0.1.0' .control_files='/home/oracle/oradata/ora10/control01.ctl','/home/oracle/oradata/ora10/control02.ctl','/home/oracle/oradata/ora10/co ntrol03.ctl' .core_dump_dest='/home/oracle/admin/ora10/cdump' .db_block_size=8192 .db_cache_size=99614720 .db_domain='' .db_file_multiblock_read_count=16 .db_name='ora10' .db_recovery_file_dest='/home/oracle/flash_recovery_area' .db_recovery_file_dest_size=2147483648 .java_pool_size=8 .job_queue_processes=10 .large_pool_size=8388608 .nls_territory='china' .open_cursors=300 .pga_aggregate_target=25165824 .processes=150 .remote_login_passwordfile='exclusive' .shared_pool_size=157286400 .undo_management='auto' .undo_tablespace='undotbs1' .user_dump_dest='/home/oracle/admin/ora10/udump' 2登陆数据库,启动实例,查看参数文件 [oracle@sphost ~]$ sqlplus '/as sysdba' sqlplus release 10.2.0.1.0 - production on tue nov 16 233805 2010 copyright (c) 1982, 2005, oracle. all rights reserved. connected to an idle instance. sql> startup; oracle instance started. total system global area 276824064 bytes fixed size 1218944 bytes variable size 171968128 bytes database buffers 100663296 bytes redo buffers 2973696 bytes database mounted. database opened. sql> show parameter spfile; name type value ------------------------------------ ----------- ------------------------------ spfile string /home/oracle/10.2.0/dbs/spfile ora10.ora sql> show parameter java_pool_size; name type value ------------------------------------ ----------- ------------------------------ java_pool_size big integer 4m 3将scope设置为spfile sql> alter system set java_pool_size=9m scope=spfile; system altered. sql> sql> show parameter spfile; name type value ------------------------------------ ----------- ------------------------------ spfile string /home/oracle/10.2.0/dbs/spfile ora10.ora sql> show parameter java_pool_size; name type value ------------------------------------ ----------- ------------------------------ java_pool_size big integer 4m 从上面的结果中发现当前 sql命令行,java_pool_size 的值 还是为4m 4查看参数文件 [oracle@sphost dbs]$ more spfileora10.ora ? .background_dump_dest='/home/oracle/admin/ora10/bdump' .compatible='10.2.0.1.0' .control_files='/home/oracle/oradata/ora10/control01.ctl','/home/oracle/oradata/ora10/control02.ctl','/home/oracle/oradata/ora10/co ntrol03.ctl' .core_dump_dest='/home/oracle/admin/ora10/cdump' .db_block_size=8192 .db_cache_size=99614720 .db_domain='' .db_file_multiblock_read_count=16 .db_name='ora10' .db_recovery_file_dest='/home/oracle/flash_recovery_area' .db_recovery_file_dest_size=2147483648 .java_pool_size=9437184 .job_queue_processes=10 .large_pool_size=8388608 .nls_territory='china' .open_cursors=300 .pga_aggregate_target=25165824 .processes=150 .remote_login_passwordfile='exclusive' .shared_pool_size=157286400 .undo_management='auto' .undo_tablespace='undotbs1' .user_dump_dest='/home/oracle/admin/ora10/udump' 从以上结果中发现当前参数文件为9m,而通过sql命令行 依然为 4m 5关闭数据库,然后再次查看 sql> shutdown immediate; database closed. database dismounted. oracle instance shut down. sql> exit disconnected from oracle database 10g enterprise edition release 10.2.0.1.0 - production with the partitioning, olap and data mining options [oracle@sphost ~]$ sqlplus '/as sysdba' sqlplus release 10.2.0.1.0 - production on tue nov 16 235428 2010 copyright (c) 1982, 2005, oracle. all rights reserved. connected to an idle instance. sql> startup;oracle instance started. total system global area 285212672 bytes fixed size 1218992 bytes variable size 180356688 bytes database buffers 100663296 bytes redo buffers 2973696 bytes database mounted. database opened. sql> show parameter spfile; name type value ------------------------------------ ----------- ------------------------------ spfile string /home/oracle/10.2.0/dbs/spfile ora10.ora sql> show parameter java_pool_size; name type value ------------------------------------ ----------- ------------------------------ java_pool_size big integer 12m sql> 6关闭数据库后,查看参数文件 oracle@sphost dbs]$ more spfileora10.ora ? .background_dump_dest='/home/oracle/admin/ora10/bdump' .compatible='10.2.0.1.0' .control_files='/home/oracle/oradata/ora10/control01.ctl','/home/oracle/oradata/ora10/control02.ctl','/home/oracle/oradata/ora10/co ntrol03.ctl' .core_dump_dest='/home/oracle/admin/ora10/cdump' .db_block_size=8192 .db_cache_size=99614720 .db_domain='' .db_file_multiblock_read_count=16 .db_name='ora10' .db_recovery_file_dest='/home/oracle/flash_recovery_area' .db_recovery_file_dest_size=2147483648 .java_pool_size=9437184 .job_queue_processes=10 .large_pool_size=8388608 .nls_territory='china' .open_cursors=300 .pga_aggregate_target=25165824 .processes=150 .remote_login_passwordfile='exclusive' .shared_pool_size=157286400 .undo_management='auto' .undo_tablespace='undotbs1' .user_dump_dest='/home/oracle/admin/ora10/udump 从以前结果中,看出每次通过在线修改scope=spfile值,可以立即将修改后的值生效到 当前的 参数文件中,但是在sql> 中查看的结果并不一样,请前辈指点。

      
 
  
 Orasql.Com|E-Mail:oracleawen@gmail.com|Phone:15271942915|Copyright © 2011|All Rights Reserved|