{"id":421,"date":"2014-05-15T14:49:55","date_gmt":"2014-05-15T06:49:55","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=421"},"modified":"2014-08-15T14:57:38","modified_gmt":"2014-08-15T06:57:38","slug":"%e8%b0%83%e4%bc%98%e5%ae%9e%e8%b7%b502-alter-systemsession-set-events%e8%bd%ac%e5%82%a8","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=421","title":{"rendered":"\u8c03\u4f18\u5b9e\u8df502–ALTER SYSTEM\/SESSION SET EVENTS\u8f6c\u50a8"},"content":{"rendered":"
\n
ALTER SYSTEM\/SESSION SET EVENTS<\/div>\n
    \n
  1. \u8bed\u6cd5:alter system|session set events ‘[eventnumber|immediate] trace name eventname [forever] [, level levelnumber] : ……’;\u00a0\u901a\u8fc7[:]\u7b26\u53f7,\u53ef\u4ee5\u8fde\u7eed\u8bbe\u7f6e\u591a\u4e2a\u4e8b\u4ef6,\u4e5f\u53ef\u4ee5\u901a\u8fc7\u8fde\u7eed\u4f7f\u7528alter session set events\u6765\u8bbe\u7f6e\u591a\u4e2a\u4e8b\u4ef6;<\/li>\n
  2. \u53c2\u6570\u8bf4\u660e:\n
      \n
    1. eventnumber:\u6307\u89e6\u53d1dump\u7684\u4e8b\u4ef6\u53f7,\u4e8b\u4ef6\u53f7\u53ef\u4ee5\u662fOracle\u9519\u8bef\u53f7(\u51fa\u73b0\u76f8\u5e94\u9519\u8bef\u65f6\u8ddf\u8e2a\u6307\u5b9a\u7684\u4e8b\u4ef6)\u6216oralce\u5185\u90e8\u4e8b\u4ef6\u53f7(\u5185\u90e8\u4e8b\u4ef6\u53f7\u572810000\u523010999\u4e4b\u95f4),\u4e0d\u80fd\u4e0eimmediate\u5173\u952e\u5b57\u540c\u7528;<\/li>\n
    2. immediate:\u5173\u952e\u5b57\u8868\u793a\u547d\u4ee4\u53d1\u51fa\u540e,\u7acb\u5373\u5c06\u6307\u5b9a\u7684\u7ed3\u6784dump\u5230\u8ddf\u8e2a\u6587\u4ef6\u4e2d,\u8fd9\u4e2a\u5173\u952e\u5b57\u53ea\u7528\u5728alter session\u8bed\u53e5\u4e2d,\u5e76\u4e14\u4e0d\u80fd\u4e0eeventnumber\/forever\u5173\u952e\u5b57\u540c\u7528;<\/li>\n
    3. eventname:\u6307\u4e8b\u4ef6\u540d\u79f0,\u5373\u8981\u8fdb\u884cdump\u7684\u5b9e\u9645\u7ed3\u6784\u540d;\u82e5eventname\u4e3acontext,\u5219\u6307\u6839\u636e\u5185\u90e8\u4e8b\u4ef6\u53f7\u8fdb\u884c\u8ddf\u8e2a;<\/li>\n
    4. forever:\u5173\u952e\u5b57\u8868\u793a\u4e8b\u4ef6\u5728\u5b9e\u4f8b\u6216\u4f1a\u8bdd\u7684\u5468\u671f\u5185\u4fdd\u6301\u6709\u6548\u72b6\u6001,\u4e0d\u80fd\u4e0eimmediate\u540c\u7528;<\/li>\n
    5. level:\u4e3a\u4e8b\u4ef6\u7ea7\u522b\u5173\u952e\u5b57,\u4f46\u5728dump\u9519\u8bef\u6808(errorstack)\u65f6\u4e0d\u5b58\u5728\u7ea7\u522b;<\/li>\n
    6. levelnumber:\u8868\u793a\u4e8b\u4ef6\u7ea7\u522b\u53f7,\u4e00\u822c\u4ece1\u523010,1\u8868\u793a\u53eadump\u7ed3\u6784\u5934\u90e8\u4fe1\u606f,10\u8868\u793adump\u7ed3\u6784\u7684\u6240\u6709\u4fe1\u606f;<\/li>\n<\/ol>\n<\/li>\n
    7. \u5e38\u7528\u7684\u4e8b\u4ef6\u540d\u79f0\u548c\u7ea7\u522b:\n
        \n
      1. Memory Dumps:\n
          \n
        1. Global Area:ALTER SESSION SET EVENTS ‘immediate trace name global_area level n’;\n
            \n
          1. 1 \u5305\u542bPGA<\/li>\n
          2. 2 \u5305\u542bSGA<\/li>\n
          3. 4 \u5305\u542bUGA<\/li>\n
          4. 8 \u5305\u542bindrect memory<\/li>\n<\/ol>\n<\/li>\n
          5. Library Cache:ALTER SESSION SET EVENTS ‘immediate trace name library_cache level n’;\n
              \n
            1. 1 library cache\u7edf\u8ba1\u4fe1\u606f<\/li>\n
            2. 2 \u5305\u542bhash table histogram<\/li>\n
            3. 3 \u5305\u542bobject handle<\/li>\n
            4. 4 \u5305\u542bobject\u7ed3\u6784<\/li>\n<\/ol>\n<\/li>\n
            5. Row Cache:ALTER SESSION SET EVENTS ‘immediate trace name row_cache level n’;\n
                \n
              1. 1 row cache\u7edf\u8ba1\u4fe1\u606f<\/li>\n
              2. 2 \u5305\u542bhash table histogram<\/li>\n
              3. 8 \u5305\u542bobject\u7ed3\u6784<\/li>\n<\/ol>\n<\/li>\n
              4. Buffers:ALTER SESSION SET EVENTS ‘immediate trace name buffers level n’;\n
                  \n
                1. 1 buffer header<\/li>\n
                2. 2 level 1 + block header<\/li>\n
                3. 3 level 2 + block contents<\/li>\n
                4. 4 level 1 + hash chain<\/li>\n
                5. 5 level 2 + hash chain<\/li>\n
                6. 6 level 3 + hash chain<\/li>\n
                7. 8 level 4 + users\/waiters<\/li>\n
                8. 9 level 5 + users\/waiters<\/li>\n
                9. 10 level 6 + users\/waiters<\/li>\n<\/ol>\n<\/li>\n
                10. Buffer:ALTER SESSION SET EVENTS ‘immediate trace name buffer level n’;\n
                    \n
                  1. n\u4e3a\u67d0\u4e2a\u6307\u5b9ablock\u7684rdba,\u8be5\u547d\u4ee4\u53ef\u4ee5\u8f6c\u50a8\u67d0\u4e2ablock\u5728buffer\u4e2d\u7684\u6240\u6709\u7248\u672c;<\/li>\n<\/ol>\n<\/li>\n
                  2. Heap:ALTER SESSION SET EVENTS ‘immediate trace name heapdump level n’;\n
                      \n
                    1. 1 PGA\u6458\u8981<\/li>\n
                    2. 2 SGA\u6458\u8981<\/li>\n
                    3. 4 UGA\u6458\u8981<\/li>\n
                    4. 8 Current call(CGA)\u6458\u8981<\/li>\n
                    5. 16 User call(CGA)\u6458\u8981<\/li>\n
                    6. 32 Large call(LGA)\u6458\u8981<\/li>\n
                    7. 1025 PGA\u5185\u5bb9<\/li>\n
                    8. 2050 SGA\u5185\u5bb9<\/li>\n
                    9. 4100 UGA\u5185\u5bb9<\/li>\n
                    10. 8200 Current call\u5185\u5bb9<\/li>\n
                    11. 16400 User call\u5185\u5bb9<\/li>\n
                    12. 32800 Large call\u5185\u5bb9<\/li>\n<\/ol>\n<\/li>\n
                    13. Sub Heap:\n
                        \n
                      1. ALTER SESSION SET EVENTS ‘immediate trace name heapdump_addr level n’;(oracle 9.0.1\u7248\u672c\u4e4b\u524d)\n
                          \n
                        1. \u82e5n\u4e3asubheap\u7684\u5730\u5740\uff0c\u8f6c\u50a8\u7684\u662fsubheap\u7684\u6458\u8981\u4fe1\u606f<\/li>\n
                        2. \u82e5n\u4e3asubheap\u7684\u5730\u5740+1\uff0c\u8f6c\u50a8\u7684\u5219\u662fsubheap\u7684\u5185\u5bb9<\/li>\n<\/ol>\n<\/li>\n
                        3. ALTER SESSION SET EVENTS ‘immediate trace name heapdump_addr level n, addr m’;(oracle 9.2.0\u7248\u672c\u4e4b\u540e)\n
                            \n
                          1. \u5176\u4e2dm\u4e3asubheap\u7684\u5730\u5740<\/li>\n
                          2. n\u4e3a1\u8f6c\u50a8subheap\u7684\u6458\u8981\uff0cn\u4e3a2\u8f6c\u50a8subheap\u7684\u5185\u5bb9<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
                          3. Process State:ALTER SESSION SET EVENTS ‘immediate trace name processstate level n’;<\/li>\n
                          4. System State:ALTER SESSION SET EVENTS ‘immediate trace name systemstate level n’;<\/li>\n
                          5. Error State:ALTER SESSION SET EVENTS ‘immediate trace name errorstack level n’;\n
                              \n
                            1. 0 Error stack<\/li>\n
                            2. 1 level 0 + function call stack<\/li>\n
                            3. 2 level 1 + process state<\/li>\n
                            4. 3 level 2 + context area<\/li>\n<\/ol>\n<\/li>\n
                            5. Hang Analysis:ALTER SESSION SET EVENTS ‘immediate trace name hanganalyze level n’;<\/li>\n
                            6. Work Area:ALTER SESSION SET EVENTS ‘immediate trace name workareatab_dump level n’;\n
                                \n
                              1. 1 SGA\u4fe1\u606f<\/li>\n
                              2. 2 Workarea Table\u6458\u8981\u4fe1\u606f<\/li>\n
                              3. 3 Workarea Table\u8be6\u7ec6\u4fe1\u606f<\/li>\n<\/ol>\n<\/li>\n
                              4. Latches:ALTER SESSION SET EVENTS ‘immediate trace name latches level n’;\n
                                  \n
                                1. 1 latch\u4fe1\u606f<\/li>\n
                                2. 2 \u7edf\u8ba1\u4fe1\u606f<\/li>\n<\/ol>\n<\/li>\n
                                3. Events:ALTER SESSION SET EVENTS ‘immediate trace name events level n’;\n
                                    \n
                                  1. 1 session<\/li>\n
                                  2. 2 process<\/li>\n
                                  3. 3 system<\/li>\n<\/ol>\n<\/li>\n
                                  4. Locks:ALTER SESSION SET EVENTS ‘immediate trace name locks level n’;<\/li>\n
                                  5. Shared Server Process:ALTER SESSION SET EVENTS ‘immediate trace name shared_server_state level n’;\n
                                      \n
                                    1. n\u53d6\u503c\u4e3a1~14<\/li>\n<\/ol>\n<\/li>\n
                                    2. Background Messages:ALTER SESSION SET EVENTS ‘immediate trace name bg_messages level n’;\n
                                        \n
                                      1. n\u4e3apid+1<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
                                      2. File Dumps:\n
                                          \n
                                        1. Block:\n
                                            \n
                                          1. ALTER SESSION SET EVENTS ‘immediate trace name blockdump level n’;(oracle 7\u4e4b\u524d)\n
                                              \n
                                            1. n\u4e3ablock\u7684rdba<\/li>\n<\/ol>\n<\/li>\n
                                            2. ALTER SYSTEM DUMP DATAFILE file# BLOCK block#;(oracle8\u4ee5\u540e)<\/li>\n
                                            3. ALTER SYSTEM DUMP DATAFILE file#\u00a0BLOCK MIN minimum_block#\u00a0BLOCK MAX maximum_block#;<\/li>\n<\/ol>\n<\/li>\n
                                            4. Tree Dump:ALTER SESSION SET EVENTS ‘immediate trace name treedump level n’;\n
                                                \n
                                              1. n\u4e3aobject_id<\/li>\n<\/ol>\n<\/li>\n
                                              2. Undo Segment Header:ALTER SYSTEM DUMP UNDO_HEADER ‘segment_name’;<\/li>\n
                                              3. Undo for a Transaction:ALTER SYSTEM DUMP UNDO BLOCK ‘segment_name’ XID xidusn xidslot xidsqn;<\/li>\n
                                              4. File Header:ALTER SESSION SET EVENTS ‘immediate trace name file_hdrs level n’;\n
                                                  \n
                                                1. 1 \u63a7\u5236\u6587\u4ef6\u4e2d\u7684\u6587\u4ef6\u5934\u4fe1\u606f<\/li>\n
                                                2. 2 level 1 + \u6587\u4ef6\u5934\u4fe1\u606f<\/li>\n
                                                3. 3 level 2 + \u6570\u636e\u6587\u4ef6\u5934\u4fe1\u606f<\/li>\n
                                                4. 10 level 3<\/li>\n<\/ol>\n<\/li>\n
                                                5. Control file:ALTER SESSION SET EVENTS ‘immediate trace name controlf level n’;\n
                                                    \n
                                                  1. 1 \u6587\u4ef6\u5934\u4fe1\u606f<\/li>\n
                                                  2. 2 level 1 + \u6570\u636e\u5e93\u4fe1\u606f + \u68c0\u67e5\u70b9\u4fe1\u606f<\/li>\n
                                                  3. 3 level 2 + \u53ef\u91cd\u7528\u8282\u4fe1\u606f<\/li>\n
                                                  4. 10 level 3<\/li>\n<\/ol>\n<\/li>\n
                                                  5. Redo log Header:ALTER SESSION SET EVENTS ‘immediate trace name redohdr level n’;\n
                                                      \n
                                                    1. 1 \u63a7\u5236\u6587\u4ef6\u4e2d\u7684redo log\u4fe1\u606f<\/li>\n
                                                    2. 2 level 1 + \u6587\u4ef6\u5934\u4fe1\u606f<\/li>\n
                                                    3. 3 level 2 + \u65e5\u5fd7\u6587\u4ef6\u5934\u4fe1\u606f<\/li>\n
                                                    4. 10 level 3<\/li>\n<\/ol>\n<\/li>\n
                                                    5. Redo log\n
                                                        \n
                                                      1. ALTER SYSTEM DUMP LOGFILE ‘FileName’;<\/li>\n
                                                      2. ALTER SYSTEM DUMP LOGFILE ‘FileName’\n
                                                          \n
                                                        1. SCN MIN MinimumSCN<\/li>\n
                                                        2. SCN MAX MaximumSCN<\/li>\n
                                                        3. TIME MIN MinimumTime<\/li>\n
                                                        4. TIME MAX MaximumTime<\/li>\n
                                                        5. LAYER Layer<\/li>\n
                                                        6. OPCODE Opcode<\/li>\n
                                                        7. DBA MIN FileNumber . BlockNumber<\/li>\n
                                                        8. DBA MAX FileNumber . BlockNumber<\/li>\n
                                                        9. RBA MIN LogFileSequenceNumber . BlockNumber<\/li>\n
                                                        10. RBA MAX LogFileSequenceNumber . BlockNumber;<\/li>\n<\/ol>\n<\/li>\n
                                                        11. \u5176\u4e2dtime = (((((yyyy – 1988)) * 12 + mm – 1) * 31 + dd – 1) * 24 + hh) * 60 + mi) * 60 + ss;<\/li>\n<\/ol>\n<\/li>\n
                                                        12. Loghist:ALTER SESSION SET EVENTS ‘immediate trace name loghist level n’;\n
                                                            \n
                                                          1. 1 dump\u63a7\u5236\u6587\u4ef6\u4e2d\u6700\u65e9\u548c\u6700\u8fdf\u7684\u65e5\u5fd7\u5386\u53f2\u9879<\/li>\n
                                                          2. >1 dump 2^n\u4e2a\u65e5\u5fd7\u5386\u53f2\u9879<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
                                                          3. \u4e8b\u4ef6\u7f16\u53f7\u548c\u5bf9\u5e94\u7684\u63cf\u8ff0;<\/li>\n
                                                          4. \u83b7\u5f97\u5bf9\u5e94trace\u6587\u4ef6\u7684\u811a\u672c;<\/li>\n
                                                          5. \u4f8b\u5b50:\n
                                                              \n
                                                            1. alter session set events ‘10046 trace name context forever,level 12’;<\/li>\n
                                                            2. alter session set events ‘immediate trace name controlf level 12’;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                                                              <\/div>\n
                                                              ———————————- \u83b7\u5f97\u5bf9\u5e94trace\u6587\u4ef6\u7684\u811a\u672c\u00a0———————————-<\/div>\n
                                                              SELECT a.VALUE || b.symbol || c.instance_name || ‘_ora_’ || d.spid || ‘.trc’ trace_file
                                                              \nFROM (SELECT VALUE FROM v$parameter WHERE NAME = ‘user_dump_dest’) a,
                                                              \n(SELECT substr(VALUE, -6, 1) symbol FROM v$parameter WHERE NAME = ‘user_dump_dest’) b,
                                                              \n(SELECT instance_name FROM v$instance) c,
                                                              \n(SELECT spid
                                                              \nFROM v$session s, v$process p, v$mystat m
                                                              \nWHERE s.paddr = p.addr AND
                                                              \ns.sid = m.sid AND
                                                              \nm.statistic# = 0) d;<\/div>\n
                                                              ———————————- \u83b7\u5f97\u5bf9\u5e94trace\u6587\u4ef6\u7684\u811a\u672c\u00a0———————————-<\/div>\n
                                                              <\/div>\n
                                                              ———————————-\u00a0\u4e8b\u4ef6\u7f16\u53f7\u548c\u5bf9\u5e94\u7684\u63cf\u8ff0\u00a0———————————-
                                                              \n10000 Controlfile debug event, name ‘control_file’
                                                              \n10001 Controlfile crash event1
                                                              \n10002 Controlfile crash event2
                                                              \n10003 Controlfile crash event3
                                                              \n10004 Controlfile crash event4
                                                              \n10005 Trace latch operations for debugging
                                                              \n10006 Testing – block recovery forced
                                                              \n10007 Log switch debug crash after new log select, thread %s
                                                              \n10008 Log switch debug crash after new log header write, thread %s
                                                              \n10009 Log switch debug crash after old log header write, thread %s
                                                              \n10010 Begin Transaction
                                                              \n10011 End Transaction
                                                              \n10012 Abort Transaction
                                                              \n10013 Instance Recovery
                                                              \n10014 Roll Back to Save Point
                                                              \n10015 Undo Segment Recovery
                                                              \n10016 Undo Segment extend
                                                              \n10017 Undo Segment Wrap
                                                              \n10018 Data Segment Create
                                                              \n10019 Data Segment Recovery
                                                              \n10020 Partial link restored to linked list (KSG)
                                                              \n10021 Latch cleanup for state objects (KSS)
                                                              \n10022 Trace ktsgsp
                                                              \n10023 Create Save Undo Segment
                                                              \n10024 Write to Save Undo
                                                              \n10025 Extend Save Undo Segment
                                                              \n10026 Apply Save Undo
                                                              \n10027 Latch cleanup for enqueue locks (KSQ)
                                                              \n10028 Latch cleanup for enqueue resources (KSQ)
                                                              \n10029 Session logon (KSU)
                                                              \n10030 Session logoff (KSU)
                                                              \n10031 Sort debug event (S*)
                                                              \n10032 Sort statistics (SOR*)
                                                              \n10033 Sort run information (SRD*\/SRS*)
                                                              \n10034 Access path analysis (APA*)
                                                              \n10035 Parse SQL statement (OPIPRS)
                                                              \n10036 Create remote row source (QKANET)
                                                              \n10037 Allocate remote row source (QKARWS)
                                                              \n10038 Dump row source tree (QBADRV)
                                                              \n10039 Type checking (OPITCA)
                                                              \n10040 Dirty cache list
                                                              \n10041 Dump undo records skipped
                                                              \n10042 Trap error during undo application
                                                              \n10043 Check consistency of owner\/waiter\/converter lists in KSQ
                                                              \n10044 Free list undo operations
                                                              \n10045 Free list update operations – ktsrsp, ktsunl
                                                              \n10046 Enable SQL statement timing
                                                              \n10047 Trace switching of sessions
                                                              \n10048 Undo segment shrink
                                                              \n10049 Protect library cache memory heaps
                                                              \n10050 Sniper trace
                                                              \n10051 Trace OPI calls
                                                              \n10052 Don’t clean up obj$
                                                              \n10053 CBO Enable optimizer trace
                                                              \n10054 Trace UNDO handling in MLS
                                                              \n10055 Trace UNDO handing
                                                              \n10056 Dump analyze stats (kdg)
                                                              \n10057 Suppress file names in error messages
                                                              \n10058 Use table scan cost in tab$.spare1
                                                              \n10059 Simulate error in logfile create\/clear
                                                              \n10060 CBO Enable predicate dump
                                                              \n10061 Disable SMON from cleaning temp segment
                                                              \n10062 Disable usage of OS Roles in osds
                                                              \n10063 Disable usage of DBA and OPER privileges in osds
                                                              \n10064 Thread enable debug crash level %s, thread %s
                                                              \n10065 Limit library cache dump information for state object dump
                                                              \n10066 Simulate failure to verify file
                                                              \n10067 Force redo log checksum errors – block number
                                                              \n10068 Force redo log checksum errors – file number
                                                              \n10069 Trusted Oracle test event
                                                              \n10070 Force datafile checksum errors – block number
                                                              \n10071 Force datafile checksum errors – file number
                                                              \n10072 Protect latch recovery memory
                                                              \n10073 Have PMON dump info before latch cleanup
                                                              \n10074 Default trace function mask for kst
                                                              \n10075 CBO Disable outer-join to regular join conversion
                                                              \n10076 CBO Enable cartesian product join costing
                                                              \n10077 CBO Disable view-merging optimization for outer-joins
                                                              \n10078 CBO Disable constant predicate elimination optimization
                                                              \n10079 Trace data sent\/received via SQL*Net
                                                              \n10080 Dump a block on a segment list which cannot be exchanged
                                                              \n10081 Segment High Water Mark has been advanced
                                                              \n10082 Free list head block is the same as the last block
                                                              \n10083 A brand new block has been requested from space management
                                                              \n10084 Free list becomes empty
                                                              \n10085 Free lists have been merged
                                                              \n10086 CBO Enable error if kko and qka disagree on oby sort
                                                              \n10087 Disable repair of media corrupt data blocks
                                                              \n10088 CBO Disable new NOT IN optimization
                                                              \n10089 CBO Disable index sorting
                                                              \n10090 Invoke other events before crash recovery
                                                              \n10091 CBO Disable constant predicate merging
                                                              \n10092 CBO Disable hash join
                                                              \n10093 CBO Enable force hash joins
                                                              \n10094 Before resizing a data file
                                                              \n10095 Dump debugger commands to trace file
                                                              \n10096 After the cross instance call when resizing a data file
                                                              \n10097 After generating redo when resizing a data file
                                                              \n10098 After the OS has increased the size of a data file
                                                              \n10099 After updating the file header with the new file size
                                                              \n10100 After the OS has decreased the size of a data file
                                                              \n10101 Atomic redo write recovery
                                                              \n10102 Switch off anti-joins
                                                              \n10103 CBO Disable hash join swapping
                                                              \n10104 Dump hash join statistics to trace file
                                                              \n10105 CBO Enable constant pred trans and MPs w WHERE-clause
                                                              \n10106 CBO Disable evaluating correlation pred last for NOT IN
                                                              \n10107 CBO Always use bitmap index
                                                              \n10108 CBO Don’t use bitmap index
                                                              \n10109 CBO Disable move of negated predicates
                                                              \n10110 CBO Try index rowid range scans
                                                              \n10111 Bitmap index creation switch
                                                              \n10112 Bitmap index creation switch
                                                              \n10113 Bitmap index creation switch
                                                              \n10114 Bitmap index creation switch
                                                              \n10115 CBO Bitmap optimization use maximal expression
                                                              \n10116 CBO Bitmap optimization switch
                                                              \n10117 CBO Disable new parallel cost model
                                                              \n10118 CBO Enable hash join costing
                                                              \n10119 QKA Disable GBY sort elimination
                                                              \n10120 Generate relative file # different from absolute
                                                              \n10121 CBO Don’t sort bitmap chains
                                                              \n10122 Disable transformation of count(col) to count(*)
                                                              \n10123 QKA Disable Bitmap And-EQuals
                                                              \n10124 Force creation of segmented arrays by kscsAllocate
                                                              \n10125 Disable remote sort elimination
                                                              \n10126 Debug oracle java xa
                                                              \n10127 Disable remote query block operation
                                                              \n10128 Dump Partition Pruning Information
                                                              \n10129 Alter histogram lookup for remote queries
                                                              \n10130 Sort disable readaheads
                                                              \n10131 Use v$sql_plan code path for explain plan
                                                              \n10132 Dump plan after compilation
                                                              \n10133 Testing for SQL Memory Management
                                                              \n10134 Tracing for SQL Memory Management for session
                                                              \n10135 CBO do not count 0 rows partitions
                                                              \n10136 CBO turn off fix for bug 1089848
                                                              \n10137 CBO turn off fix for bug 1344111
                                                              \n10138 CBO turn off fix for bug 1577003
                                                              \n10139 CBO turn off fix for bug 1386119
                                                              \n10140 CBO turn off fix for bug 1332980
                                                              \n10141 CBO disable additional keys for inlist in bitmap optimization
                                                              \n10142 CBO enable dynamic selectivity estimation
                                                              \n10143 CBO force dynamic selectivity estimation (if enabled)
                                                              \n10145 Test auditing network errors
                                                              \n10146 Enable Oracle TRACE collection
                                                              \n10148 Use pre-7.3.3 random generator
                                                              \n10149 Allow the creation of constraints with illegal date constants
                                                              \n10150 Import exceptions
                                                              \n10151 Force duplicate dependency removal
                                                              \n10152 CBO don’t consider function costs in plans
                                                              \n10153 Switch to use public synonym if private one does not translate
                                                              \n10154 Switch to disallow synonyms in DDL statements
                                                              \n10155 CBO disable generation of transitive OR-chains
                                                              \n10156 CBO disable index fast full scan
                                                              \n10157 CBO disable index access path for in-list
                                                              \n10158 CBO preserve predicate order in post-filters
                                                              \n10159 CBO disable order-by sort pushdown into domain indexes
                                                              \n10160 CBO disable use of join index
                                                              \n10161 CBO recursive semi-join on\/off-switch
                                                              \n10162 CBO join-back elimination on\/off-switch
                                                              \n10163 CBO join-back elimination on\/off-switch
                                                              \n10164 CBO disable subquery-adjusted cardinality fix
                                                              \n10165 Mark session to be aborted during shutdown normal
                                                              \n10166 Trace long operation statistics updates
                                                              \n10167 CBO use old index MIN\/MAX optimization
                                                              \n10168 CBO disable single-table predicate predicate generation
                                                              \n10169 CBO disable histograms for multi partitions
                                                              \n10170 CBO use old bitmap costing
                                                              \n10171 CBO disable transitive join predicates
                                                              \n10172 CBO force hash join back
                                                              \n10173 CBO no constraint-based join-back elimination
                                                              \n10174 View join-back elimination switch
                                                              \n10175 CBO star transformation switch
                                                              \n10176 CBO colocated join switch
                                                              \n10177 CBO colocated join switch
                                                              \n10178 CBO turn off hash cluster filtering through memcmp
                                                              \n10179 CBO turn off transitive predicate replacement
                                                              \n10180 Temp table transformation print error messages
                                                              \n10181 CBO disable multi-column in-list processing
                                                              \n10182 CBO disable generation of implied predicates
                                                              \n10183 CBO disable cost rounding
                                                              \n10184 CBO disable OR-exp if long inlist on bitmap column
                                                              \n10185 CBO force index joins
                                                              \n10186 CBO disable index join
                                                              \n10187 CBO additional index join switch
                                                              \n10188 “CBO additional index join switch
                                                              \n10189 CBO turn off FFS null fix
                                                              \n10190 Analyze use old frequency histogram collection and density
                                                              \n10191 Avoid conversion of in-lists back to OR-expanded form
                                                              \n10192 Nopushdown when number of groups exceed number of rows
                                                              \n10193 Force repeatable sampling with specified seed
                                                              \n10194 CBO disable new LIKE selectivity heuristic
                                                              \n10195 CBO don’t use check constraints for transitive predicates
                                                              \n10196 CBO disable index skip scan
                                                              \n10197 CBO force index skip scan
                                                              \n10198 Check undo record
                                                              \n10199 Set parameter in session
                                                              \n10200 Consistent read buffer status
                                                              \n10201 Consistent read undo application
                                                              \n10202 Consistent read block header
                                                              \n10203 Block cleanout
                                                              \n10204 Signal recursive extend
                                                              \n10205 Row cache debugging
                                                              \n10206 Transaction table consistent read
                                                              \n10207 Consistent read transactions’ status report
                                                              \n10208 Consistent read loop check
                                                              \n10209 Enable simulated error on controlfile
                                                              \n10210 Check data block integrity
                                                              \n10211 Check index block integrity
                                                              \n10212 Check cluster integrity
                                                              \n10213 Crash after controlfile write
                                                              \n10214 Simulate write errors on controlfile
                                                              \n10215 Simulate read errors on controlfile
                                                              \n10216 Dump controlfile header
                                                              \n10217 Debug sequence numbers
                                                              \n10218 Dump uba of applied undo
                                                              \n10219 Monitor multi-pass row locking
                                                              \n10220 Show updates to the transaction table
                                                              \n10221 Show changes done with undo
                                                              \n10222 Row cache
                                                              \n10223 Transaction layer – turn on verification codes
                                                              \n10224 Index block split\/delete trace
                                                              \n10225 Free\/used extent row cache
                                                              \n10226 Trace CR applications of undo for data operations
                                                              \n10227 Verify (multi-piece) row structure
                                                              \n10228 Trace application of redo by kcocbk
                                                              \n10229 Simulate I\/O error against datafiles
                                                              \n10230 Check redo generation by copying before applying
                                                              \n10231 Skip corrupted blocks on _table_scans_
                                                              \n10232 Dump corrupted blocks symbolically when kcbgotten
                                                              \n10233 Skip corrupted blocks on index operations
                                                              \n10234 Trigger event after calling kcrapc to do redo N times
                                                              \n10235 Check memory manager internal structures
                                                              \n10236 Library cache manager
                                                              \n10237 Simulate ^C (for testing purposes)
                                                              \n10238 Instantiation manager
                                                              \n10239 Multi-instance library cache manager
                                                              \n10240 Dump dba’s of blocks that we wait for
                                                              \n10241 Remote SQL execution tracing\/validation
                                                              \n10242 Suppress OER 2063 (for testing distrib w\/o different error log)
                                                              \n10243 Simulated error for test %s of K2GTAB latch cleanup
                                                              \n10244 Make tranids in error msgs print as 0.0.0 (for testing)
                                                              \n10245 Simulate lock conflict error for testing PMON
                                                              \n10246 Print trace of PMON actions to trace file
                                                              \n10247 Turn on scgcmn tracing. (VMS ONLY)
                                                              \n10248 Turn on tracing for dispatchers
                                                              \n10249 Turn on tracing for multi-stated servers
                                                              \n10250 Trace all allocate and free calls to the topmost SGA heap
                                                              \n10251 Check consistency of transaction table and undo block
                                                              \n10252 Simulate write error to data file header
                                                              \n10253 Simulate write error to redo log
                                                              \n10254 Trace cross-instance calls
                                                              \n10255 Pl\/sql parse checking
                                                              \n10256 Turn off shared server load balancing
                                                              \n10257 Trace shared server load balancing
                                                              \n10258 Force shared servers to be chosen round-robin
                                                              \n10259 Get error message text from remote using explicit call
                                                              \n10260 Trace calls to SMPRSET (VMS ONLY)
                                                              \n10261 Limit the size of the PGA heap
                                                              \n10262 Don’t check for memory leaks
                                                              \n10263 Don’t free empty PGA heap extents
                                                              \n10264 Collect statistics on context area usage (x$ksmcx)
                                                              \n10265 Keep random system generated output out of error messages
                                                              \n10266 Trace OSD stack usage
                                                              \n10267 Inhibit KSEDMP for testing
                                                              \n10268 Don’t do forward coalesce when deleting extents
                                                              \n10269 Don’t do coalesces of free space in SMON
                                                              \n10270 Debug shared cursors
                                                              \n10271 Distributed transaction after COLLECT
                                                              \n10272 Distributed transaction before PREPARE
                                                              \n10273 Distributed transaction after PREPARE
                                                              \n10274 Distributed transaction before COMMIT
                                                              \n10275 Distributed transaction after COMMIT
                                                              \n10276 Distributed transaction before FORGET
                                                              \n10277 Cursor sharing (or not) related event (used for testing)
                                                              \n10278 Internal testing
                                                              \n10279 Simulate block corruption in kdb4chk
                                                              \n10280 Internal testing – segmentation fault during crash recovery
                                                              \n10281 Maximum time to wait for process creation
                                                              \n10282 Inhibit signalling of other backgrounds when one dies
                                                              \n10283 Simulate asynch I\/O never completing
                                                              \n10284 Simulate zero\/infinite asynch I\/O buffering
                                                              \n10285 Simulate controlfile header corruption
                                                              \n10286 Simulate controlfile open error
                                                              \n10287 Simulate archiver error
                                                              \n10288 Do not check block type in ktrget
                                                              \n10289 Do block dumps to trace file in hex rather than fromatted
                                                              \n10290 Kdnchk – checkvalid event – not for general purpose use.
                                                              \n10291 Die in tbsdrv to test controlfile undo
                                                              \n10292 Dump uet entries on a 1561 from dtsdrv
                                                              \n10293 Dump debugging information when doing block recovery
                                                              \n10294 Enable PERSISTENT DLM operations on non-compliant systems
                                                              \n10295 Die after file header update durning cf xact
                                                              \n10296 Disable ORA-379
                                                              \n10297 Customize dictionary object number cache
                                                              \n10298 Ksfd i\/o tracing
                                                              \n10299 Trace prefetch tracking decisions made by CKPT
                                                              \n10300 Disable undo compatibility check at database open
                                                              \n10301 Enable LCK timeout table consistency check
                                                              \n10302 Trace create or drop internal trigger
                                                              \n10303 Trace loading of library cache for internal triggers
                                                              \n10304 Trace replication trigger
                                                              \n10305 Trace updatable materialized view trigger
                                                              \n10306 Trace materialized view log trigger
                                                              \n10307 Trace RepCat execution
                                                              \n10308 Replication testing event
                                                              \n10309 Trigger Debug event
                                                              \n10310 Trace synchronous change table trigger
                                                              \n10311 Disable Flashback Table Timestamp checking
                                                              \n10312 Allow disable to log rows into the mapping table
                                                              \n10319 Trace PGA statistics maintenance
                                                              \n10320 Enable data layer (kdtgrs) tracing of space management calls
                                                              \n10321 Datafile header verification debug failure.
                                                              \n10323 Before committing an add datafile command
                                                              \n10324 Enable better checking of redo logs errors
                                                              \n10325 Trace control file record section expand and shrink operations
                                                              \n10326 Clear logfile debug crash at %s, log %s
                                                              \n10327 Simulate ORA-00235 error for testing
                                                              \n10328 Disable first-to-mount split-brain error, for testing
                                                              \n10329 Simulate lost write, test detection by two-pass recovery
                                                              \n10330 Clear MTTR statistics in checkpoint progress record
                                                              \n10331 Simulate resilvering during recovery
                                                              \n10332 Force ALTER SYSTEM QUIESCE RESTRICTED command to fail
                                                              \n10336 Do remote object transfer using remote SQL
                                                              \n10337 Enable padding owner name in slave sql
                                                              \n10340 Buffer queues sanity check for corrupted buffers
                                                              \n10341 Simulate out of PGA memory in DBWR during object reuse
                                                              \n10342 Raise unknown exception in ACQ_ADD when checkpointing
                                                              \n10343 Raise an out of memory exception-OER 4031 in ACQ_ADD
                                                              \n10344 Simulate kghxal returning 0 in ACQ_ADD but no exception
                                                              \n10345 Validate queue when linking or unlinking a buffer
                                                              \n10346 Check that all buffers for checkpoint have been written
                                                              \n10347 Dump active checkpoint entries and checkpoint buffers
                                                              \n10348 Test abnormal termination of process initiating file checkpoint
                                                              \n10349 Do not allow ckpt to complete
                                                              \n10350 Simulate more than one object & tsn id in object reuse
                                                              \n10351 Size of slots
                                                              \n10352 Report direct path statistics
                                                              \n10353 Number of slots
                                                              \n10354 Turn on direct read path for parallel query
                                                              \n10355 Turn on direct read path for scans
                                                              \n10356 Turn on hint usage for direct read
                                                              \n10357 Turn on debug information for direct path
                                                              \n10359 Turn off updates to control file for direct writes
                                                              \n10360 Enable dbwr consistency checking
                                                              \n10365 Turn on debug information for adaptive direct reads
                                                              \n10370 Parallel query server kill event
                                                              \n10371 Disable TQ hint
                                                              \n10372 Parallel query server kill event proc
                                                              \n10373 Parallel query server kill event
                                                              \n10374 Parallel query server interrupt (validate lock value)
                                                              \n10375 Turn on checks for statistics rollups
                                                              \n10376 Turn on table queue statistics
                                                              \n10377 Turn off load balancing
                                                              \n10378 Force hard process\/range affinity
                                                              \n10379 Direct read for rowid range scans (unimplemented)
                                                              \n10380 Kxfp latch cleanup testing event
                                                              \n10381 Kxfp latch cleanup testing event
                                                              \n10382 Parallel query server interrupt (reset)
                                                              \n10383 Auto parallelization testing event
                                                              \n10384 Parallel dataflow scheduler tracing
                                                              \n10385 Parallel table scan range sampling method
                                                              \n10386 Parallel SQL hash and range statistics
                                                              \n10387 Parallel query server interrupt (normal)
                                                              \n10388 Parallel query server interrupt (failure)
                                                              \n10389 Parallel query server interrupt (cleanup)
                                                              \n10390 Trace parallel query slave execution
                                                              \n10391 Trace PX granule allocation\/assignment
                                                              \n10392 Parallel query debugging bits
                                                              \n10393 Print parallel query statistics
                                                              \n10394 Generate a fake load to test adaptive and load balancing
                                                              \n10395 Adjust sample size for range table queues
                                                              \n10396 Circumvent range table queues for queries
                                                              \n10397 Suppress verbose parallel coordinator error reporting
                                                              \n10398 Enable timeouts in parallel query threads
                                                              \n10399 Trace buffer allocation
                                                              \n10400 Turn on system state dumps for shutdown debugging
                                                              \n10401 Turn on IPC (ksxp) debugging
                                                              \n10402 Turn on IPC (skgxp) debugging
                                                              \n10403 Fake CPU number for default degree of parallelism
                                                              \n10404 Crash dbwr after write
                                                              \n10405 Emulate broken mirrors
                                                              \n10406 Enable datetime TIMESTAMP, INTERVAL datatype creation
                                                              \n10407 Enable datetime TIME datatype creation
                                                              \n10408 Disable OLAP builtin window function usage
                                                              \n10410 Trigger simulated communications errors in KSXP
                                                              \n10411 Simulate errors in IMR
                                                              \n10412 Trigger simulated errors in CGS\/CM interface
                                                              \n10425 Enable global enqueue service open event trace
                                                              \n10426 Enable global enqueue service convert event trace
                                                              \n10427 Enable global enqueue service traffic controller event trace
                                                              \n10428 Enable tracing of global enqueue service distributed resource
                                                              \n10429 Enable tracing of global enqueue service IPC calls
                                                              \n10430 Enable tracing of global enqueue service AST calls
                                                              \n10431 Enable verification messages on pi consistency
                                                              \n10432 Enable tracing of global cache service fusion calls
                                                              \n10433 Global enqueue service testing event
                                                              \n10434 Enable tracing of global enqueue service muliple LMS
                                                              \n10435 Enable tracing of global enqueue service deadlock detetction
                                                              \n10450 Signal ctrl-c in kdddca (drop column) after n rows
                                                              \n10500 Turn on traces for SMON
                                                              \n10510 Turn off SMON check to offline pending offline rollback segment
                                                              \n10511 Turn off SMON check to cleanup undo dictionary
                                                              \n10512 Turn off SMON check to shrink rollback segments
                                                              \n10515 Turn on event to use physical cleanout
                                                              \n10550 Signal error during create as select\/create index after n rows
                                                              \n10560 Block type ‘%s’
                                                              \n10561 Block type ‘%s’, data object# %s
                                                              \n10562 Error occurred while applying redo to data block (file# %s, block# %s)
                                                              \n10563 Test recovery had to corrupt data block (file# %s, block# %s) in order to proceed
                                                              \n10564 Tablespace %s
                                                              \n10565 Another test recovery session is active
                                                              \n10566 Test recovery has used all the memory it can use
                                                              \n10567 Redo is inconsistent with data block (file# %s, block# %s)
                                                              \n10568 Failed to allocate recovery state object: out of SGA memory
                                                              \n10570 Test recovery complete
                                                              \n10571 Test recovery canceled
                                                              \n10572 Test recovery canceled due to errors
                                                              \n10573 Test recovery tested redo from change %s to %s
                                                              \n10574 Test recovery did not corrupt any data block
                                                              \n10575 Give up restoring recovered datafiles to consistent state: out of memory
                                                              \n10576 Give up restoring recovered datafiles to consistent state: some error occurred
                                                              \n10577 Can not invoke test recovery for managed standby database recovery
                                                              \n10578 Can not allow corruption for managed standby database recovery
                                                              \n10579 Can not modify control file during test recovery
                                                              \n10580 Can not modify datafile header during test recovery
                                                              \n10581 Can not modify redo log header during test recovery
                                                              \n10582 The control file is not a backup control file
                                                              \n10583 Can not recovery file %s renamed as missing during test recovery
                                                              \n10584 Can not invoke parallel recovery for test recovery
                                                              \n10585 Test recovery can not apply redo that may modify control file
                                                              \n10586 Test recovery had to corrupt 1 data block in order to proceed
                                                              \n10587 Invalid count for ALLOW n CORRUPTION option
                                                              \n10588 Can only allow 1 corruption for normal media\/standby recovery
                                                              \n10589 Test recovery had to corrupt %s data blocks in order to proceed
                                                              \n10590 Kga (argus debugger) test flags
                                                              \n10591 Kga (argus debugger) test flags
                                                              \n10592 Kga (argus debugger) test flags
                                                              \n10593 Kga (argus debugger) test flags
                                                              \n10594 Kga (argus debugger) test flags
                                                              \n10595 Kga (argus debugger) test flags
                                                              \n10596 Kga (argus debugger) test flags
                                                              \n10597 Kga (argus debugger) test flags
                                                              \n10598 Kga (argus debugger) test flags
                                                              \n10599 Kga (argus debugger) test flags
                                                              \n10600 Check cursor frame allocation
                                                              \n10601 Turn on debugging for cursor_sharing (literal replacement)
                                                              \n10602 Cause an access violation (for testing purposes)
                                                              \n10603 Cause an error to occur during truncate (for testing purposes)
                                                              \n10604 Trace parallel create index
                                                              \n10605 Enable parallel create index by default
                                                              \n10606 Trace parallel create index
                                                              \n10607 Trace index rowid partition scan
                                                              \n10608 Trace create bitmap index
                                                              \n10609 Trace for array index insertion
                                                              \n10610 Trace create index pseudo optimizer
                                                              \n10611 Causes migration to fail – testing only
                                                              \n10612 Prints debug information for auto-space managed segments
                                                              \n10613 Prints debug information for auto-space managed segments
                                                              \n10614 Operation not allowed on this segment
                                                              \n10615 Invalid tablespace type for temporary tablespace
                                                              \n10616 Operation not allowed on this tablespace
                                                              \n10617 Cannot create rollback segment in this tablespace
                                                              \n10618 Operation not allowed on this segment
                                                              \n10619 Avoid assertions when possible
                                                              \n10620 Operation not allowed on this segment
                                                              \n10621 Data block does not belong to the segment
                                                              \n10622 Test\/trace online index (re)build
                                                              \n10623 Enable Index range scan Prefetch – testing only
                                                              \n10650 Disable cache-callback optimisation
                                                              \n10651 Incorrect file number block number specified
                                                              \n10666 Do not get database enqueue name
                                                              \n10667 Cause sppst to check for valid process ids
                                                              \n10690 Set shadow process core file dump type (Unix only)
                                                              \n10691 Set background process core file type (Unix only)
                                                              \n10700 Alter access violation exception handler
                                                              \n10701 Dump direct loader index keys
                                                              \n10702 Enable histogram data generation
                                                              \n10703 Simulate process death during enqueue get
                                                              \n10704 Print out information about what enqueues are being obtained
                                                              \n10705 Print Out Tracing information for every I\/O done by ODSs
                                                              \n10706 Print out information about global enqueue manipulation
                                                              \n10707 Simulate process death for instance registration
                                                              \n10708 Print out Tracing information for skxf multi instance comms
                                                              \n10709 Enable parallel instances in create index by default
                                                              \n10710 Trace bitmap index access
                                                              \n10711 Trace bitmap index merge
                                                              \n10712 Trace bitmap index or
                                                              \n10713 Trace bitmap index and
                                                              \n10714 Trace bitmap index minus
                                                              \n10715 Trace bitmap index conversion to rowids
                                                              \n10716 Trace bitmap index compress\/decompress
                                                              \n10717 Trace bitmap index compaction trace for index creation
                                                              \n10718 Event to disable automatic compaction after index creation
                                                              \n10719 Trace bitmap index dml
                                                              \n10720 Trace db scheduling
                                                              \n10721 Internal testing – temp table transformation
                                                              \n10722 Set parameters for CPU frequency calculation (debug)
                                                              \n10723 Internal testing – release buffer for buffer cache shrink
                                                              \n10730 Trace row level security policy predicates
                                                              \n10731 Dump SQL for CURSOR expressions
                                                              \n10740 Disables fix for bug 598861
                                                              \n10750 Test rollback segment blksize guessing for index array insert
                                                              \n10800 Disable Smart Disk scan
                                                              \n10801 Enable Smart Disk trace
                                                              \n10802 Reserved for Smart Disk
                                                              \n10803 Write timing statistics on cluster database recovery scan
                                                              \n10804 Reserved for ksxb
                                                              \n10806 Switch to 7.3 mode when detaching sessions
                                                              \n10807 Disable user id check when switching to a global transaction
                                                              \n10810 Trace snapshot too old
                                                              \n10811 Trace block cleanouts
                                                              \n10812 Trace Consistent Reads
                                                              \n10830 Trace group by sort row source
                                                              \n10841 Default un-inintialized charact set form to SQLCS_IMPLICIT
                                                              \n10850 Enable time manager tracing
                                                              \n10851 Allow Drop command to drop queue tables
                                                              \n10852 Enable dumping of the AQ statistics hash table
                                                              \n10853 Event for AQ statistics latch cleanup testing
                                                              \n10856 Disable AQ propagator from using streaming
                                                              \n10857 Force AQ propagator to use two-phase commit
                                                              \n10858 Crash the AQ propagator at different stages of commit
                                                              \n10859 Disable updates of message retry count
                                                              \n10860 Event for AQ admin disable new name parser
                                                              \n10861 Disable storing extended message properties
                                                              \n10862 Resolve default queue owner to current user in enqueue\/dequeue
                                                              \n10900 Extent manager fault insertion event #%s
                                                              \n10902 Disable seghdr conversion for ro operation
                                                              \n10903 Force tablespaces to become locally managed
                                                              \n10904 Allow locally managed tablespaces to have user allocation
                                                              \n10905 Do cache verification (kcbcxx) on extent allocation
                                                              \n10906 Unable to extend segment after insert direct load
                                                              \n10907 Trace extent management events
                                                              \n10908 Trace temp tablespace events
                                                              \n10909 Trace free list events
                                                              \n10924 Import storage parse error ignore event
                                                              \n10925 Trace name context forever
                                                              \n10926 Trace name context forever
                                                              \n10927 Trace name context forever
                                                              \n10928 Trace name context forever
                                                              \n10929 Trace name context forever
                                                              \n10930 Trace name context forever
                                                              \n10931 Trace name context forever
                                                              \n10932 Trace name context forever
                                                              \n10933 Trace name context forever
                                                              \n10934 Reserved. Used only in version 7.x.
                                                              \n10935 Reserved. Used only in version 7.x.
                                                              \n10936 Trace name context forever
                                                              \n10937 Trace name context forever
                                                              \n10938 Trace name context forever
                                                              \n10939 Trace name context forever
                                                              \n10940 Trace name context forever
                                                              \n10941 Trace name context forever
                                                              \n10943 Trace name context forever
                                                              \n10944 Trace name context forever
                                                              \n10945 Trace name context forever
                                                              \n10975 Trace execution of parallel propagation
                                                              \n10976 Internal package related tracing
                                                              \n10977 Trace event for RepAPI
                                                              \n10979 Trace flags for join index implementation
                                                              \n10980 Prevent sharing of parsed query during Materialized View query generation
                                                              \n10981 Dscn computation-related event in replication
                                                              \n10982 Event to turn off CDC-format MV Logs
                                                              \n10983 Event to enable Create_Change_Table debugging
                                                              \n10984 Subquery materialized view-related event
                                                              \n10985 Event for NULL refresh of materialized views
                                                              \n10986 Do not use HASH_AJ in refresh
                                                              \n10987 Event for the support of caching table with object feature
                                                              \n10988 Event to get exclusive lock during materialized view refresh in IAS
                                                              \n10989 Event to internally create statistics MV
                                                              \n10999 Do not get database enqueue name
                                                              \n10999 End Pseudo-error debugging events<\/p>\n
                                                              ———————————-\u00a0\u4e8b\u4ef6\u7f16\u53f7\u548c\u5bf9\u5e94\u7684\u63cf\u8ff0\u00a0———————————-<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                                                              ALTER SYSTEM\/SESSION SET EVENTS \u8bed\u6cd5:alter system|session […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[34,8],"class_list":["post-421","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle","tag-performance"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/421","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=421"}],"version-history":[{"count":0,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/421\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=421"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}