A list of the Oracle event codes

本文详细介绍了Oracle事件代码的用途及意义,包括控制文件调试、事务处理、日志切换等关键事件,为数据库管理员提供深入理解Oracle事件代码的指南。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

   今天是2013-10-09,在网络上逛的时候发现了一个非常不错的整理的event,收藏一下。呵呵!

A list of the Oracle event codes is shown in Table 2.6.

Table 2.6 Oracle Event Codes

Code

Description

10000

Controlfile debug event, name 慶ontrol_file�.

10001

Controlfile crash event1.

10002

Controlfile crash event2.

10003

Controlfile crash event3.

10004

Controlfile crash event4.

10005

Trace latch operations for debugging.

10006

Testing; block recovery forced.

10007

Log switch debug crash after new log select, thread %s.

10008

Log switch debug crash after new log header write, thread %s.

10009

Log switch debug crash after old log header write, thread %s.

10010

Begin transaction.

10011

End transaction.

10012

Abort transaction.

10013

Instance recovery.

10014

Roll back to save point.

10015

Undo segment recovery.

10016

Undo segment extend

10017

Undo segment wrap.

10018

Data segment create.

10019

Data segment recovery.

10020

Partial link restored to linked list (KSG).

10021

Latch cleanup for state objects (KSS).

10022

Trace ktsgsp.

10023

Create save undo segment.

10024

Write to save undo.

10025

Extend save undo segment.

10026

Apply save undo.

10027

Latch cleanup for enqueue locks (KSQ).

10028

Latch cleanup for enqueue resources (KSQ).

10029

Session logon (KSU).

10030

Session logoff (KSU).

10031

Row source debug event (R*).

10032

Sort end (SOR*).

10035

Parse SQL statement (OPIPRS).

10036

Create remote row source (QKANET).

10037

Allocate remote row source (QKARWS).

10038

Dump row source tree (QBADRV).

10039

Type checking (OPITCA).

10040

Dirty cache list.

10041

Dump undo records skipped.

10042

Trap error during undo application.

10044

Freelist undo operations.

10045

Freelist update operations: ktsrsp, ktsunl.

10046

Enable SQL statement timing.

10047

Trace switching of sessions.

10048

Undo segment shrink.

10049

Protect library cache memory heaps.

10050

Sniper trace.

10051

Trace OPI calls.

10052

Don抰 clean up obj$.

10053

CBO: Enable optimizer trace.

10054

Trace UNDO handling in MLS.

10055

Trace UNDO handling.

10056

Dump analyze stats (kdg).

10057

Suppress filenames in error messages.

10058

Use table scan cost in tab$.spare1.

10060

CBO: Enable predicate dump.

10061

Disable SMON from cleaning temp segment.

10062

Disable usage of OS roles in OSDS.

10063

Disable usage of DBA and OPER privileges in OSDS.

10064

Thread-enable debug crash level %s, thread %s.

10065

Limit library cache dump information for state object dump.

10066

Simulate failure to verify file.

10067

Force redo log checksum errors: block number.

10068

Force redo log checksum errors: file number.

10069

Trusted Oracle test event.

10070

Force datafile checksum errors: block number.

10071

Force datafile checksum errors: file number.

10072

Protect latch recovery memory.

10073

Have PMON dump info before latch cleanup.

10074

Default trace function mask for kst.

10075

CBO: Disable outer-join to regular join conversion.

10076

CBO: Enable Cartesian product join costing.

10077

CBO: Disable view-merging optimization for outer-joins.

10078

CBO: Disable constant predicate elimination optimization.

10080

Dump a block on a segment list that cannot be exchanged.

10081

Segment high-water mark has been advanced.

10082

Freelist head block is the same as the last block.

10083

A brand new block has been requested from space management.

10084

Freelist becomes empty.

10085

Freelists have been merged.

10086

CBO: Enable error if kko and qka disagree on oby sort.

10087

Disable repair of media corrupt data blocks.

10088

CBO: Disable new, NOT IN optimization.

10089

CBO: Disable index sorting.

10090

Invoke other events before crash recovery.

10091

CBO: Disable constant predicate merging.

10092

CBO: Disable hash join.

10093

CBO: Enable force hash joins.

10094

Before resizing a data file.

10095

Dump debugger commands to trace file.

10096

After the cross instance call when resizing a datafile.

