• Home
  • About
All-round Database Topics
Nenad Noveljic
Menu Close
  • Home
  • About

Month: August 2020

OR-Expansion of Subqueries – Limitations

August 30, 2020Nenad Noveljic Leave a Comment

How to overcome the limitations of expansion of OR-subqueries in Oracle 19c. Continue Reading →

19c, cost based optimizer, OR-expansion, Oracle

Recent Posts

  • Performance Improvement on Dictionary Views in Oracle 21c
  • Bind Variable Length in PL/SQL, C, Java and Python
  • ORA-07445 [__intel_avx_rep_memcpy()] During a Rowset Operation
  • OCI Demo Linking Error
  • A Data Model Fix for Suboptimal Semi-Join and Anti-Join Cardinality Estimates
  • Undocumented Implicit Partition Statistics Gathering
  • Changing OSWatcher User
  • Troubleshooting TFA Start
  • Kernel Memory Leak due to ACFS Snapshots
  • slabinfo
  • Troubleshooting ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  • WINDOW SORT PUSHED RANK Performance Regression in Oracle 21c

Recent Comments

  • Revu on Performance Problem with Incremental Statistics Calculation
  • Ganesh CNS on Tracking Arguments with gdb
  • mohammad abdelqader on Performance Problem with Incremental Statistics Calculation
  • Nannette Leak on Fast Retrieval of DYNAMIC_SAMPLING_RESULT Information
  • Deadlock Detection | Oracle Scratchpad on Deadlock Caused by Row Cache and Library Cache Locks
  • vibha shrivastava on Undocumented Implicit Partition Statistics Gathering
  • Peter Prostredny on TNS-12599: TNS:cryptographic checksum mismatch
  • Wrh$: onlinestreet.de - iHunde on WRH$_SYSMETRIC_HISTORY_INDEX UNUSABLE After 18c Upgrade
  • Jörg on Perilous New Undocumented Tracing Feature in Oracle 21c
  • Nenad Noveljic on WINDOW SORT PUSHED RANK Performance Regression in Oracle 21c
  • Nenad Noveljic on Do You Know Your Object-Relational Mapper’s Overhead?
  • VuLe on Do You Know Your Object-Relational Mapper’s Overhead?

Categories

  • Chia (cryptocurrency) (3)
  • Comparison Oracle-SQL Server (11)
  • corruption (3)
  • cost based optimizer (46)
    • join predicate push-down (JPPD) (6)
    • OR-expansion (4)
    • sort (4)
  • data modelling (2)
  • encryption (5)
  • gdb (12)
  • Java (2)
  • JDBC (3)
  • latches (2)
  • linker (2)
  • Linux (9)
    • eBPF (8)
    • slab (2)
  • Math (2)
  • Oracle (127)
    • 12c (17)
      • 12.2 (7)
    • 18c (4)
    • 19c (11)
    • 21c (10)
    • adaptive query optimization (5)
    • Apex (2)
    • Avaloq (3)
    • Cloud Control (2)
    • Data Redaction (2)
    • datapatch (3)
    • fashback data archive (2)
    • library cache (4)
    • materialized view (2)
    • ORA-00600 (5)
    • ORA-07445 (2)
    • PGA (4)
    • PL/SQL (3)
    • redo (4)
    • RMAN (2)
    • TFA (2)
  • Perl (4)
  • slow parsing (4)
  • Solaris (26)
    • DTrace (24)
    • Emulex (5)
    • kmem_task (2)
  • SQL Server (22)
  • Statistics (7)
  • TCP/IP (4)
  • Uncategorized (3)

Archives

  • December 2023 (1)
  • October 2022 (2)
  • September 2022 (2)
  • August 2022 (1)
  • July 2022 (5)
  • June 2022 (5)
  • March 2022 (1)
  • February 2022 (3)
  • January 2022 (3)
  • November 2021 (2)
  • October 2021 (1)
  • September 2021 (2)
  • August 2021 (2)
  • July 2021 (3)
  • June 2021 (3)
  • May 2021 (3)
  • March 2021 (4)
  • February 2021 (1)
  • November 2020 (4)
  • October 2020 (3)
  • September 2020 (2)
  • August 2020 (1)
  • June 2020 (3)
  • May 2020 (2)
  • April 2020 (1)
  • March 2020 (1)
  • January 2020 (2)
  • December 2019 (3)
  • November 2019 (1)
  • October 2019 (3)
  • September 2019 (5)
  • August 2019 (2)
  • July 2019 (5)
  • May 2019 (1)
  • April 2019 (2)
  • March 2019 (3)
  • February 2019 (2)
  • January 2019 (1)
  • December 2018 (3)
  • November 2018 (1)
  • October 2018 (1)
  • September 2018 (4)
  • July 2018 (3)
  • June 2018 (3)
  • May 2018 (4)
  • April 2018 (1)
  • March 2018 (3)
  • February 2018 (3)
  • January 2018 (1)
  • December 2017 (2)
  • November 2017 (1)
  • October 2017 (1)
  • August 2017 (1)
  • May 2017 (3)
  • April 2017 (1)
  • March 2017 (2)
  • February 2017 (2)
  • January 2017 (1)
  • December 2016 (1)
  • November 2016 (2)
  • September 2016 (5)
  • August 2016 (1)
  • June 2016 (2)
  • May 2016 (1)
  • April 2016 (5)
  • March 2016 (1)
  • February 2016 (1)
  • January 2016 (3)
  • November 2015 (1)
  • October 2015 (2)
  • September 2015 (2)

Powered by WordPress with QuickLaTeX

© 2025 All-round Database Topics. All rights reserved.
Fashionista by aThemes