기본 콘텐츠로 건너뛰기

라벨이 hidden parameter인 게시물 표시

oracle hidden parameter 조회

col KSPPINM format a50 col KSPPSTVL format a10 col KSPPDESC format a100 SELECT  A.KSPPINM, B.KSPPSTVL, A.KSPPDESC FROM    X$KSPPI  A       , X$KSPPSV  B WHERE   SUBSTR(A.KSPPINM,1,1) = '_' AND     A.INDX = B.INDX AND     A.KSPPINM IN        (         '_PX_use_large_pool'       , '_b_tree_bitmap_plans'       , '_db_file_exec_read_count'       , '_db_file_optimizer_read_count'       , '_index_partition_large_extents'       , '_memory_imm_mode_without_autosga'       , '_object_statistics'       , '_optim_peek_user_binds'       , '_optimizer_adaptive_cursor_sharing'       , '_optimizer_join_factorization'       , '_optimizer_use_feedback'       , '_partition_large_extents'       , '_quer...