select name, substr(order_recommendation,3) recommendation, substr(flags,1,1) "I", substr(flags,2,1) "U", remark, "SET", is_value, should_be_value, substr(order_recommendation,1,1) "ID", inst_idfrom( select decode(substr(c.name,1,3), '***',-1,c.inst_id) inst_id, decode(substr(c.name,1,3), '***',upper(c.name), decode(c.subname, ' ',c.name, c.name||' ('||c.subname||')')) name, decode(substr(c.name,1,3), '***','* '|| decode(substr(c.name,17,2), ' 1','Parametercheck for Oracle 11.2 based on Note/Version: 1431798/92', ' 2','Parametercheck last changed: 2014-11-24', ' 3','Parametercheck Execution: '||to_char(sysdate,'YYYY-MM-DD HH24:MI:SS'), ' 4','DB Startup: '||to_char(x_startup,'YYYY-MM-DD HH24:MI:SS')||decode(x_cluster_database,'TRUE',' (data of instance '||c.inst_id||')',''), ' 5','DB SID: '||x_db_name, ' 6','DB Environment: '||decode(x_olap,'TRUE','OLAP','UNKNOWN','OLTP or OLAP','OLTP')||decode(x_abap_stack,'TRUE',', ABAP stack',', not ABAP stack')||decode(x_cluster_database,'TRUE',', RAC',', not RAC')||decode(x_asm_used,'TRUE',', ASM',', not ASM')||decode(x_exadata_used,'TRUE',', EXADATA',', not EXADATA'), ' 7','DB Platform: '||x_platform_name||decode(x_cluster_database,'TRUE',' (data of instance '||c.inst_id||')',''), ' 8','DB Patchset: '||x_version||decode(x_cluster_database,'TRUE',' (data of instance '||c.inst_id||')',''), ' 9','Last detectable SAP Bundle Patch: '||decode(x_mergefix, 0,'none', x_mergefix_released||' (identified by bugno '||x_bugno||')')||decode(x_cluster_database,'TRUE',' (data of instance '||c.inst_id||')',''), '10','Reliability checks: events '||decode(x_event_contains_colon, 0,'passed', 'FAILED [event separator ":"'|| ' unsupported; see note 1431798]')||', _fix_controls '||decode(x_fix_control_reliable, 1,'passed', 'FAILED [not all _fix_controls are in'|| ' v$system_fix_control; note 1454675 ]')||decode(x_cluster_database, 'FALSE',' ', ', RAC Bug: '|| decode(substr(x_version,1,8), '11.2.0.2',decode(sign(x_mergefix-9), -1,'FAILED (note 1171650)', 'passed'), '11.2.0.3',decode(sign(x_mergefix-3), -1,'FAILED (note 1171650)', 'passed'), 'passed')), '11',decode(instr('1234',substr(x_version,8,1)),0,'WARNING: unsupp. patchset used =>'||' recommendations may not be valid =>'||' apply latest patchset (note 1431799)',decode(instr('12',substr(x_version,8,1)),0,'- no further information -','WARNING: no further SBP will be'||' released for this patchset =>'||' apply latest patchset (note 1431799)'))), decode(c.ismodified, 'FALSE', decode(c.isdefault, 'TRUE',decode(s.value, null,'Q ok (is not set; mentioned with other prerequisites/not mentioned in note)', decode(substr(s.value,1,5), '-man-','E check if default value "'||c.value||'" is suitable ('||substr(s.value,6)||')', '-aut-','H automatic check ok; doublecheck if default value "'||c.value||'" is suitable ('||substr(s.value,6)||')', '-any-','P ok (is not set; any value recommended)', '-del-','K ok (is not set; not to be set as explicitly mentioned in note)', decode(upper(c.value), upper(s.value),'J add explicitly with default value "'||s.value||'"','B add with value "'||s.value||'"'))), decode(s.value, null,'G check why set but mentioned with other prerequisites/not mentioned in note', decode(substr(s.value,1,5), '-man-','F check if value "'||c.value||'" is suitable ('||substr(s.value,6)||')', '-aut-','I automatic check ok; doublecheck if value "'||c.value||'" is suitable ('||substr(s.value,6)||')', '-any-','O ok (is set; any value recommended)', '-del-','C delete (is set; not to be set as explicitly mentioned in note)', decode( decode( substr(replace(upper(c.value),' ',''),1,length( substr(replace(upper(s.value),' ',''),1, instr(replace(upper(s.value),' ',''),'[')-1))), substr(replace(upper(s.value),' ',''),1, instr(replace(upper(s.value),' ',''),'[')-1),'X', ' ')|| decode( substr(replace(upper(c.value),' ',''),-length( substr(replace(upper(s.value),' ',''), instr(replace(upper(s.value),' ',''),']')+1))), substr(replace(upper(s.value),' ',''), instr(replace(upper(s.value),' ',''),']')+1),'X', ' '), 'XX','L ok (is set correctly =)', decode(sign( decode(rpad('>=',length(s.value),'X'), translate(s.value,'1234567890','XXXXXXXXXX'), to_number(c.value)-to_number(substr(s.value,3))+1, 0)), 1,'M ok (is set correctly >=)', decode(sign( decode(rpad('between ',length(s.value),'X'), replace(translate(s.value,'1234567890','XXXXXXXXXX'),' and ','XXXXX'), to_number(c.value)-to_number(substr(s.value,9,instr(s.value,' and ')-9))+1, 0))*sign( decode(rpad('between ',length(s.value),'X'), replace(translate(s.value,'1234567890','XXXXXXXXXX'),' and ','XXXXX'), to_number(substr(s.value,instr(s.value,' and ')+5))-to_number(c.value)+1, 0)), 1,'N ok (is set correctly between)','D change value to "'||s.value||'"')))))), decode( decode(substr(c.name,1,4),'nls_',0,1)+ instr(',nls_length_semantics,nls_nchar_conv_excp,',','||c.name||','), 0,'R ok (ignored dynamically changed parameter)','A parameter was dynamically changed; no reliable recommendation can be given'))) order_recommendation, decode(substr(c.name,1,3), '***',' ', decode(c.isdefault, 'TRUE','N', 'Y')) "SET", c.value is_value, decode(substr(s.value,1,5), '-man-',substr(s.value,6), '-aut-',substr(s.value,6), '-any-','any value', '-del-','deleted '||chr(102)||'rom parameter file', s.value) should_be_value, s."comment" remark, s.flags from ( select inst_id, name, subname, value, "comment", flags, hide, x_mergefix, x_bugno, x_mergefix_released, x_cluster_database, x_asm_used, x_exadata_used, x_abap_stack, x_olap, x_version, x_startup, x_platform_name, x_event_contains_colon, x_fix_control_reliable, x_db_name from ( select o.inst_id, lower(decode(instr(o.n,','),0,o.n,substr(o.n,1,instr(o.n,',')-1))) name, lower(decode(instr(o.n,','),0,' ',substr(o.n,instr(o.n,',')+1))) subname, replace(decode(o.n, 'DB_FILES','>='||to_char(round(x_datafile_count.value*1.1)), 'PARALLEL_MAX_SERVERS',decode(x_parameter.cpu_count*10-x_parameter.para_max, 0,'-aut-'||substr(o.w,6),o.w), 'PGA_AGGREGATE_TARGET',decode(sign(round(x_pgastat.MAX_since_start/(x_pgastat.limit_value+1)*100)-90), -1,decode(sign(round(x_pgastat.MAX_since_start/(x_pgastat.limit_value+1)*100)-75), 1,'-aut-'||substr(o.w,6), o.w), o.w), 'PROCESSES',decode(sign(round(x_rl.MAX_UTILIZATION/(x_rl.limit_value+1)*100)-75), -1,'-aut-'||substr(o.w,6),o.w), 'SESSIONS',decode(sign(round(x_rl.MAX_UTILIZATION/(x_rl.limit_value+1)*100)-75), -1,'-aut-'||substr(o.w,6),o.w), 'SHARED_POOL_SIZE',decode(x_parameter.sga_target, 0,decode(sign(x_parameter.shared_pool_size_mb-0.5*x_parameter.calculated_shared_pool_size_mb), -1,'-man-'||o.w, decode(sign(x_parameter.shared_pool_size_mb-2*x_parameter.calculated_shared_pool_size_mb), 1,'-man-'||o.w, '-aut-'||o.w)), '-man-'||o.w), 'UNDO_RETENTION',decode(x_undostat.max_stolen, 0,'-aut-'||substr(o.w,6),o.w), o.w),'[SID]',x_database.name) value, o.p flags, decode(o.n, 'PARALLEL_MAX_SERVERS','Max used (gv$resource_limit): '||x_rl.MAX_UTILIZATION ||' ('||round(x_rl.MAX_UTILIZATION/(x_parameter.para_max+1)*100) ||'%); ' ||replace(o.c,'[CPU_COUNT]',to_char(x_parameter.cpu_count)), 'PGA_AGGREGATE_TARGET','Max used MB (gv$pgastat): '||round(x_pgastat.MAX_since_start/1024/1024) ||' ('||round(x_pgastat.MAX_since_start/(x_pgastat.limit_value+1)*100) ||'%) ', 'PROCESSES','Max used (gv$resource_limit): '||x_rl.MAX_UTILIZATION ||' ('||round(x_rl.MAX_UTILIZATION/(x_rl.limit_value+1)*100) ||'%)', 'SESSIONS','Max used (gv$resource_limit): '||x_rl.MAX_UTILIZATION ||' ('||round(x_rl.MAX_UTILIZATION/(x_rl.limit_value+1)*100) ||'%); ' ||replace(o.c,'[PROCESSES]',to_char(x_parameter.processes)), 'SHARED_POOL_SIZE',decode(x_parameter.sga_target, 0,'current: '||round(x_parameter.shared_pool_size_mb)|| ' MB; calculated: '||round(x_parameter.calculated_shared_pool_size_mb)||' MB', 'ASMM is used (sga_target>0)'), 'UNDO_RETENTION','Max unexpired stolen blocks (gv$undostat): '||x_undostat.max_stolen, o.c) "comment", decode(instr(lower(o.n),'_fix_control'),0,'FALSE',decode(x_fix_control.bugno,null,'TRUE','FALSE')) hide, x_mergefix.mergefix_at_least x_mergefix, x_mergefix.bugno x_bugno, x_mergefix.mergefix_released x_mergefix_released, x_parameter.cluster_database x_cluster_database, x_feature_used.asm_used x_asm_used, x_feature_used.exadata_used x_exadata_used, x_abap_stack.abap_stack x_abap_stack, x_olap.olap x_olap, o.version x_version, o.startup_time x_startup, x_database.platform_name x_platform_name, x_event.contains_colon x_event_contains_colon, x_fix_control_reliable.reliable x_fix_control_reliable, x_database.name x_db_name from ( select i.inst_id inst_id, i.startup_time, i.version, n,w,c,p, decode(instr(' '||r,'PS['),0,'', substr(r,instr(r,'PS[')+3,instr(r,']', instr(r,'PS['))-instr(r,'PS[')-3)) r_ps, decode(instr(' '||r,'MF['),0,'', substr(r,instr(r,'MF[')+3,instr(r,']', instr(r,'MF['))-instr(r,'MF[')-3)) r_mf, decode(instr(' '||r,'BW['),0,'', substr(r,instr(r,'BW[')+3,instr(r,']', instr(r,'BW['))-instr(r,'BW[')-3)) r_bw, decode(instr(' '||r,'RAC['),0,'', substr(r,instr(r,'RAC[')+4,instr(r,']', instr(r,'RAC['))-instr(r,'RAC[')-4)) r_rac, decode(instr(' '||r,'ABAP['),0,'', substr(r,instr(r,'ABAP[')+5,instr(r,']', instr(r,'ABAP['))-instr(r,'ABAP[')-5)) r_abap, decode(instr(' '||r,'OS['),0,'', substr(r,instr(r,'OS[')+3,instr(r,']', instr(r,'OS['))-instr(r,'OS[')-3)) r_os, decode(instr(' '||r,'OSF['),0,'', substr(r,instr(r,'OSF[')+4,instr(r,']', instr(r,'OSF['))-instr(r,'OSF[')-4)) r_osf, decode(instr(' '||r,'ASM['),0,'', substr(r,instr(r,'ASM[')+4,instr(r,']', instr(r,'ASM['))-instr(r,'ASM[')-4)) r_asm, decode(instr(' '||r,'EXADATA['),0,'', substr(r,instr(r,'EXADATA[')+8,instr(r,']', instr(r,'EXADATA['))-instr(r,'EXADATA[')-8)) r_exadata from ( select'*** INFORMATION '||lpad(rownum,2)||' ***' n, '' w, '' r, '' p, '' c from gv$parameter2 where rownum < 12 union (select substr(val,instr(val,'#',1,r-4)+1,instr(val,'#',1,r-3)-instr(val,'#',1,r-4)-1) n, substr(val,instr(val,'#',1,r-3)+1,instr(val,'#',1,r-2)-instr(val,'#',1,r-3)-1) w, substr(val,instr(val,'#',1,r-2)+1,instr(val,'#',1,r-1)-instr(val,'#',1,r-2)-1) r, substr(val,instr(val,'#',1,r-1)+1,instr(val,'#',1,r-0)-instr(val,'#',1,r-1)-1) p, substr(val,instr(val,'#',1,r-0)+1,instr(val,'#',1,r+1)-instr(val,'#',1,r-0)-1) cfrom( select val from ( select '###PS[0]###' val from dual union all ( select '#'||'_AWR_MMON_DEEP_PURGE_ALL_EXPIRED#TRUE#PS[4]###'||'_B_TREE_BITMAP_PLANS#FALSE#PS[1], OSF[UNIX], MF[0-1]#2p#' ||'avoid bitmap operations when using B*TREE indexes#'||'_B_TREE_BITMAP_PLANS#-man-set to FALSE if SBP date=14#' ||'PS[3], OSF[WINDOWS]#2p#' ||'avoid high CPU consumption for Mutex requests#'||'_FIRST_SPARE_PARAMETER#1#PS[2], OSF[UNIX], MF[1-2]#2p#' ||'avoid high CPU consumption for Mutex requests#'||'_FIX_CONTROL,4728348#4728348:OFF#PS[1], OSF[UNIX], MF[0-1]#1f#' ||'avoid wrong values; note 1547676#'||'_FIX_CONTROL,4728348#-man-set to 4728348:OFF if SBP date=25#' ||'PS[2], OSF[WINDOWS]#2p#' ||'statistic collection during index creation#'||'_FIX_CONTROL,14595273#14595273:ON#PS[34]#2p##'||'_FIX_CONTROL,14764840#14764840:OFF#PS[4], EXADATA[TRUE]###'||'_FIX_CONTROL,16015637#16015637:OFF#PS[4], EXADATA[TRUE]###'||'_FIX_CONTROL,16825679#16825679:ON#PS[4], EXADATA[TRUE]###'||'_FIX_CONTROL,17736165#17736165:OFF#PS[4], EXADATA[TRUE]###'||'_FIX_CONTROL,17799716#17799716:OFF#PS[4], EXADATA[TRUE]###'||'_FIX_CONTROL,18115594#18115594:OFF#PS[4], EXADATA[TRUE]###'||'_FIX_CONTROL,18134680#18134680:OFF#PS[4], EXADATA[TRUE]###'||'_FIX_CONTROL,18304693#18304693:OFF#PS[4], EXADATA[TRUE]###'||'_FIX_CONTROL,18365267#18365267:OFF#PS[4], EXADATA[TRUE]###'||'_FIX_CONTROL,18405517#18405517:2#PS[34]#2p##'||'_FIX_CONTROL,18798414#18798414:OFF#PS[4], EXADATA[TRUE]###'||'_GC_OVERRIDE_FORCE_CR#FALSE#' ||'PS [3], OSF[UNIX], MF[14-14], RAC[TRUE]#1f#' ||'can lead to outage of DB (note 2048023)#'||'_GC_OVERRIDE_FORCE_CR#-man-set to FALSE if SBP date >=201402#' ||'PS [3], OSF[UNIX], MF[13-13], RAC[TRUE]#1f#' ||'can lead to outage of DB (note 2048023)#'val from dual ) union all ( select '#'||'_GC_OVERRIDE_FORCE_CR#-man-set to FALSE if 28 =201305 is installed#' ||'PS[3], OSF[UNIX], MF[9-9], EXADATA[FALSE]#1f#' ||'avoid ora-60 deadlocks (note 1847870)#'||'EVENT,10198#10198#PS[3], OSF[UNIX], MF[10-99]#1f#' ||'avoid ora-60 deadlocks (note 1847870)#'||'EVENT,10198#10198#PS[2], OSF[UNIX], MF[14-99], EXADATA[FALSE]#1f#' ||'avoid ora-60 deadlocks (note 1847870)#'||'EVENT,10198#-man-set if SXD>=201306 is installed#' ||'PS[2], OSF[UNIX], MF[14-14], EXADATA[TRUE]#1f#' ||'avoid ora-60 deadlocks (note 1847870)#'||'EVENT,10198#10198#PS[2], OSF[UNIX], MF[15-99], EXADATA[TRUE]#1f#' ||'avoid ora-60 deadlocks (note 1847870)#'val from dual ) union all ( select '#'||'EVENT,10198#-man-set if Winbundle>=20#' ||'PS[3], OSF[WINDOWS], EXADATA[FALSE]#1f#' ||'avoid ora-60 deadlocks (note 1847870)#'||'EVENT,10995#10995 level 2##2f#' ||'avoid flush shared pool during online reorg#'||'EVENT,31991#31991#OSF[UNIX], PS[4]#2p#' ||'avoid too many recursive calls#'||'EVENT,31991#31991#OSF[UNIX], PS[3], MF[5-99]#2p#' ||'avoid too many recursive calls#'||'EVENT,31991#31991#OSF[UNIX], PS[2], MF[11-99]#2p#' ||'avoid too many recursive calls#'||'EVENT,31991#-man-set if SBP>=201207 is installed#' ||'OSF[UNIX], PS[2], MF[10-10]#2p#avoid too many recursive calls#'||'EVENT,31991#-man-set if Winbundle>=20#OSF[WINDOWS], PS[2]#2p#' ||'avoid too many recursive calls#'||'EVENT,31991#-man-set if Winbundle>=8#OSF[WINDOWS], PS[3]#2p#' ||'avoid too many recursive calls#'||'EVENT,31991#-man-set if Winbundle>=2#OSF[WINDOWS], PS[4]#2p#' ||'avoid too many recursive calls#'||'EVENT,38068#38068 level 100##2p#' ||'long raw statistic; implement note 948197#'||'EVENT,38085#38085##2p#' ||'consider cost adjust for index fast full scan#'||'EVENT,38087#38087##1f#avoid ora-600 at star transformation#'||'EVENT,44951#44951 level 1024##2p#' ||'avoid HW enqueues during LOB inserts#'||'FILESYSTEMIO_OPTIONS#SETALL##1p#note 793113#'||'HPUX_SCHED_NOAGE#178#RAC[FALSE]#2p#performance#'||'LOCAL_LISTENER#' ||'-man-set to (ADDRESS = (PROTOCOL=TCP) (HOST=[hostname]>) (PORT=[port]))#' ||'RAC[FALSE]###'||'LOG_ARCHIVE_DEST_1#LOCATION=+[DGNAME]/[SID]/ORAARCH#' ||'ASM[TRUE], RAC [TRUE]###'||'LOG_ARCHIVE_DEST_1#LOCATION=+ARCH#ASM[TRUE], RAC[FALSE]###'||'LOG_ARCHIVE_DEST_1#LOCATION=/oracle/[SID]/oraarch/[SID]arch#' ||'OSF[UNIX], ASM[FALSE]##note 966073#'||'LOG_ARCHIVE_DEST_1#' ||'LOCATION=[drive]:\oracle\[SID]\oraarch\[SID]arch#' ||'OSF[WINDOWS], ASM[FALSE]##note 966073#'val from dual ) union all ( select '#'||'LOG_ARCHIVE_FORMAT#%t_%s_%r.dbf####'||'LOG_BUFFER#-del-#ASM[TRUE], EXADATA[FALSE]###'||'LOG_BUFFER#-man-depends on number of CPUs; details in note 1627481#' ||'ASM[FALSE], EXADATA[FALSE]##CPU_COUNT=[CPU_COUNT]#'||'LOG_BUFFER#-man-set to at least 128MB; details in note 1627481#' ||'EXADATA[TRUE]##CPU_COUNT=[CPU_COUNT]#'||'LOG_CHECKPOINTS_TO_ALERT#TRUE####'||'MAX_DUMP_FILE_SIZE#20000####'||'NLS_LENGTH_SEMANTICS#-del-##2f##'||'OPEN_CURSORS#between 800 and 2000####'||'OPTIMIZER_DYNAMIC_SAMPLING#-del-#BW[FALSE]#1p##'||'OPTIMIZER_DYNAMIC_SAMPLING#6#BW[TRUE]#1p##'||'OPTIMIZER_DYNAMIC_SAMPLING#-man-OLTP: do not set; OLAP: 6#' ||'BW[UNKNOWN]#1p##'||'OPTIMIZER_FEATURES_ENABLE#-del-##1p##'||'OPTIMIZER_INDEX_CACHING#-del-##2p#' ||'est. % of index cached (inlist, nested loop)#'||'OPTIMIZER_INDEX_COST_ADJ#20#BW[FALSE]#1p##'||'OPTIMIZER_INDEX_COST_ADJ#-del-#BW[TRUE]#1p##'||'OPTIMIZER_INDEX_COST_ADJ#-man-OLTP: 20; OLAP: do not set#' ||'BW[UNKNOWN]###'||'OPTIMIZER_MODE#-del-##1p##'||'PARALLEL_EXECUTION_MESSAGE_SIZE#16384##2p##'||'PARALLEL_MAX_SERVERS#-man-Number of DB machine CPU CORES*10###' ||'CPU_COUNT=[CPU_COUNT]#'||'PARALLEL_THREADS_PER_CPU#1##2p##'||'PGA_AGGREGATE_TARGET#-man-appropriately set####'||'PROCESSES#-man-formula how to set in parameter note###' ||'dependent: SESSIONS#'||'QUERY_REWRITE_ENABLED#FALSE##2p##'||'RECYCLEBIN#OFF##1f##'||'REMOTE_OS_AUTHENT#' ||'-man-set to TRUE on systems with a Unix App. Server without SSFS (note 1622837)#' ||'ABAP[TRUE]###'||'REMOTE_OS_AUTHENT#-del-#ABAP[FALSE]###'||'REPLICATION_DEPENDENCY_TRACKING#-any-####'||'SESSIONS#-man-2*PROCESSES###PROCESSES=[PROCESSES]#'||'SHARED_POOL_SIZE#appropriately set; note 690241####'||'STAR_TRANSFORMATION_ENABLED#TRUE#PS[2], OSF[UNIX], MF[6-99]#1p##'val from dual ) union all ( select '#'||'STAR_TRANSFORMATION_ENABLED#-man-set to TRUE if Winbundle>=12#' ||'PS[2], OSF[WINDOWS]#1p##'||'STAR_TRANSFORMATION_ENABLED#TRUE#PS[3], OSF[UNIX], MF[1-99]#1p##'||'STAR_TRANSFORMATION_ENABLED#-man-set to TRUE if Winbundle>=1#' ||'PS[3], OSF[WINDOWS]#1p##'||'STAR_TRANSFORMATION_ENABLED#TRUE#PS[4]#1p##'||'UNDO_RETENTION#-man-appropriately set####'||'UNDO_TABLESPACE#PSAPUNDO#RAC[FALSE]###'||'UNDO_TABLESPACE#-man-appropriately set#RAC[TRUE]###'||'USE_LARGE_PAGES#-man-can be set according to note 1672954#' ||'OS[Linux IA (64-bit),Linux x86 64-bit],PS[2345]###'||'USER_DUMP_DEST#-del-####'val from dual ) )),( select rownum*5 r from v$parameter2 where rownum 0)x_event where o.inst_id = x_rl.inst_id(+) and o.n = x_rl.RESOURCE_NAME(+) and o.inst_id = x_pgastat.inst_id(+) and o.inst_id = x_parameter.inst_id and o.inst_id = x_undostat.inst_id(+) and (o.r_mf is null or x_mergefix.mergefix_at_least between to_number(substr(o.r_mf,1,instr(o.r_mf,'-')-1)) and to_number(substr(o.r_mf,instr(o.r_mf,'-')+1))) and lower(decode(instr(o.n,','),0,' ',substr(o.n,instr(o.n,',')+1)))= to_char(x_fix_control.bugno(+)) and decode(x_fix_control.bugno(+), null, decode(instr(lower(o.n),'_fix_control'), 0,'OK', 'HIDE'), 'OK')='OK' and (o.r_osf is null or instr(o.r_osf, x_os_family.os_family)>0) and (o.r_os is null or instr(o.r_os, x_database.platform_name)>0) and (o.r_rac is null or o.r_rac = x_parameter.cluster_database) and (o.r_asm is null or o.r_asm = x_feature_used.asm_used) and (o.r_exadata is null or o.r_exadata = x_feature_used.exadata_used) and (o.r_abap is null or o.r_abap = x_abap_stack.abap_stack) and (o.r_bw is null or o.r_bw = x_olap.olap ) and (o.r_ps is null or instr(o.r_ps,decode(substr(o.version,1,7), '11.2.0.',substr(o.version,8,1),'?'))>0) ) where hide='FALSE' ) s, ( select inst_id, name, subname, trim(substr(max(sort_string),1,5)) isdefault, substr(max(sort_string),6)|| decode(count(*),1,'', decode(name,'event','', decode(substr(name,1,1),'_','', ', ...'))) value, max(ismodified) ismodified from ( select inst_id, lower(name) name, ' ' subname, concat(lpad(isdefault,5),value) sort_string, ismodified from gv$parameter2 where name not in ('event','_fix_control') union ( select a.inst_id, a.name, substr(trim(translate(value, chr(10)||chr(13)||chr(9),' ')),1,decode(a.name,'event',5,instr(trim(value),':')-1)) subname, concat('FALSE',trim(translate(value, chr(10)||chr(13)||chr(9),' '))) sort_string, a.ismodified from ( select vparam.inst_id, vparam.name, substr(decode(vparam.name,'event',':',',')||vparam.value, instr(decode(vparam.name,'event',':',',')||vparam.value,decode(vparam.name,'event',':',','),1,vcnt.cnt)+1, decode(instr(decode(vparam.name,'event',':',',')||vparam.value,decode(vparam.name,'event',':',','),1,vcnt.cnt+1), 0,length(decode(vparam.name,'event',':',',')||vparam.value), instr(decode(vparam.name,'event',':',',')||vparam.value,decode(vparam.name,'event',':',','),1,vcnt.cnt+1)-1)- decode(instr(decode(vparam.name,'event',':',',')||vparam.value,decode(vparam.name,'event',':',','),1,vcnt.cnt), 0,length(decode(vparam.name,'event',':',',')||vparam.value), instr(decode(vparam.name,'event',':',',')||vparam.value,decode(vparam.name,'event',':',','),1,vcnt.cnt))) value, vparam.ismodified from gv$parameter2 vparam, (select rownum cnt from gv$parameter2 where rownum