IT World

RDBMS, Unix and many more…

Home
About
Privacy

SQL Plan Management (SPM)

SQL Plan Management

Posted on December 22, 2011, updated on July 3, 2024 by Yannick Jaquier

Table of contents

Preamble
Testing
Testing with Adaptive Cursor Sharing (ACS)
Testing with SQL Profile
Link between sql_id and SQL Plan Baselines
Conclusion
References

Continue reading

Oracle Adaptive Cursor Sharing (ACS), SQL Plan Management (SPM), SQL Tuning Advisor (STA) 2 Comments

Search

Certifications

Tags Cloud

11gR2 (9) 12cR1 (6) Active Session History (ASH) (2) Adaptive Cursor Sharing (ACS) (2) Administration (40) Ambari (1) Application Continuity (AC) (1) Automatic Data Optimization (ADO) (1) Automatic Diagnostic Repository (ADR) (1) Automatic Memory Management (AMM) (2) Automatic Segment Space Management (ASSM) (1) Automatic Shared Memory Management (ASMM) (4) Automatic SQL Tuning Sets (ASTS) (1) Automatic Storage Management (ASM) (2) Automatic Workload Repository (AWR) (3) Backup (7) Benchmark (7) Bug (1) Cloud Control (2) cluster (1) Compression (3) Connection Manager (1) Container (4) Database Links (1) Database Resource Manager (DBRM) (3) Database Vault (2) Data Guard (7) Data Recovery Advisor (2) Data Redaction (1) DBMS_REDEFINITION (1) Development (10) Directory Naming (3) Docker (4) Edition-Based Redefinition (EBR) (1) Exadata (1) Fast Application Notification (FAN) (1) Fast Connection Failover (FCF) (1) Fast Recovery Area (FRA) (1) Fine-Grained Access Control (FGAC) (1) Flashback (1) Galera (3) GATHER_STATS_JOB (1) GoldenGate (6) Grid Control (4) Grub (1) Health Monitor (2) Heat Map (1) High Availability (34) HP Integrity Virtual Machines (HPVM) (1) Huge Pages (2) In-Memory (1) Information Lifecycle Management (ILM) (1) InnoDB (2) Instance Caging (1) JSON (1) Machine Learning (1) Multi-Master Replication Manager (MMM) (1) Multitenant (3) Non-Uniform Memory Access (NUMA) (3) OpenStack (2) OpenView Performance Agent (OVPA) (1) Oracle Configuration Manager (OCM) (1) Oracle Label Security (OLS) (1) oradebug (1) Patch (2) PL/SQL (1) Polymorphic Table Functions (PTF) (1) Privilege Analysis (1) Process Resource Management (PRM) (2) Program Global Area (PGA) (1) Real Application Clusters (RAC) (5) Real Application Testing (RAT) (2) Recovery (2) Redo Log (2) Resource Governor (1) RMAN (5) Security (27) Segment Advisor (2) Single Client Access Name (SCAN) (1) Spark (1) SQL (34) SQL*Net (3) SQL*Plus (1) SQL Access Advisor (SAA) (2) SQL Monitoring (2) SQL Performance Analyzer (SPA) (1) SQL Plan Management (SPM) (1) SQL Profile (1) SQL Trace (1) SQL Tuning Advisor (STA) (5) SQL Tuning Set (STS) (1) Streams (3) System Global Area (SGA) (1) Tivoli Data Protection for Oracle (TDPO) (2) Tivoli Storage Manager (TSM) (1) Transaction Guard (TG) (1) Transparent Application Failover (TAF) (1) Transparent Data Encryption (TDE) (1) Tuning (50) Virtualization (2) Virtual Memory (2) Virtual Private Database (VPD) (2) VxDMP (1) VxFS (1) VxVM (1)

Categories

AIX (2)
Couchbase (2)
Databricks (5)
Hadoop (21)
HPUX (6)
Linux (30)
MariaDB (17)
mongoDB (1)
MySQL (27)
Oracle (150)
PostgreSQL (8)
Python (3)
SQL Server (10)

Recent Comments

Automatic SQL Tuning Sets (ASTS) hidden feature hands-on on SQL Plan Management
GoldenGate for Big Data and Kafka Handlers hands-on - part 2 on GoldenGate for Big Data and Kafka Handlers hands-on – part 1
GoldenGate for Big Data and Kafka Handlers hands-on - part 1 on GoldenGate for Big Data and Kafka Handlers hands-on – part 2
Yannick Jaquier on DBMS_SQLTUNE concrete example
ulises Lazarini on DBMS_SQLTUNE concrete example

Blogroll

Ask Tom
Kevin Closson’s Oracle Blog
Official Pythian Blog
Oracle Optimizer
Oracle Scratchpad
Percona Database Performance Blog
Richard Foote’s Oracle Blog
Tanel Poder's blog

Visitors

Meta

Log in
Entries feed
Comments feed
WordPress.org

IT World Proudly powered by WordPress