티스토리 뷰
| Event # | Level | Description |
| 8186 | - |
ALTER SESSION SET EVENTS '8186 trace name context OFF' - VERSIONS BETWEEN query |
| 10013 | 1 | Monitor Transaction Recovery |
| 10015 | 1 | Dump Undo Segment Headers |
| 10015 | 3 | Identify corrupt undo segments |
| 10032 | 4 | Dump Sort Statistics |
| 10032 | 10 | Dump Sort Statistics |
| 10033 | 4 | Dump Sort Large Run Statistics (blocks dumped to disk and read back) - poss. no levels. |
| 10033 | 10 | Dump Sort Intermediate Run Statistics |
| 10045 | 1 | Trace Free List Management Operations |
| 10046 | 0 | No statistics generated |
| 10046 | 1 | Standard trace output including parsing, executes and fetches plus more |
| 10046 | 2 | Same as Level 1 |
| 10046 | 4 | Level 1 + Bind Variables |
| 10046 | 8 | Level 1 + Waits |
| 10046 | 12 | Level 1 + Bind Variables & Waits |
| 10053 | 1 | Dump Optimizer Statistics and Computations |
| 10053 | 2 | Dump Optimizer Computations only |
| 10060 | 1 | 10060 - Dump Predicates * |
| 10065 | 1 | Restrict Library Cache Output for State Object Dumps - Library Objects Only |
| 10065 | 2 | Restrict Library Cache Output for State Object Dumps + library object lock details |
| 10065 | 3 | Restrict Library Cache Output for State Object Dumps + library object handle and library object |
| 10079 | 2 | Dump SQL*Net Statistics |
| 10081 | 1 | Dump High Water Mark Changes |
| 10104 | 10 | Dump Hash Join Statistics |
| 10128 | 0x0001 | Dump Partition Pruning Information * |
| 10128 | 0x0002 | Dump partition iterators |
| 10128 | 0x0004 | Dump optimizer decisions about partition-wise joins |
| 10128 | 0x0008 | Dump ROWID range scan pruning information |
| 10132 | 12 | Dumps SQL statements into UDUMP along with the actual execution plan |
| 10200 | 1 | Dump Consistent Reads |
| 10201 | 1 | Dump Consistent Read Undo Application |
| 10210 | 10 | Table Integrity Check |
| 10211 | 10 | Index Integrity Check |
| 10220 | 1 | Dump Changes to Undo Header |
| 10221 | 7 | Dump Undo Changes |
| 10224 | 1 | Dump Index Block Splits / Deletes |
| 10225 | 1 | Dump Changes to Dictionary Managed Extents |
| 10231 | 10 | Causes full table scans to skip corrupt blocks, rather than fail with an ORA-1578 error |
| 10232 | 10 | Causes corrupt blocks to be dumped to the process trace file |
| 10233 | 10 | Traces memory usage statistics |
| 10235 | 1 | Check memory manager internal structures (use with ORA-600/ORA-7445 errors) |
| 10241 | 1 | Dump Remote SQL Execution |
| 10246 | 1 | Trace PMON Process |
| 10248 | 10 | Trace Dispatcher Processes |
| 10249 | 10 | Trace Shared Server (MTS) Processes |
| 10270 | 10 | Debug Shared Cursors |
| 10289 | 1 | Dump a database block in hexadecimal |
| 10299 | 1 | Debug Prefetch |
| 10357 | 1 | Debug Direct Path |
| 10390 | 0x0001 | Dump Parallel Execution Slave Statistics - Slave-side execution messages |
| 10390 | 0x0002 | Dump Parallel Execution Slave Statistics - Coordinator-side execution messages |
| 10390 | 0x0004 | Dump Parallel Execution Slave Statistics - Slave context state changes |
| 10390 | 0x0008 | Dump Parallel Execution Slave Statistics - Slave ROWID range bind variables and xty |
| 10390 | 0x0010 | Dump Parallel Execution Slave Statistics - Slave fetched rows as enqueued to TQ |
| 10390 | 0x0020 | Dump Parallel Execution Slave Statistics - Coordinator wait reply handling |
| 10390 | 0x0040 | Dump Parallel Execution Slave Statistics - Coordinator wait message buffering |
| 10390 | 0x0080 | Dump Parallel Execution Slave Statistics - Slave dump timing |
| 10390 | 0x0100 | Dump Parallel Execution Slave Statistics - Coordinator dump timing |
| 10390 | 0x0200 | Dump Parallel Execution Slave Statistics - Slave dump allocation file number |
| 10390 | 0x0400 | Dump Parallel Execution Slave Statistics - Terse format for debug dumps |
| 10390 | 0x0800 | Dump Parallel Execution Slave Statistics - Trace CRI random sampling |
| 10390 | 0x1000 | Dump Parallel Execution Slave Statistics - Trace signals |
| 10390 | 0x2000 | Dump Parallel Execution Slave Statistics - Trace parallel execution granule operations |
| 10390 | 0x4000 | Dump Parallel Execution Slave Statistics - Force compilation by slave 0 |
| 10391 | 0x0001 | Dump Parallel Execution Granule Allocation - Summary of each object scanned in parallel |
| 10391 | 0x0002 | Dump Parallel Execution Granule Allocation - Full dump of each object except extent map |
| 10391 | 0x0004 | Dump Parallel Execution Granule Allocation - Full dump of each object including extent map |
| 10391 | 0x0010 | Dump Parallel Execution Granule Allocation - Summary of each granule generators |
| 10391 | 0x0020 | Dump Parallel Execution Granule Allocation - Granule generators except granule instances |
| 10391 | 0x0040 | Dump Parallel Execution Granule Allocation - Granule generators including granule instances |
| 10391 | 0x0080 | Dump Parallel Execution Granule Allocation - System information |
| 10391 | 0x0100 | Dump Parallel Execution Granule Allocation - Reference object for the query |
| 10391 | 0x0200 | Dump Parallel Execution Granule Allocation - kxfralo timing |
| 10391 | 0x0400 | Dump Parallel Execution Granule Allocation - Affinity module |
| 10391 | 0x0800 | Dump Parallel Execution Granule Allocation - Granule allocation during query execution |
| 10391 | 0x1000 | Dump Parallel Execution Granule Allocation - Object flush |
| 10393 | 1 | Dump Parallel Execution Statistics |
| 10401 | 1 | KSXP tracing - event 10401 trace name context forever, level 1 (for RAC kernel) |
| 10402 | 1 | SKGXP tracing - event 10402 trace name context forever, level 1 (for RAC kernel) minimal tracing |
| 10402 | 127 | SKGXP tracing - event 10402 trace name context forever, level 1 (for RAC kernel) maximum tracing |
| 10500 | 1 | Trace SMON Process |
| 10608 | 10 | Trace Bitmap Index Creation |
| 10704 | 1 | Trace Enqueues |
| 10706 | 1 | Trace Global Enqueue Manipulation |
| 10708 | 10 | Trace RAC Buffer Cache |
| 10710 | 1 | Trace Bitmap Index Access |
| 10711 | 1 | Trace Bitmap Index Merge Operation |
| 10712 | 1 | Trace Bitmap Index OR Operation |
| 10713 | 1 | Trace Bitmap Index AND Operation |
| 10714 | 1 | Trace Bitmap Index MINUS Operation |
| 10715 | 1 | Trace Bitmap Index Conversion to ROWIDs |
| 10716 | 1 | Trace Bitmap Index Compress / Decompress |
| 10717 | 1 | Trace Bitmap Index Compaction |
| 10719 | 1 | 10719 - Trace Bitmap Index DML |
| 10730 | 1 | Trace Fine Grained Access Predicates |
| 10731 | 1 | Trace CURSOR Statements |
| 10731 | 2 | Trace CURSOR Statements |
| 10901 | Disable extent trimming | |
| 10928 | 1 | Trace PL/SQL Execution |
| 10938 | 1 | Trace PL/SQL Execution Statistics |
| 29700 | Enable the collection of DLM lock conversion statistics to query GV$DLM_CONVERT_LOCAL and GV$DLM_CONVERT_REMOTE |
Use "dbms_monitor.session_trace_enable()" instead of "alter session set events ..." and you will see the columns sys.gv_$session updated
'데이터베이스 > oracle' 카테고리의 다른 글
| oradebug help (0) | 2008.02.13 |
|---|---|
| oracle 10g audit_trail 사용 (0) | 2008.01.26 |
| Oracle Datapump 사용해 보기 (0) | 2008.01.11 |
| Automatically Restarting ONS (0) | 2007.12.31 |
| 오라클 OBJECT 조회 (0) | 2007.12.26 |
공지사항
최근에 올라온 글
최근에 달린 댓글
- Total
- Today
- Yesterday
링크
TAG
- 성공의길
- CUBRID
- 구글
- getGeneratedKeys
- shared all
- 데이터과학
- oracle
- shared everything
- 브레인피드백
- 바이오해킹
- 커뮤니케이션의 7가지 나쁜 습관들
- DB
- 카이에 소바주 시리즈
- 프로젝트
- 오라클
- 구조주의 인류학
- Datapump
- 튜닝
- 꿈
- 퇴사
- 일본전산
- 다짐
- ChatGPT
- 습관의힘
- auto increment
- 셀프 조인
- 아웃라이어
- 디자인패턴
- NHN 면접
- 큐브리드
| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 |
글 보관함
