oracle初始参数文件问题,求解,谢谢

来源：互联网发布：网络层的数据帧结构编辑：程序博客网时间：2024/05/16 18:16

我已经将初始化参数修改成功，当时重启数据库实例后，sga_max_size参数却未改变，但是从参数文件中看到的参数却是这样的我贴一下：

oracle.__db_cache_size=452984832
oracle.__java_pool_size=8388608
oracle.__large_pool_size=8388608
oracle.__oracle_base='E:\app\Administrator'#ORACLE_BASE set from environment
oracle.__pga_aggregate_target=520093696
oracle.__sga_target=771751936
oracle.__shared_io_pool_size=0
oracle.__shared_pool_size=293601280
oracle.__streams_pool_size=0
*.audit_file_dest='E:\app\Administrator\admin\oracle\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='E:\app\Administrator\oradata\oracle\control01.ctl','E:\app\Administrator\flash_recovery_area\oracle\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='oracle'
*.db_recovery_file_dest='E:\app\Administrator\flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='E:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=oracleXDB)'
*.local_listener='LISTENER_ORACLE'
*.memory_target=1288699904
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=536870912
*.sga_target=536870912
*.undo_tablespace='UNDOTBS1'

为什么sga_max_size在数据库中看却还是732M呢，上下这两个参数什么意思：oracle.__sga_target=771751936 *.sga_target=536870912;求解，谢谢，真心求解，谢谢