DBA Tips for Developers

1. Sql Plam Management
   
   
   1. Baseline Plan of a SQL Query
   
   
   2. SQL Plan Baseline Example
   
   
   3. SQL Plan Baselines: Migration from one Instance to Another
   
   
2. Log Messages Missing from Concurrent Program Log File


3. Sql statements executed by a Concurrent Request


4. Trace File Size


5. Trace Option for Concurrent Program


6. Create Database Link


7. Runaway Sql Sessions


8. Query Being executed by Concurrent Program


9. ORA-01031: insufficient privileges


10. Composite Index with NULL Columns


11. Session(s) locking a pl/sql package


12. Seesion Information of a Concurrent Request


13. Oracle Procedure DBMS_SPACE.SPACE_USAGE


14. Identifying Locked Objects in Oracle Applications


15. Oracle Table Stats


16. All Indexes on a Table


17. Metalink Notes/White Papers and other links
    
    
    1. SQL Plan Management in Oracle Database 11g
    
    
    2. Sql Plan Management - By Arun Nanda
    
    
    3. ORA-01555: Snapshot too old - Error in Oracle. This link offers a good explanation.
    
    
    4. Semi-Join and Anti-Joins : This is a good article on the subject
    
    
    5. Oracle Database 10g Release 1 (10.1) New and Updated Features for Performance Tuning