Some DB versions passed by so I decided it's time for another check. This time it's 12.1.0.2 without any PSUs/patches. The machine is the same class as previous, so it took some time.
the script is nearly the same today:
!/usr/bin/ksh -x
integer i=1
while ((i <= 128));
do
print " $i ";
echo "*.audit_file_dest='/appl/oracle/admin/BERX3_GLOBAL/adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='/appl/oracle/oradata/BERX3_GLOBAL/controlfile/o1_mf_c9h3bxlw_.ctl','/appl/oracle/fast_recovery_area/BERX3_GLOBAL/controlfile/o1_mf_c9h3bxpg_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/appl/oracle/oradata'
*.db_name='BERX3_GL'
*.db_recovery_file_dest='/appl/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4815m
*.db_unique_name='BERX3_GLOBAL'
*.diagnostic_dest='/appl/oracle'
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=13g
*.undo_tablespace='UNDOTBS1'
*.cpu_count=$i" > /appl/home/oracle/instance_parameters/cpus/initBERX2_$i.ora
echo "startup pfile='/appl/home/oracle/instance_parameters/cpus/initBERX2_$i.ora' ;
insert into init_parameters
select $i ,
a.ksppinm ,
b.ksppstvl ,
c.ksppstvl
from x\$ksppi a, x\$ksppcv b, x\$ksppsv c
where a.indx = b.indx and a.indx = c.indx;
commit;
select distinct(\"CPUs\") from init_parameters;
shutdown;
exit;"> cpus/doit$i.sql
sqlplus "/ as sysdba" @cpus/doit$i.sql >cpus/log$i.log
sleep 5
(( i = i + 1));
done
And all the values interesting is available again.
There are 40 parameters now changing value based on cpu_count - so a lot more of things which will change, when you "only" add/remove CPUs or alter instance caging.
Here are the graphs for 12.1.0.2 - and 11.1.0.7 if they exist already. Some look quite different.
__db_cache_size
11.1.0.7:
__java_pool_size
__large_pool_size
__shared_pool_size
11.1.0.7:
_cursor_db_buffers_pinned
11.1.0.7:
_db_block_buffers
11.1.0.7:
_db_block_lru_latches
11.1.0.7:
_db_handles
_enqueue_hash
_enqueue_hash_chain_latches
11.1.0.7:
_enqueue_locks
11.1.0.7:
_enqueue_resources
_flashback_generation_buffer_size
11.1.0.7:
_kghdsidx_count
11.1.0.7:
_log_parallelism_max
11.1.0.7:
_log_simultaneous_copies
11.1.0.7:
_max_outstanding_log_writes
_max_pending_scn_bcasts
_messages
_num_longop_child_latches
11.1.0.7:
_parallel_min_message_pool
11.1.0.7:
_px_proactive_slave_alloc_threshold
_session_allocation_latches
_shared_server_num_queues
11.1.0.7:
_small_table_threshold
11.1.0.7:
_spin_count
11.1.0.7:
_sqlmon_max_plan
11.1.0.7:
_use_single_log_writer
db_writer_processes
11.1.0.7:
dml_locks
log_buffer
11.1.0.7:
parallel_max_servers
11.1.0.7:
parallel_min_servers
parallel_servers_target
pga_aggregate_limit
processes
sessions
shared_pool_reserved_size
transactions
