Differences

This shows you the differences between two versions of the page.

--- performancetuning [2015/07/21 08:51] – z0hpvk
+++ performancetuning [2025/04/01 08:34] (current) – z0hpvk
@@ Line 1: / Line 1: @@
 ===== Performance Tuning =====
+==== Simple Explain Plan ====
+<code sql>EXPLAIN PLAN FOR SELECT * FROM dba_users;
+SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);
+</code>
 ==== Get Active Sessions ====
 <code>SET LINES 2000 TRIMSPOOL ON PAGES 10000