Oracle Tips

1. In and Exists
2. rman snippet
3. rman Backup&Restore
4. RMAN Clone Instance
5. PX Deq Credit:send blkd

SELECT t.SQL_TEXT
  FROM V$SESSION s, V$SQLAREA t, V$STREAMS_APPLY_SERVER a
  WHERE a.APPLY_NAME = 'STRM01_APPLY' AND a.SERVER_ID = 2
    AND s.SID = a.SID
    AND s.SQL_ADDRESS = t.ADDRESS
    AND s.SQL_HASH_VALUE = t.HASH_VALUE;

1. Find Lock Objects
2. Tune SGA&PGAburlonson,eygle,asktom

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE tempts2;
ALTER SYSTEM KILL SESSION '7,15';
SELECT SQL_TEXT, SADDR 
    FROM V$SQLAREA,V$SESSION
    WHERE V$SQLAREA.ADDRESS = V$SESSION.SQL_ADDRESS    
        AND SQL_TEXT LIKE 'alter tablespace%';