Parameter change as a result of changing auto to manual memory management in 11g col ksppinm for a45 col "SessVal" for a43 col "InstVal" for a43 set lin 143 trims on pages 1000 array 100 spo a select a.ksppinm, b.ksppstvl "SessVal", c.ksppstvl "InstVal" from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx order by 1; spo off alter system set memory_target = 0 scope = spfile; alter system set sga_target = 0 scope = spfile; alter system set shared_pool_size = 536870912 scope = spfile; startup force col ksppinm for a45 col "SessVal" for a43 col "InstVal" for a43 set trims on pages 1000 array 100 spo c select a.ksppinm, b.ksppstvl "SessVal", c.ksppstvl "InstVal" from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx order by 1; spo off SQL> !diff a.lst c.lst | egrep -v '^---|^[0-9]' < __db_cache_size 452984832 452984832 > __db_cache_size 50331648 50331648 < __java_pool_size 16777216 16777216 < __large_pool_size 16777216 16777216 > __java_pool_size 25165824 25165824 > __large_pool_size 0 0 < __pga_aggregate_target 301989888 301989888 > __pga_aggregate_target 10485760 10485760 < __shared_pool_size 419430400 419430400 > __shared_pool_size 536870912 536870912 < _cursor_db_buffers_pinned 340 340 > _cursor_db_buffers_pinned 35 35 < _db_block_buffers 51327 51327 > _db_block_buffers 5688 5688 < _db_block_hash_buckets 131072 131072 < _db_block_hash_latches 4096 4096 > _db_block_hash_buckets 16384 16384 > _db_block_hash_latches 1024 1024 < _db_file_exec_read_count 128 128 > _db_file_exec_read_count 33 33 < _db_writer_coalesce_area_size 4194304 4194304 > _db_writer_coalesce_area_size 491520 491520 < _enable_shared_pool_durations TRUE TRUE > _enable_shared_pool_durations FALSE FALSE < _ksmg_granule_size 16777216 16777216 > _ksmg_granule_size 4194304 4194304 < _memory_broker_shrink_heaps 15 15 > _memory_broker_shrink_heaps 0 0 < _small_table_threshold 1026 1026 > _small_table_threshold 113 113 < _smm_max_size 58982 58982 < _smm_min_size 294 294 < _smm_px_max_size 147456 147456 > _smm_max_size 2048 2048 > _smm_min_size 128 128 > _smm_px_max_size 5120 5120 < db_cache_size 0 0 > db_cache_size 50331648 50331648 < db_file_multiblock_read_count 128 128 > db_file_multiblock_read_count 33 33 < java_pool_size 0 0 > java_pool_size 25165824 25165824 < log_buffer 8777728 8777728 > log_buffer 7355392 7355392 < memory_max_target 1224736768 1224736768 < memory_target 1224736768 1224736768 > memory_max_target 0 0 > memory_target 0 0 < pga_aggregate_target 0 0 > pga_aggregate_target 10485760 10485760 < result_cache_max_size 3080192 3080192 > result_cache_max_size 5373952 5373952 < sga_max_size 1224736768 1224736768 > sga_max_size 624951296 624951296 < shared_pool_reserved_size 20971520 20971520 < shared_pool_size 0 0 > shared_pool_reserved_size 26843545 26843545 > shared_pool_size 536870912 536870912 SQL> !diff a.lst c.lst | egrep -v '^---|^[0-9]' | wc -l 58 SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production PL/SQL Release 11.1.0.6.0 - Production CORE 11.1.0.6.0 Production TNS for Linux: Version 11.1.0.6.0 - Production NLSRTL Version 11.1.0.6.0 - Production SQL> !uname -a Linux thehostname 2.6.9-55.ELsmp #1 SMP Fri Apr 20 16:36:54 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux