Carlos Sierra's Tools and Tips
Tools and Tips for Oracle Performance and SQL Tuning
Carlos Sierra
Working at the Oracle Cloud Infrastructure OCI. Living in Seattle, WA.
Disclaimer
Free Downloads
Pages
Slides
- Adapting and Adopting SQL Plan Management
- Online Index Rebuild Auromation
- SQL Tuning 101
- Understanding SQL Trace, TKPROF and Execution Plan for beginners
- Understanding my database through SQL*Plus using the free tool eDB360
- Survey of some free Tools
Recent Posts
- Query to get SQL_ID from DBA_SQL_PLAN_BASELINES
- Scripts to deal with SQL Plan Baselines, SQL Profiles and SQL Patches
- Introducing SQLdb360: merging eDB360 and SQLd360, while rising the bar to community engagement
- Adapting and adopting SQL Plan Management (SPM)
- Creating a SQL Plan Baseline from Cursor Cache or AWR
Leave a Reply