Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Follow

Carlos Sierra

Working at the Oracle Cloud Infrastructure OCI. Living in Seattle, WA.

Disclaimer

Email

Free Downloads

• SQLdb360 Latest Release
• eSP v1606
• cscripts v202101
• eAdam v1712

Pages

• SQLdb360
• eAdam

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

• ASH Analytics from SQL*Plus
• 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)