내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 7.6, Oracle Linux 8.4 (64bit)
DB 환경 : Oracle Database 19.3.0.0, 23.4.0.24.05 ai Free
방법 : 오라클 19c, 23ai oradebug dumplist 확인
오라클 sqlplus 에서 아래 명령어 입력시 오라클에서 사용 가능한 모든 덤프작업을 확인할 수 있음
19c와 23ai 버전에서 각각 실행해보았음
23ai에서 몇개가 더 추가되었지만 정확히 어떤 역할을 하는 덤프들인지는 모름
| 19c | 23ai |
| SQL> oradebug dumplist | SQL> oradebug dumplist |
| ADJUST_SCN | ADJUST_SCN |
| ALRT_TEST | ALRT_TEST |
| ARCHIVE_ERROR | ARCHIVE_ERROR |
| ASHDUMP | ASHDUMP |
| ASHDUMPSECONDS | ASHDUMPSECONDS |
| ASMDISK_ERR_OFF | ASMDISK_ERR_OFF |
| ASMDISK_ERR_ON | ASMDISK_ERR_ON |
| ASMDISK_READ_ERR_ON | ASMDISK_READ_ERR_ON |
| ATSK_TEST | ATSK_TEST |
| AWR_DEBUG_FLUSH_TABLE_OFF | AWR_DEBUG_FLUSH_TABLE_OFF |
| AWR_DEBUG_FLUSH_TABLE_ON | AWR_DEBUG_FLUSH_TABLE_ON |
| AWR_FLUSH_TABLE_OFF | AWR_FLUSH_TABLE_OFF |
| AWR_FLUSH_TABLE_ON | AWR_FLUSH_TABLE_ON |
| AWR_TEST | AWR_TEST |
| BC_SANITY_CHECK | BC_SANITY_CHECK |
| BGINFO | BGINFO |
| BG_MESSAGES | BG_MESSAGES |
| BLK0_FMTCHG | BLK0_FMTCHG |
| BUFFER | BUFFER |
| BUFFERS | BUFFERS |
| CALLSTACK | CALLSTACK |
| CBDB_ENTRIES | CBDB_ENTRIES |
| CGS | CGS |
| CHECK_ROREUSE_SANITY | CHECK_ROREUSE_SANITY |
| CONTEXTAREA | CONTEXTAREA |
| CONTROLF | CONTROLF |
| CROSSIC | CROSSIC |
| CRS | CRS |
| CSS | CSS |
| CURSORDUMP | CURSORDUMP |
| CURSORTRACE | CURSORTRACE |
| CURSOR_STATS | CURSOR_STATS |
| DATA_ERR_OFF | DATA_ERR_OFF |
| DATA_ERR_ON | DATA_ERR_ON |
| DATA_READ_ERR_ON | DATA_READ_ERR_ON |
| DBSCHEDULER | DBSCHEDULER |
| DEAD_CLEANUP_STATE | DEAD_CLEANUP_STATE |
| DOUBLE_BUCKETS | |
| DROP_SEGMENTS | DROP_SEGMENTS |
| DUMPGLOBALDATA | DUMPGLOBALDATA |
| DUMP_ADV_SNAPSHOTS | DUMP_ADV_SNAPSHOTS |
| DUMP_ALL_COMP_GRANULES | DUMP_ALL_COMP_GRANULES |
| DUMP_ALL_COMP_GRANULE_ADDRS | DUMP_ALL_COMP_GRANULE_ADDRS |
| DUMP_ALL_OBJSTATS | DUMP_ALL_OBJSTATS |
| DUMP_ALL_REQS | DUMP_ALL_REQS |
| DUMP_KTTE_FILE_CACHE | |
| DUMP_PINNED_BUFFER_HISTORY | DUMP_PINNED_BUFFER_HISTORY |
| DUMP_SGA_METADATA | DUMP_SGA_METADATA |
| DUMP_TEMP | DUMP_TEMP |
| DUMP_TRANSFER_OPS | DUMP_TRANSFER_OPS |
| ENQUEUES | ENQUEUES |
| ERRORSTACK | ERRORSTACK |
| EVENT_TSM_TEST | EVENT_TSM_TEST |
| EXCEPTION_DUMP | EXCEPTION_DUMP |
| FAILOVER | FAILOVER |
| FBHDR | FBHDR |
| FBINC | FBINC |
| FBTAIL | FBTAIL |
| FILE_HDRS | FILE_HDRS |
| FLASHBACK_GEN | FLASHBACK_GEN |
| FLUSH_BUFFER | FLUSH_BUFFER |
| FLUSH_CACHE | FLUSH_CACHE |
| FLUSH_JAVA_POOL | FLUSH_JAVA_POOL |
| FLUSH_OBJECT | FLUSH_OBJECT |
| FULL_DUMPS | FULL_DUMPS |
| GC_ELEMENTS | GC_ELEMENTS |
| GES_STATE | GES_STATE |
| GIPC | GIPC |
| GLOBAL_AREA | GLOBAL_AREA |
| GLOBAL_BUFFER_DUMP | GLOBAL_BUFFER_DUMP |
| GWM_TEST | GWM_TEST |
| GWM_TRACE | GWM_TRACE |
| HALVE_BUCKETS | |
| HANGANALYZE | HANGANALYZE |
| HANGANALYZE_BLOCKER_CHAINS | |
| HANGANALYZE_FINAL_BLOCKER | |
| HANGANALYZE_GLOBAL | HANGANALYZE_GLOBAL |
| HANGANALYZE_PROC | HANGANALYZE_PROC |
| HANGDIAG_HEADER | HANGDIAG_HEADER |
| HEAPDUMP | HEAPDUMP |
| HEAPDUMP_ADDR | HEAPDUMP_ADDR |
| HEAP_RESERVED | |
| HM_FDG_VERS | HM_FDG_VERS |
| HM_FW_TRACE | HM_FW_TRACE |
| HNGDET_MEM_USAGE_DUMP | HNGDET_MEM_USAGE_DUMP |
| IMDB_PINNED_BUFFER_HISTORY | IMDB_PINNED_BUFFER_HISTORY |
| INSTANTIATIONSTATE | INSTANTIATIONSTATE |
| IOERREMUL | IOERREMUL |
| IOERREMULRNG | IOERREMULRNG |
| IR_FW_TRACE | IR_FW_TRACE |
| JAVAINFO | JAVAINFO |
| KBRS_TRACE | KBRS_TRACE |
| KCBI_DUMP_FREELIST | KCBI_DUMP_FREELIST |
| KCBO_OBJ_CHECK_DUMP | KCBO_OBJ_CHECK_DUMP |
| KCBS_ADV_INT_DUMP | KCBS_ADV_INT_DUMP |
| KCB_WORKING_SET_DUMP | KCB_WORKING_SET_DUMP |
| KDFSDMP | KDFSDMP |
| KDLIDMP | KDLIDMP |
| KRA_OPTIONS | KRA_OPTIONS |
| KRBMROR_LIMIT | KRBMROR_LIMIT |
| KRBMRSR_LIMIT | KRBMRSR_LIMIT |
| KRB_BSET_DAYS | KRB_BSET_DAYS |
| KRB_CORRUPT_INTERVAL | KRB_CORRUPT_INTERVAL |
| KRB_CORRUPT_OFFSET | KRB_CORRUPT_OFFSET |
| KRB_CORRUPT_REPEAT | KRB_CORRUPT_REPEAT |
| KRB_CORRUPT_SIZE | KRB_CORRUPT_SIZE |
| KRB_CORRUPT_SPBAD_INTERVAL | KRB_CORRUPT_SPBAD_INTERVAL |
| KRB_CORRUPT_SPBAD_SIGNAL | KRB_CORRUPT_SPBAD_SIGNAL |
| KRB_CORRUPT_SPBITMAP_INTERVAL | KRB_CORRUPT_SPBITMAP_INTERVAL |
| KRB_CORRUPT_SPBITMAP_REPEAT | KRB_CORRUPT_SPBITMAP_REPEAT |
| KRB_CORRUPT_SPHEADER_INTERVAL | KRB_CORRUPT_SPHEADER_INTERVAL |
| KRB_CORRUPT_SPHEADER_REPEAT | KRB_CORRUPT_SPHEADER_REPEAT |
| KRB_FAIL_INPUT_FILENO | KRB_FAIL_INPUT_FILENO |
| KRB_OPTIONS | KRB_OPTIONS |
| KRB_OPTIONS2 | KRB_OPTIONS2 |
| KRB_OVERWRITE_ACTION | KRB_OVERWRITE_ACTION |
| KRB_PIECE_FAIL | KRB_PIECE_FAIL |
| KRB_SET_TIME_SWITCH | KRB_SET_TIME_SWITCH |
| KRB_SIMULATE_NODE_AFFINITY | KRB_SIMULATE_NODE_AFFINITY |
| KRB_UNUSED_OPTION | KRB_UNUSED_OPTION |
| KRC_TRACE_DUMP | |
| KRDRSBF | KRDRSBF |
| KSBDUMPCIC | |
| KSDTRADV_TEST | KSDTRADV_TEST |
| KSFQP_LIMIT | KSFQP_LIMIT |
| KSKDMPWAITINFO | |
| KSKDUMPTRACE | KSKDUMPTRACE |
| KSTDUMPALLPROCS | KSTDUMPALLPROCS |
| KSTDUMPALLPROCS_CLUSTER | KSTDUMPALLPROCS_CLUSTER |
| KSTDUMPCURPROC | KSTDUMPCURPROC |
| KTPR_DEBUG | KTPR_DEBUG |
| KUPPLATCHTEST | KUPPLATCHTEST |
| KXFPBLATCHTEST | KXFPBLATCHTEST |
| KXFPCLEARSTATS | KXFPCLEARSTATS |
| KXFPDPA | |
| KXFPDUMPTRACE | KXFPDUMPTRACE |
| KXFRHASHMAP | KXFRHASHMAP |
| KXFXCURSORSTATE | KXFXCURSORSTATE |
| KXFXSLAVESTATE | KXFXSLAVESTATE |
| LATCHES | LATCHES |
| LDAP_KERNEL_DUMP | LDAP_KERNEL_DUMP |
| LDAP_USER_DUMP | LDAP_USER_DUMP |
| LIBRARY_CACHE | LIBRARY_CACHE |
| LIBRARY_CACHE_OBJECT | LIBRARY_CACHE_OBJECT |
| LOCKS | LOCKS |
| LOGERROR | LOGERROR |
| LOGHIST | |
| LONGF_CREATE | LONGF_CREATE |
| LREG_STATE | LREG_STATE |
| LRU_EFFORT_REPORT | |
| MGA | MGA |
| MGA_HEAP_SHARED_CTX | |
| MGA_HEAP_SHARED_HDL | |
| MMAN_ALLOC_MEMORY | MMAN_ALLOC_MEMORY |
| MMAN_CREATE_DEF_REQUEST | MMAN_CREATE_DEF_REQUEST |
| MMAN_CREATE_IMM_REQUEST | MMAN_CREATE_IMM_REQUEST |
| MMAN_IMM_REQUEST | MMAN_IMM_REQUEST |
| MMON_TEST | MMON_TEST |
| MODIFIED_PARAMETERS | MODIFIED_PARAMETERS |
| NEXT_SCN_WRAP | NEXT_SCN_WRAP |
| OBJECT_CACHE | OBJECT_CACHE |
| OCR | OCR |
| OLAP_DUMP | OLAP_DUMP |
| OPEN_FILES | OPEN_FILES |
| PDBSTATS | PDBSTATS |
| PGA_DETAIL_CANCEL | PGA_DETAIL_CANCEL |
| PGA_DETAIL_DUMP | PGA_DETAIL_DUMP |
| PGA_DETAIL_GET | PGA_DETAIL_GET |
| PGA_SUMMARY | PGA_SUMMARY |
| PIN_BLOCKS | PIN_BLOCKS |
| PIN_RANDOM_BLOCKS | PIN_RANDOM_BLOCKS |
| POKE_ADDRESS | POKE_ADDRESS |
| POKE_LENGTH | POKE_LENGTH |
| POKE_VALUE | POKE_VALUE |
| POKE_VALUE0 | POKE_VALUE0 |
| POOL_SIMULATOR | POOL_SIMULATOR |
| PROCESSSTATE | PROCESSSTATE |
| PXDBX | |
| PXDOWNGRADE_ANALYZE | PXDOWNGRADE_ANALYZE |
| RACDUMP | RACDUMP |
| REALFREEDUMP | REALFREEDUMP |
| RECORD_CALLSTACK | RECORD_CALLSTACK |
| RECOVERY | RECOVERY |
| REDOHDR | REDOHDR |
| REDOLOGS | REDOLOGS |
| REFRESH_OS_STATS | REFRESH_OS_STATS |
| ROW_CACHE | ROW_CACHE |
| RULESETDUMP | RULESETDUMP |
| RULESETDUMP_ADDR | RULESETDUMP_ADDR |
| SAVEPOINTS | SAVEPOINTS |
| SCN_AUTO_ROLLOVER_TS_OVERRIDE | SCN_AUTO_ROLLOVER_TS_OVERRIDE |
| SECUREFILE_SPU | |
| SELFTESTASM | SELFTESTASM |
| SELFTESTKSRRP | |
| SESSION_STATS_FREELIST | SESSION_STATS_FREELIST |
| SET_AFN | SET_AFN |
| SET_ISTEMPFILE | SET_ISTEMPFILE |
| SET_NBLOCKS | SET_NBLOCKS |
| SET_TSN_P1 | SET_TSN_P1 |
| SGA_SUMMARY | SGA_SUMMARY |
| SHARED_SERVER_STATE | SHARED_SERVER_STATE |
| SHORT_STACK | SHORT_STACK |
| SHORT_STACKS | |
| SIMULATE_EOV | SIMULATE_EOV |
| SLOCK_DUMP | SLOCK_DUMP |
| SQLNET_SERVER_TRACE | SQLNET_SERVER_TRACE |
| STATE_OBJECT_DELETION_TIME | STATE_OBJECT_DELETION_TIME |
| STATE_OBJECT_METADATA | STATE_OBJECT_METADATA |
| SYSTEMSTATE | SYSTEMSTATE |
| SYSTEMSTATE_GLOBAL | SYSTEMSTATE_GLOBAL |
| TEST_DB_ROBUSTNESS | TEST_DB_ROBUSTNESS |
| TEST_GET_CALLER | TEST_GET_CALLER |
| TEST_SPACEBG | TEST_SPACEBG |
| TEST_STACK_DUMP | TEST_STACK_DUMP |
| TRACE_BUFFER_OFF | TRACE_BUFFER_OFF |
| TRACE_BUFFER_ON | TRACE_BUFFER_ON |
| TREEDUMP | TREEDUMP |
| TR_CORRUPT_ONE_SIDE | TR_CORRUPT_ONE_SIDE |
| TR_CRASH_AFTER_WRITE | TR_CRASH_AFTER_WRITE |
| TR_READ_ONE_SIDE | TR_READ_ONE_SIDE |
| TR_RESET_NORMAL | TR_RESET_NORMAL |
| TR_SET_ALL_BLOCKS | TR_SET_ALL_BLOCKS |
| TR_SET_BLOCK | TR_SET_BLOCK |
| TR_SET_SIDE | TR_SET_SIDE |
| TXEVENTQ_TXN_DUMP | |
| TXEVENTQ_TXN_DUMP_ALL | |
| UPDATE_BLOCK0_FORMAT | UPDATE_BLOCK0_FORMAT |
| WORKAREATAB_DUMP | WORKAREATAB_DUMP |
| XS_SESSION_STATE | XS_SESSION_STATE |