10097

After generating redo when resizing a datafile.

10098

After the OS has increased the size of a datafile.

10099

After updating the file header with the new file size

10100

After the OS has decreased the size of a datafile.

10101

Atomic redo write recovery.

10102

Switch off anti-joins.

10103

CBO: Disable hash join swapping.

10104

Dump hash join statistics to trace file.

10105

CBO: Enable constant pred trans and MPS with WHERE clause.

10106

CBO: Disable evaluating correlation pred last for NOT IN.

10107

CBO: Always use bitmap index.

10108

CBO: Don抰 use bitmap index.

10109

CBO: Disable move of negated predicates

10110

CBO: Try index rowid range scans.

10111

Bitmap index creation switch.

10112

Bitmap index creation switch.

10113

Bitmap index creation switch.

10114

Bitmap index creation switch.

10115

CBO: Bitmap optimization use maximal expression.

10116

CBO: Bitmap optimization switch.

10117

CBO: Disable new parallel cost model.

10118

CBO: Enable hash join costing.

10119

QKA: Disable GBY sort elimination.

10120

CBO: Disable index fast full scan.

10121

CBO: Don抰 sort bitmap chains.

10122

CBO: Disable count(col) = count(*) transformation.

10123

QKA: Disable bitmap and-equals.

10145

Test auditing network errors.

10146

Enable Oracle TRACE collection.

10200

Block cleanout.

10201

Consistent read undo application.

10202

Consistent read block header.

10203

Consistent read buffer status.

10204

Signal recursive extend.

10205

Row cache debugging.

10206

Transaction table consistent read.

10207

Consistent read transactions� status report.

10208

Consistent read-loop check.

10209

Enable simulated error on controlfile.

10210

Check data block integrity.

10211

Check index block integrity.

10212

Check cluster integrity.

10213

Crash after control file write.

10214

Simulate write errors on controlfile.

10215

Simulate read errors on controlfile.

10216

Dump controlfile header.

10217

Debug sequence numbers.

10218

Dump UBA of applied undo.

10219

Monitor multipass row locking.

10220

Show updates to the transaction table.

10221

Show changes done with undo.

10222

Row cache.

10223

Transaction layer: Turn on verification codes.

10226

Trace CR applications of undo for data operations.

10227

Verify (multipiece) row structure.

10228

Trace application of redo by kcocbk.

10230

Check redo generation by copying before applying.

10231

Skip corrupted blocks on _table_scans._

10232

Dump corrupted blocks symbolically when kcb gotten.

10233

Skip corrupted blocks on index operations.

10234

Trigger event after calling kcrapc to do redo N times.

10235

Check memory manager internal structures.

10236

Library cache manager.

10237

Simulate ^C (for testing purposes).

10238

Instantiation manager.

10239

Multi-instance library cache manager.

10240

Dump DBAs of blocks that we wait for.

10241

Dump SQL generated for remote execution (OPIX).

10243

Simulated error for test percentages of K2GTAB latch cleanup.

10244

Make tranids in error msgs print as 0.0.0 (for testing).

10245

Simulate lock conflict error for testing PMON.

10246

Print trace of PMON actions to trace file.

10247

Turn on scgcmn tracing (VMS ONLY).

10248

Turn on tracing for dispatchers.

10249

Turn on tracing for multistated servers.

10250

Trace all allocate and free calls to the topmost SGA heap.

10251

Check consistency of transaction table and undo block.

10252

Simulate write error to data file header.

10253

Simulate write error to redo log.

10254

Trace cross-instance calls.

10256

Turn off multithreaded server load balancing.

10257

Trace multithreaded server load balancing.

10258

Force shared servers to be chosen round-robin.

10259

Get error message text from remote using explicit call.

10260

Trace calls to SMPRSET (VMS ONLY).

10261

Limit the size of the PGA heap.

10262

Don抰 check for memory leaks.

10263

Don抰 free empty PGA heap extents.

10264

Collect statistics on context area usage (x$ksmcx).

10265

Keep random system-generated output out of error messages.

10266

Trace OSD stack usage.

10267

Inhibit KSEDMP for testing.

10268

Don抰 do forward coalesce when deleting extents.

10269

Don抰 do coalesces of free space in SMON.

10270

Debug shared cursors.

10271

Distributed transaction after COLLECT.

10272

