Free cookie consent management tool by TermsFeed

IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

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

SQL Performance Analyzer

Posted on November 29, 2011, updated on August 7, 2015 by Yannick Jaquier

Table of contents

  • Preamble
  • SQL Performance Analyzer testing
  • SQL Performance Analyzer result
  • References

Continue reading

Oracle SQL Performance Analyzer (SPA) 2 Comments

Compression Advisor

Posted on November 11, 2011, updated on August 7, 2015 by Yannick Jaquier

Table of contents

  • Preamble
  • Compression Advisor with DBMS_COMPRESSION
  • Compression Advisor with DBMS_ADVISOR

Continue reading

Oracle Compression 4 Comments

PDF Signature

Posted on November 10, 2011, updated on July 1, 2020 by Yannick Jaquier

Table of contents

  • Preamble
  • Certificate generation
  • PDF Creator configuration
  • PDF signature result
  • References

Continue reading

Linux Leave a comment

Segment Advisor

Posted on November 3, 2011, updated on June 16, 2016 by Yannick Jaquier

Table of contents

  • Preamble
  • Segment Advisor task
  • Result
  • References

Continue reading

Oracle Segment Advisor 3 Comments

SQL Access Advisor versus SQL Tuning Advisor

Posted on October 28, 2011, updated on May 28, 2019 by Yannick Jaquier

Table of contents

  • Preamble
  • SQL Access Advisor
  • SQL Tuning Set
  • Workload and task
  • Result
  • SQL Tuning Advisor
  • Task
  • Result
  • Conclusion
  • References

Continue reading

Oracle SQL Access Advisor (SAA), SQL Tuning Advisor (STA), SQL Tuning Set (STS) 6 Comments
  • Page 33 of 43
  • « First
  • ‹ Previous
  • 31
  • 32
  • 33(current)
  • 34
  • 35
  • Next ›
  • Last »

Search

Certifications

Oracle Certified Master (OCM) Oracle Certified Professional (OCP) Oracle Certified Associate (OCA)
Microsoft Azure Fundamentals Microsoft Azure Solutions Architect Expert

Tags Cloud

11gR2 (9) 12cR1 (6) Active Session History (ASH) (2) Adaptive Cursor Sharing (ACS) (2) Administration (42) 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 Migration Assistant for Unicode (DMU) (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) Kafka (2) 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 (35) 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 (53) 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 (20)
  • mongoDB (1)
  • MySQL (30)
  • Oracle (150)
  • PostgreSQL (8)
  • Python (3)
  • SQL Server (10)

Recent Comments

  • Performance schema hands-on - part 1 on Performance schema hands-on – part 2
  • GoldenGate for Big Data and Kafka Handlers hands-on - part 1 on GoldenGate 12c (12.2) installation and configuration
  • Performance schema hands-on - part 2 on Performance schema hands-on – part 1
  • sai sumanth on SQL Server on Linux – Availability Groups – part 3
  • sai sumanth on SQL Server on Linux – Availability Groups – part 3

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