One of the main drivers I discovered is CPU_COUNT.
So I did some tests based in the past for version, now up to 21.
the script I used this time is basically (of course with proper version name).
In comparison to previous versions sga_target is bigger again, now it's 12g (otherwise instances with higher ocunts wouldn't even start)
To get a good picture of the changes, feel free to select parameters, versions or whatever you want below.
Raw data is available at GistHub.
The js app is available here.
(It's based on an idea PerfSheet.js by Luca Canali.
As some of the values are not numbers, I applied this mapping:
#!/usr/bin/ksh -x integer i=1 while ((i <= 255)); do print " $i "; echo "*.audit_file_dest='/_some_dir_/BX1/adump' *.audit_trail='db' *.compatible='21.0.0.0.0' *.control_files='/u02/oradata/CDB1/control01.ctl','/u02/oradata/CDB1/control02.ctl' *.db_block_size=8192 *.db_create_file_dest='/u02/oradata' *.db_name='cdb1' *.db_unique_name='cdb1' *.diagnostic_dest='/u01/appl/oracle' *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=12g *.enable_pluggable_database=true *.undo_tablespace='UNDOTBS1' *._disable_cpu_check='TRUE' *.cpu_count=$i" > /_some_dir_/cpus/initBX1_$i.ora echo "shutdown abort; startup pfile='/_some_dir_/cpus/initBX1_$i.ora' ; insert into init_parameters select '21.08' , $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/21doit$i.sql sqlplus "/ as sysdba" @cpus/21doit$i.sql >cpus/21log$i.log sleep 5 (( i = i + 1)); done
To get a good picture of the changes, feel free to select parameters, versions or whatever you want below.
Raw data is available at GistHub.
The js app is available here.
(It's based on an idea PerfSheet.js by Luca Canali.
As some of the values are not numbers, I applied this mapping:
TRUE | 1 |
FALSE | 0 |
OFF | 0 |
ADAPTIVE | -1 |
INSTANCE | -2 |
Keine Kommentare:
Kommentar veröffentlichen