Distributed transaction before PREPARE.

10273

Distributed transaction after PREPARE.

10274

Distributed transaction before COMMIT.

10275

Distributed transaction after COMMIT.

10276

Distributed transaction before FORGET.

10277

Cursor sharing (or not) related event (used for testing).

10281

Maximum time to wait for process creation.

10282

Inhibit signaling of other backgrounds when one dies.

10286

Simulate control file open error.

10287

Simulate archiver error.

10288

Do not check block type in ktrget.

10289

Do block dumps to trace file in hex rather than formatted.

10290

Kdnchk-- checkvalid event-- not for general-purpose use.

10291

Die in dtsdrv to test controlfile undo.

10292

Dump uet entries on a 1561 from dtsdrv.

10293

Dump debugging information when doing block recovery.

10294

Enable PERSISTENT DLM operations on noncompliant systems.

10300

Disable undo compatibility check at database open.

10301

Enable LCK timeout table consistency check.

10320

Enable data layer (kdtgrs) tracing of space management calls.

10352

Report direct path statistics.

10353

Number of slots.

10354

Turn on direct read path for parallel query.

10355

Turn on direct read path for scans.

10356

Turn on hint usage for direct read.

10357

Turn on debug information for direct path.

10374

Parallel query server interrupt (validate lock value).

10375

Turn on checks for statistics rollups.

10376

Turn on table queue statistics.

10377

Turn off load balancing.

10379

Direct read for rowid range scans (unimplemented).

10380

Kxfp latch cleanup testing event.

10381

Kxfp latch cleanup testing event.

10382

Parallel query server interrupt (reset).

10383

Auto parallelization testing event.

10384

Parallel dataflow scheduler tracing.

10385

Parallel table scan range-sampling method.

10386

Parallel SQL hash and range statistics.

10387

Parallel query server interrupt (normal).

10388

Parallel query server interrupt (failure).

10389

Parallel query server interrupt (cleanup).

10390

Trace parallel query slave execution.

10391

Trace rowid range partitioning.

10392

Parallel query debugging bits.

10393

Print parallel query statistics.

10394

Allow parallelization of small tables.

10395

Adjust sample size for range table queues.

10396

Circumvent range table queues for queries.

10397

Suppress verbose parallel coordinator error reporting.

10398

Enable timeouts in parallel query thread.s

10399

Use different internal maximum buffer size.

10400

Turn on system state dumps for shutdown debugging.

10500

Turn on traces for SMON.

10510

Turn off SMON check to offline pending offline rollback segment.

10511

Turn off SMON check to cleanup undo dictionary.

10512

Turn off SMON check to shrink rollback segments.

10600

Check cursor frame allocation.

10602

Cause an access violation (for testing purposes).

10603

Cause an error to occur during truncate (for testing purposes).

10604

Trace parallel create index.

10605

Enable parallel create index by default.

10606

Trace parallel create index.

10607

Trace index rowid partition scan.

10608

Trace create bitmap index.

10610

Trace create index pseudo optimizer.

10666

Do not get database enqueue name.

10667

Cause sppst to check for valid process IDs.

10690

Set shadow process core file dump type (UNIX only).

10691

Set background process core filetype (UNIX only).

10700

Alter access violation exception handler.

10701

Dump direct loader index keys.

10702

Enable histogram data generation.

10703

Simulate process death during enqueue get.

10704

Print out information about which enqueues are being obtained.

10706

Print out information about instance lock manipulation.

10707

Simulate process death for instance registration.

10708

Print out tracing information for skxf multi-instance comms.

10709

Enable parallel instances in create index by default.

10710

Trace bitmap index access.

10711

Trace bitmap index merge.

10712

Trace bitmap index OR.

10713

Trace bitmap index AND.

10714

Trace bitmap index minus.

10715

Trace bitmap index conversion to rowids.

10800

Disable Smart Disk scan.

10801

Enable Smart Disk trace.

10802

Reserved for Smart Disk.

10803

Write timing statistics on OPS recovery scan.

10804

Reserved for ksxb.

10805

Reserved for row source sort.

10900

Extent manager fault insertion event #%s.

10924

Import storage parse error ignore event.

10925

Trace name context forever.

10926

Trace name context forever.

10927

Trace name context forever.

10928

Trace name context forever.

10999

Do not get database enqueue name.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值