Scripts from Oracle Presentations that I have given
All scripts or code in this repository is use at your own risk. Everything here is intended for test or lab type use.
DB Community of Interest - September 17, 2024 - Oracle Tuning Tips, My best developer tuning tips
/tune-tips-DBCoI
ASCEND - June 20, 2024 - Deep dive into SQL tuning (with EBS)
/deep-dive-sql-ASCEND
ORAPUB Members session - May 2, 2024 - FAST! How to setup networking in OCI
/oci-net-ORAPUB
UTOUG Training Days - March 21, 2024 - Deep dive into SQL tuning
/deep-dive-sql-UTOUG
ORPUB Members session - February 22, 2024 - SQL Tuning How does cardinality work?
/cardinality-sql-tune-ORAPUB
Oracle Database Tech Day Tour Florida - January 9-11, 2024 - "Tune that SQL", now what do I do?
/tune-that-SQL_SCOUG
Michigan Oracle User Summit - October 25, 2023 - "Tune that SQL", now what do I do?
/tune-that-SQL-mous
Milwaukee Technology Day - October 19, 2023 - "Tune that SQL", now what do I do?
/tune-that-SQL-MKE
BLUEPRINT4D 2023 - May 9,2023 - Oracle SQL Plan Management (SPM) your imperative performance tool
/spm-BP4D
BLUEPRINT4D 2023 - May 10, 2023 - Oracle Tuning Tips, My best developer tuning tips
/tune-tips-BP4D
UTOUG Training Days 2023 - Mar 7, 2023 - Oracle Tuning Tips, My best developer tuning tips
/tune-tips-UTOUG
UTOUG Training Days 2023 - Mar 8, 2023 - Oracle SQL Plan Management (SPM) your imperative performance tool
/spm-UTOUG
UTOUG Performance Technology Day - Mar 6, 2023 - Oracle SQL Profiles – In Depth
/sql-profiles-SLC
RMOUG Training Days 2023 - Feb 17, 2023 - Oracle SQL Profiles – In Depth
/sql-profiles-RMOUG
Tampa Performanc Technology Day - Jan 18, 2023 - Oracle Tuning Tips, My best developer tuning tips.
/tune-tips-TPA
Viscosity North America Webinar - Nov 15, 2022 - Oracle SQL Plan Management (SPM) Your imperative performance tool
/spm-VNA
Quest Database & Technology week - Nov 14, 2022 - Oracle Tuning Tips, My best developer tuning tips.
/tune-tips-DBT
OATUG Michigan Oracle Users Summit (MOUS) - Oct 26, 2022 - "Tune That SQL", Now what do I do?
/tune-that-SQL-MOUS
Midwest Oracle User Group (MOUG) - Sept 23, 2022 - Oracle Tuning Tips, My best developer tuning tips.
/tune-tips-MOUG
UTOUG Training Days - Sept 13, 2022 - Deep Dive into SQL Tuning
/indepth-SQL-UTOUG
UTOUG Training Days - Sept 12, 2022 - "Tune that SQL", Now what do I do?
/tune-that-SQL-UTOUG
NYOUG - May 19, 2022 - Oracle SQL Plan Management (SPM) Your imperative performance tool
/spm-NYOUG
GLOC - May 11, 2022 - "Tune that SQL", Now what do I do? (Cancled)
/tune-that-SQL-GLOC
GLOC - May 11, 2022 - Oracle Database CMU: Bringing AD into the DBAs Life (Cancled)
ECO - Feb 23, 2022 - Oracle Database CMU: Bringing AD into the DBAs Life
ECO - Feb 22, 2022 - Oracle Performance Tuning Workshop
/perflab-ECO
ORAPUB - Feb 16, 2022 - Oracle Performance Tuning Workshop
/perflab-ORAPUB
RMOUG - Feb 9, 2022 - Deep Dive into SQL Tuning
/indepth-sql-RMOUG
RMOUG - Feb 8, 2022 - "Tune that SQL", Now what do I do? *2
/tune-that-SQL-RMOUG
GTOUG - Jan 26, 2022 - Deep Dive into SQL Tuning *2
/indepth-sql-GTOUG
GTOUG - Jan 25, 2022 - "Tune that SQL", Now what do I do? *2
/tune-that-SQL-GTOUG
NOCOUG - Nov 19, 2020 - Oracle 19c performance tuning
/nocoug-perflab
MOUG - Oct 27, 2021 - Oracle SQL Plan Management (SPM) your imperative performance tool *1
/spm-MOUG
MOUG - Oct 26, 2021 - Deep Dive into SQL Tuning
/indepth-sql-MOUG
NYOUG - Sep 14, 2021 - Tune that SQL
/tune-that-SQL-NYOUG
QUEST - Aug 23, 2021 - Deep Dive into SQL Tuning
/indepth-sql-QUEST
RMOUG - May 19, 2021 - Deep Dive into SQL Tuning - expanded
/indepth-sql-RMOUG
INSYNC - Apr 1, 2021 - Oracle SQL Plan Management (SPM) Your imperative performance tool *
/spm-INSYNC
INSYNC - Mar 30, 2021 - Deep Dive into SQL Tuning
/indepth-sql-INSYNC
UTOUG - Mar 17, 2021 - Oracle SQL Plan Management (SPM) Your imperative performance tool *
/spm-UTOUG
RMOUG - Feb 10, 2021 - Oracle SQL Plan Management (SPM) Your imperative performance tool
/spm-RMOUG
Notes:
- Scripts have been updated to run all test steps as the perflab user by granting the needed privileges to use the DBMS_SPM package as well as ADDM.
- Scripts have been updated to work with a PDB as well as to run through docker with minimal setup.