DB Wiki

User Tools

Site Tools

Trace:
performancetuning

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
performancetuning [2025/03/08 22:24] – external edit 127.0.0.1performancetuning [2025/04/01 08:34] (current) – z0hpvk
Line 1: Line 1:
 ===== Performance Tuning ===== ===== Performance Tuning =====
 +
 +==== Simple Explain Plan ====
 +<code sql>EXPLAIN PLAN FOR SELECT * FROM dba_users;
 +SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);
 +</code>
 +
 ==== Get Active Sessions ==== ==== Get Active Sessions ====
 <code>SET LINES 2000 TRIMSPOOL ON PAGES 10000 <code>SET LINES 2000 TRIMSPOOL ON PAGES 10000
performancetuning.txt · Last modified: 2025/04/01 08:34 by z0hpvk