Event 10710 - Trace Bitmap Index Access 跟蹤位圖索引的訪問情況 ALTER SESSION SET EVENTS '10710 trace name context forever, level 1'; Event 10711 - Trace Bitmap Index Merge Operation 跟蹤位圖索引合并操作 ALTER SESSION SET EVENTS '10711 trace name context forever, level 1'; Event 10712 - Trace Bitmap Index OR Operation 跟蹤位圖索引或操作情況 ALTER SESSION SET EVENTS '10712 trace name context forever, level 1'; Event 10713 - Trace Bitmap Index AND Operation 跟蹤位圖索引與操作 ALTER SESSION SET EVENTS '10713 trace name context forever, level 1'; Event 10714 - Trace Bitmap Index MINUS Operation 跟蹤位圖索引minus操作 ALTER SESSION SET EVENTS '10714 trace name context forever, level 1'; Event 10715 - Trace Bitmap Index Conversion to ROWIDs Operation 跟蹤位圖索引轉換ROWID操作 ALTER SESSION SET EVENTS '10715 trace name context forever, level 1'; Event 10716 - Trace Bitmap Index Compress/Decompress 跟蹤位圖索引壓縮和解壓縮情況 ALTER SESSION SET EVENTS '10716 trace name context forever, level 1'; Event 10717 - Trace Bitmap Index Compaction ALTER SESSION SET EVENTS '10717 trace name context forever, level 1'; Event 10719 - Trace Bitmap Index DML 跟蹤位圖索引列的DML操作（引起位圖索引改變的DML操作） ALTER SESSION SET EVENTS '10719 trace name context forever, level 1'; Event 10730 - Trace Fine Grained Access Predicates 跟蹤細粒度審計的斷語 ALTER SESSION SET EVENTS '10730 trace name context forever, level 1'; Event 10731 - Trace CURSOR Statements 跟蹤CURSOR的語句情況 ALTER SESSION SET EVENTS '10731 trace name context forever, level level'; LEVEL定義 1 Print parent query and subquery 2 Print subquery only Event 10928 - Trace PL/SQL Execution 跟蹤PL/SQL執行情況 ALTER SESSION SET EVENTS '10928 trace name context forever, level 1'; Event 10938 - Dump PL/SQL Execution Statistics 跟蹤PL/SQL執行狀態。使用前需要執行rdbms/admin下的tracetab.sql ALTER SESSION SET EVENTS '10938 trace name context forever, level 1'; flush_cache 刷新BUFFER CACHE ALTER SESSION SET EVENTS 'immediate trace name flush_cache'; DROP_SEGMENTS 手工刪除臨時段。當這些臨時段無法自動清除的時候可以手工清除 alter session set events 'immediate trace name DROP_SEGMENTS level ts#+1'; ts#是指要刪除臨時段的表空間的ts# 《新程序員》：云原生和全面數字化實踐50位技術專家共同創作，文字、視頻、音頻交互閱讀

總結

以上是生活随笔為你收集整理的【Oracle】Oracle常用EVENT之三的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。