Oracle Parameters

EXEM Knowledge Base

Jump to: navigation, 찾기

[편집] Parameters

  1. ARCHIVE_LAG_TARGET
  2. BACKGROUND_DUMP_DEST
  3. COMMIT_WRITE
  4. CORE_DUMP_DEST
  5. CREATE_BITMAP_AREA_SIZE
  6. CREATE_STORED_OUTLINES
  7. CURSOR_SHARING
  8. CURSOR_SPACE_FOR_TIME
  9. DB_2K_CACHE_SIZE
  10. DB_4K_CACHE_SIZE
  11. DB_8K_CACHE_SIZE
  12. DB_16K_CACHE_SIZE
  13. DB_32K_CACHE_SIZE
  14. DB_BLOCK_CHECKSUM
  15. DB_BLOCK_SIZE
  16. DB_CACHE_ADVICE
  17. DB_CACHE_SIZE
  18. DB_CREATE_FILE_DEST
  19. DB_FILE_MULTIBLOCK_READ_COUNT
  20. DB_FLASHBACK_RETENTION_TARGET
  21. DB_KEEP_CACHE_SIZE
  22. DB_WRITER_PROCESSES
  23. DBWR_IO_SLAVES
  24. DDL_WAIT_FOR_LOCKS
  25. DISK_ASYNCH_IO
  26. EVENT
  27. FILESYSTEM_IO_OPTIONS
  28. GCS_SERVER_PROCESSES
  29. HASH_AREA_SIZE
  30. INSTANCE_GROUPS
  31. JAVA_SOFT_SESSIONSPACE_LIMIT
  32. JOB_QUEUE_PROCESSES
  33. LARGE_POOL_SIZE
  34. LOCK_SGA
  35. LOG_BUFFER
  36. LOG_CHECKPOINT_INTERVAL
  37. LOG_CHECKPOINT_TIMEOUT
  38. MAX_COMMIT_PROPAGATION_DELAY
  39. MAX_DUMP_FILE_SIZE
  40. O7_DICTIONARY_ACCESSIBILITY
  41. OPEN_CURSORS
  42. OPTIMIZER_DYNAMIC_SAMPLING
  43. OPTIMIZER_FEATURES_ENABLE
  44. OPTIMIZER_INDEX_CACHING
  45. OPTIMIZER_INDEX_COST_ADJ
  46. OPTIMIZER_MODE
  47. PARALLEL_ADAPTIVE_MULTI_USER
  48. PARALLEL_AUTOMATIC_TUNING
  49. PARALLEL_EXECUTION_MESSAGE_SIZE
  50. PARALLEL_INSTANCE_GROUP
  51. PARALLEL_MAX_SERVERS
  52. PARALLEL_MIN_SERVERS
  53. PGA_AGGREGATE_TARGET
  54. QUERY_REWRITE_ENABLED
  55. QUERY_REWRITE_INTEGRITY
  56. RECYCLEBIN
  57. ROLLBACK_SEGMENTS
  58. SESSION_CACHED_CURSORS
  59. SGA_MAX_SIZE
  60. SGA_TARGET
  61. SHARED_POOL_SIZE
  62. SHARED_POOL_RESERVED_SIZE
  63. SORT_AREA_SIZE
  64. SORT_AREA_RETAINED_SIZE
  65. SPFILE
  66. SQL_TRACE
  67. STATISTICS_LEVEL
  68. STREAMS_POOL_SIZE
  69. TIMED_OS_STATISTICS
  70. TIMED_STATISTICS
  71. UNDO_MANAGEMENT
  72. UNDO_RETENTION
  73. UNDO_TABLESPACE
  74. USER_DUMP_DEST
  75. UTL_FILE_DIR
  76. WORKAREA_SIZE_POLICY

[편집] Hidden Parameters

  1. _ADDM_AUTO_ENABLE
  2. _ALWAYS_ANTI_JOIN
  3. _ALWAYS_SEMI_JOIN
  4. _ASH_DISK_FILTER_RATIO
  5. _ASH_DISK_WRITE_ENABLE
  6. _ASH_ENABLE
  7. _ASH_SAMPLING_INTERVAL
  8. _ASSM_DEFAULT
  9. _B_TREE_BITMAP_PLANS
  10. _BUFFER_BUSY_WAIT_TIMEOUT
  11. _BUMP_HIGHWATER_MARK_COUNT
  12. _COMPLEX_VIEW_MERGING
  13. _DB_FILE_EXEC_READ_COUNT
  14. _DB_FILE_OPTIMIZER_READ_COUNT
  15. _DISABLE_LOGGING
  16. _GC_AFFINITY_LIMIT
  17. _GC_AFFINITY_MINIMUM
  18. _GC_AFFINITY_TIME
  19. _HASH_JOIN_ENABLED
  20. _IN_MEMORY_UNDO
  21. _OPTIM_PEEK_USER_BINDS
  22. _OPTIMIZER_AUTOSTATS_JOB
  23. _OPTIMIZER_COMPUTE_INDEX_STATS
  24. _OPTIMIZER_COST_BASED_TRANSFORMATION
  25. _OPTIMIZER_IGNORE_HINTS
  26. _OPTIMIZER_MAX_PERMUTATIONS
  27. _OPTIMIZER_PUSH_PRED_COST_BASED
  28. _OPTIMIZER_SKIP_SCAN_ENABLED
  29. _OPTIMIZER_SORTMERGE_JOIN_ENABLED
  30. _OS_SCHED_HIGH_PRIORITY
  31. _PUSH_JOIN_PREDICATE
  32. _SESSION_WAIT_HISTORY
  33. _SMM_MAX_SIZE
  34. _SMM_MIN_SIZE
  35. _SMM_PX_MAX_SIZE
  36. _SPIN_COUNT
  37. _TRACE_FILES_PUBLIC
  38. _UNDO_AUTOTUNE
  39. _UNNEST_SUBQUERY
  40. _USE_ISM
  41. _USE_ISM_FOR_PGA
  42. _USE_REALFREE_HEAP
  43. _WAIT_FOR_SYNC

[편집] Template

  1. _Oracle_Parameter_Template
원본 주소 ‘http://wiki.ex-em.com/index.php/Oracle_Parameters’