pm.sql | cs_planm.sql - Execution Plans in Memory for a given SQL_ID
ph.sql | cs_planh.sql - Execution Plans in AWR for a given SQL_ID
dc.sql - Display Cursor Execution Plan. Execute this script after one SQL for which you want to see the Execution Plan
dp.sql - Display Plan Table Explain Plan. Execute this script after one EXPLAIN PLAN FOR for a SQL for which you want to see the Explain Plan
cs_sqltext.sql - SQL Text for a given SQL_ID
cs_sqlmon_hist.sql - SQL Monitor Report for a given SQL_ID (from AWR)
cs_sqlmon_mem.sql - SQL Monitor Report for a given SQL_ID (from MEM)
cs_sqlmon_duration_chart.sql - SQL Monitor Reports duration for a given SQL_ID (time series chart)
cs_sqlmon_capture.sql - Generate SQL Monitor Reports for given SQL_ID for a short period of time
cs_sqlmon_binds.sql - SQL Monitor Binds for given SQL_ID
cs_sqlmon_top_binds.sql - SQL Monitor Top Binds for given SQL_ID
cs_sql_bind_capture.sql - SQL Bind Capture for given SQL_ID
cs_binds.sql - Binds for a given SQL_ID
cs_sql_sessions.sql - Recent and Active Sessions executing a SQL_ID
cs_sql_perf_concurrency.sql - Concurrency Histogram of SQL with more than N Concurrent Sessions
cs_sql_perf_high_aas.sql - SQL with AAS per hour for a given Timed Event higher than N (time series text report)
cs_purge_cursor.sql - Purge Cursor(s) for SQL_ID using DBMS_SHARED_POOL.PURGE and SQL Patch
SPBL - SQL Plan Baselines
cs_spbl_create.sql - Create a SQL Plan Baseline for given SQL_ID
cs_spbl_drop.sql - Drop one or all SQL Plan Baselines for given SQL_ID
cs_spbl_drop_all.sql - Drop all SQL Plan Baselines for some SQL Text string on PDB
cs_spbl_sprf_spch_drop_all.sql - Drop all SQL Plan Baselines, SQL Profiles and SQL Patches for some SQL Text string on PDB
cs_spbl_list.sql - Summary list of SQL Plan Baselines for given SQL_ID
cs_spbl_list_all.sql - List all SQL Plan Baselines for some SQL Text string on PDB
cs_spbl_sprf_spch_list_all.sql - List all SQL Plan Baselines, SQL Profiles and SQL Patches for some SQL Text string on PDB
cs_spbl_plan.sql - Display SQL Plan Baseline for given SQL_ID
cs_spbl_enable.sql - Enable one or all SQL Plan Baselines for given SQL_ID
cs_spbl_disable.sql - Disable one or all SQL Plan Baselines for given SQL_ID
cs_spbl_accept.sql - Accept one or all SQL Plan Baselines for given SQL_ID
cs_spbl_fix.sql - Fix one or all SQL Plan Baselines for given SQL_ID
cs_spbl_unfix.sql - Unfix one or all SQL Plan Baselines for given SQL_ID
cs_spbl_stgtab.sql - Creates Staging Table for SQL Plan Baselines
cs_spbl_stgtab_delete.sql - Deletes Staging Table for SQL Plan Baselines
cs_spbl_pack.sql - Packs into staging table one or all SQL Plan Baselines for given SQL_ID
cs_spbl_unpack.sql - Unpacks from staging table one or all SQL Plan Baselines for given SQL_ID
cs_spbl_expdp.sql - Packs into staging table one or all SQL Plan Baselines for given SQL_ID and Exports such Baselines using Datapump
cs_spbl_impdp.sql - Imports from Datapump file into a staging table all SQL Plan Baselines and Unpacks from staging table one or all SQL Plan Baselines for given SQL
cs_spbl_meta.sql - SQL Plan Baseline Metadata for given SQL_ID
cs_spbl_indexes.sql - List of Indexes Referenced by all SQL Plan Baselines on PDB
cs_spbl_failed.sql - List of SQL Plans with: "Failed to use SQL plan baseline for this statement"
cs_spbl_corrupt.sql - List of Corrupt SQL Plans with: missing Plan Rows from sys.sqlobj$plan
cs_spbl_purge_outdated.sql - Purge Outdated SQL Plan Baselines
create_spb_from_awr - Create SQL Plan Baselin from AWR Plan (legacy script)
create_spb_from_cur - Create SQL Plan Baseline from SQL Cursor (legacy script)
spm_backup.sql - Create DATAPUMP backup of SQL Plan Management (SPM) Repository for one PDB
SPRF - SQL Profiles
cs_sprf_create.sql - Create a SQL Profile for given SQL_ID
cs_sprf_drop.sql - Drop all SQL Profiles for given SQL_ID
cs_sprf_drop_all.sql - Drop all SQL Profiles for some SQL Text string on PDB
cs_sprf_list.sql - Summary list of SQL Profiles for given SQL_ID
cs_sprf_list_all.sql - List all SQL Profiles for some SQL Text string on PDB
cs_sprf_plan.sql - Display SQL Profile Plan for given SQL_ID
cs_sprf_enable.sql - Enable one or all SQL Profiles for given SQL_ID
cs_sprf_disable.sql - Disable one or all SQL Profiles for given SQL_ID
cs_sprf_xfr.sql - Transfers a SQL Profile for given SQL_ID
cs_sprf_export.sql - Exports Execution Plans for some SQL_ID or all SQL in some PDBs, using SQL Profile(s)
cs_sprf_stgtab.sql - Creates Staging Table for SQL Profiles
cs_sprf_pack.sql - Packs into staging table one or all SQL Profiles for given SQL_ID
cs_sprf_unpack.sql - Unpack from staging table one or all SQL Profiles for given SQL_ID
cs_sprf_category.sql - Changes category for a SQL Profile for given SQL_ID
cs_sprf_indexes.sql - List of Indexes Referenced by all SQL Profiles on PDB
cs_sprf_verify_wf.sql - Verifies Current Execution Plan for some KIEV WF SQL in all PDBs
cs_sprf_verify_wf_flash.sql - Verifies Current Execution Plan for some KIEV WF SQL in all PDBs (flash version)
cs_sprf_implement_wf.sql - Implements (imports) Execution Plans for some KIEV WF SQL in some PDBs, using SQL Profile(s)
coe_xfr_sql_profile.sql - Transfer (copy) a SQL Profile from PDBx on CDBa into PDBy on CDBb (legacy script)
SPCH - SQL Patches
cs_spch_first_rows.sql - Create a SQL Patch with FIRST_ROWS for given SQL_ID, and drops SQL Profile and SQL Plan Baselines
cs_spch_scan_create.sql - Create a SQL Patch for slow KIEV performScanQuery without Baselines, Profiles and Patches
cs_spch_create.sql - Create a SQL Patch for given SQL_ID
cs_spch_drop.sql - Drop all SQL Patches for given SQL_ID
cs_spch_drop_all.sql - Drop all SQL Patches for some SQL Text string on PDB
cs_spch_list.sql - Summary list of SQL Patches for given SQL_ID
cs_spch_list_all.sql - List all SQL Patches for some SQL Text string on PDB
cs_spch_plan.sql - Display SQL Patch Plan for given SQL_ID
cs_spch_enable.sql - Enable one or all SQL Patches for given SQL_ID
cs_spch_disable.sql - Disable one or all SQL Patches for given SQL_ID
cs_spch_stgtab.sql - Creates Staging Table for SQL Patches
cs_spch_pack.sql - Packs into staging table one or all SQL Patches for given SQL_ID
cs_spch_unpack.sql - Unpack from staging table one or all SQL Patches for given SQL_ID
cs_spch_xfr.sql - Transfers a SQL Patch for given SQL_ID
cs_spch_category.sql - Changes category for a SQL Patch for given SQL_ID
Sessions
a.sql | as.sql | cs_active_sessions.sql - Active Sessions including SQL Text and Exection Plan
am.sql | cs_ash_mem_sample_report.sql - ASH Samples from MEM
ah.sql | cs_ash_awr_sample_report.sql - ASH Samples from AWR
ahs.sql | cs_ash_snap_sample_report.sql - ASH Samples from iod_active_session_history Snapshot
cs_ash_awr_block_chains_report.sql - ASH Block Chains Report from AWR
cs_ash_mem_block_chains_report.sql - ASH Block Chains Report from MEM
cs_ash_awr_peaks_report.sql - ASH Peaks Report from AWR
cs_ash_mem_peaks_report.sql - ASH Peaks Report from MEM
cs_ash_awr_peaks_chart.sql - ASH Peaks Chart from AWR
cs_ash_mem_peaks_chart.sql - ASH Peaks Chart from MEM
cs_ash_awr_peaks_bubble.sql - ASH Peaks Bubble from AWR
cs_ash_mem_peaks_bubble.sql - ASH Peaks Bubble from MEM
cs_sessions.sql - Simple list all current Sessions (all types and all statuses)
cs_sessions_hist.sql - Simple list all historical Sessions (all types and all statuses)
cs_sessions_PCTL_by_machine.sql - Sessions Percentiles by Machine
cs_sessions_by_type_and_status_chart.sql - Sessions by Type and Status (time series chart)
cs_sessions_by_machine_chart.sql - Sessions by Machine (time series chart)
cs_sessions_age_by_machine_chart.sql - Session Age by Machine (time series chart)
cs_sessions_by_pdb_chart.sql - Sessions by PDB (time series chart)
cs_sess_mon.sql - Monitored Sessions
mysid.sql - Get SID and SPID of own Session
open_cursor.sql - Open Cursors and Count of Distinct SQL_ID per Session
session_undo.sql - Displays undo information on relevant database sessions (by Tim Hall)
Kill Sessions
cs_kill_sid.sql - Kill one User Session
cs_kill_sql_id.sql - Kill User Sessions executing some SQL_ID
cs_kill_root_blockers.sql - Kill Root Blocker User Sessions
cs_kill_machine.sql - Kill User Sessions connected from some Machine(s)
cs_kill_scheduler.sql - Kill User Sessions waiting on Scheduler (Resource Manager)