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
Next revision		Previous revision
performancetuning [2015/07/21 08:51] – z0hpvkperformancetuning [2025/04/01 08:34] (current) – z0hpvk
Line 1: Line 1:
 ===== Performance Tuning ===== ===== Performance Tuning =====
-=== Get Active Sessions ===+ 
 +==== 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 <code>SET LINES 2000 TRIMSPOOL ON PAGES 10000
 COLUMN EVENT FORMAT A30 COLUMN EVENT FORMAT A30
Line 25: Line 31:
 AND s.username LIKE UPPER('%&&usr%');</code> AND s.username LIKE UPPER('%&&usr%');</code>
  
-=== Get Query ===+==== Get Query ====
 <code>set lines 10000 trimspool on pages 0 feed off verify off <code>set lines 10000 trimspool on pages 0 feed off verify off
 set serverout on size 10000 set serverout on size 10000
Line 55: Line 61:
 SPOOL OFF</code> SPOOL OFF</code>
  
-=== Get Explain Plan ===+==== Get Explain Plan ====
 <code>SET LINES 2000 TRIMSPOOL ON PAGES 10000 <code>SET LINES 2000 TRIMSPOOL ON PAGES 10000
 SET SERVEROUT ON SIZE 1000000 SET SERVEROUT ON SIZE 1000000
performancetuning.1437468692.txt.gz · Last modified: 2025/03/08 22:23 (external edit)