Hidden Parameter 조회

조회

-

SELECT 
	i.KSPPINM 
	, v.ksppstvl "current value"
	, v.ksppstdf "default value"
from x$ksppi i join x$ksppcv v
on i.indx = v.indx;

-- 결과
KSPPINM                        current value                  default v
------------------------------ ------------------------------ ---------
_swrf_test_dbfus               FALSE                          TRUE
_mwin_schedule                 TRUE                           TRUE
_awr_sql_child_limit           200                            TRUE
sqltune_category               DEFAULT                        TRUE
_sqltune_category_parsed       DEFAULT                        TRUE
_ash_sampling_interval         1000                           TRUE
_ash_size                      1048618                        TRUE
_ash_enable                    TRUE                           TRUE
_ash_disk_write_enable         TRUE                           TRUE
_ash_disk_filter_ratio         10                             TRUE
_ash_eflush_trigger            66                             TRUE
_ash_sample_all                FALSE                          TRUE
_ash_dummy_test_param          0                              TRUE
_threshold_alerts_enable       1                              TRUE
_addm_auto_enable              TRUE                           TRUE
_addm_version_check            TRUE                           TRUE
_addm_skiprules                                               TRUE

1385 rows selected.

-






&