ganmuru

Oracle ACE Associate

[ganmuru @wolfbluelogan]

“🔥 Can’t wait for #OCYatra25 — the biggest Oracle community event is back! to India. Full details 👇”@AIOUG @oracleace @Oracle @Oracle_India @OracleCloud @TanelPoder @sai_penumuru @MikeDietrichDE @connor_mc_d @KerryOracleGuy

[All India Oracle Users Group (AIOUG) @AIOUG]

🚀 Oracle Community Yatra 2025 is Coming to a City Near You! 🌍🎤

Get ready for an incredible journey of learning, networking, and innovation! Oracle Community Yatra 2025 is set to bring top Oracle experts, real-world insights, and cutting-edge technology discussions to cities across the region.

📅 Book your calendars!

🔔 Watch this space for exciting announcements!
https://t.co/YdOCxibzDG

Join us as we explore the latest in Oracle Cloud, Database, Multicloud, AI, and more! Don't miss this opportunity to connect with industry leaders, grow your knowledge, and be part of the Oracle community like never before.

@Oracle @oracleugs @oracleace @OracleDevs @oracledevcomm @OracleDatabase @OracleCloud @googlecloud @awscloud @Azure
#aioug #OCYatra25 #Oracle #Community #CloudCommunity #TechConference #OracleCommunity #TechYatra

[Tanel Poder 🇺🇦 @TanelPoder]

A pretty recent summary article from Oracle on enabling and getting SQL monitoring reports in various ways (including historical captures):

Real-Time SQL Monitoring: a MUST for SQL Tuning

https://t.co/S749xeCO4U

(I'm working on something new & related too ;-)

[Tanel Poder 🇺🇦 @TanelPoder]

New blog: "Get Oracle Partition High Values as VARCHAR2 types instead of LONG in Oracle 19c and earlier"

There's also some SQL "performance trap" advice & data 23/26ai data dictionary internals in there.

Link in comments (testing if it changes "reach" :-)

[Tanel Poder 🇺🇦 @TanelPoder]

Get Oracle Partition High Values as VARCHAR2 types instead of LONG in Oracle 19c and earlier (new blog).

There's also some data 23/26ai data dictionary internals!

https://t.co/PIkyCLc4gJ

[Tanel Poder 🇺🇦 @TanelPoder]

I wrote an Oracle "ash_index_helper.sql" script 5 yrs ago, trying to pull all relevant info of top time-consuming *access paths* into one place, as a single SQL script.

Summarize access paths to a schema or just one table/SQL.

Too complex for a single script, time for AI? 😎

[Tanel Poder 🇺🇦 @TanelPoder]

Reasons why SELECT * is bad for SQL performance:

An old blog (with Oracle-specific examples) with a whole range of reasons why. It's not only about network traffic and SQL plan execution, but client side processing and memory usage as well.

https://t.co/6X5qhdpuFY

[Tanel Poder 🇺🇦 @TanelPoder]

Old but gold! (2025)

Find which Oracle SQL_ID hits the SQL*Net break/reset to client event:

https://t.co/L6xyn8AZhb

[Tanel Poder 🇺🇦 @TanelPoder]

New blog: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates)

https://t.co/UO1BKpTpHn

[Tanel Poder 🇺🇦 @TanelPoder]

The first deep dive in my new special-focus training series starts on Wednesday:

"Handling the Optimizer, Statistics and Workloads on Partitioned Tables in Oracle Databases" (5-6 Nov 2025 + Q&A followup sessions).

One demo table has 100k partitions ;-)

Sign up here:
https://t.co/NmwgHaFr4C

[Tanel Poder 🇺🇦 @TanelPoder]

tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates

https://t.co/jYbYpLXpMn

[Yuan Oracle ACE @YuanOracle]

Misconfigured control_file_record_keep_time=365 bloated the control file → RMAN vs LGWR contention on control file → log file sync spiked → RAC flooded with gc waits.
#oracle #oracleace #oracleaw

[SQL Daily @sqldaily]

Filter tables on their partition key to get partition pruning in Oracle #SQL

=> your query is more efficient

But with reference partitioning, this key is in the parent table!

@davidmkurtz shows how filtering these by foreign key enables pruning

https://t.co/V3OYZy1YFM

[Tanel Poder 🇺🇦 @TanelPoder]

Linux Storage Stack Diagram (up to kernel v6.16) published:

https://t.co/LyUzrENEDI

[Yuan Oracle ACE @YuanOracle]

parses 136/s + executes 226/s = 362, but user calls hit 4,133/s. The gap (≈3,771) comes from fetches—big result sets exceed arraysize, forcing multiple fetches. SQL*Net roundtrips confirm (≈3,968/s).
#oracle #oracleace #awr

[Tanel Poder 🇺🇦 @TanelPoder]

Link to my blog announcement here:

https://t.co/WEbwLl9OHn

[Tanel Poder 🇺🇦 @TanelPoder]

The xCapture and xtop eBPF tools are now in beta, with a demo dataset!

With a pre-recorded xcapture dataset from my dev server, now you can play with xtop "thread activity sampling" drilldown even on your laptop, without having to run xcapture yourself!

(link in replies :-)

[ganmuru @wolfbluelogan]

@TanelPoder 😀amazing and apt one and it suits reality.

[Tanel Poder 🇺🇦 @TanelPoder]

If you have eBPF "biolatency" style IO latency monitoring tools always-on, you might want to reduce its tracepoint CPU overhead by not storing IO start times in a shared hashtable at all.

In my results, 59x lower tracepoint CPU overhead at 37M IOPS 😎

https://t.co/wuQuTRILFG

[Tanel Poder 🇺🇦 @TanelPoder]

Didn't realize that Oracle Cloud now also offers AMD CPU-based (small) compute VMs under their "always free" offering, in addition to the ARM ones:

https://t.co/7ZgQcKyald

[Connor on SQL and Database @connor_mc_d]

Fresh video! Want to run MERGE in parallel for your massive partitioned tables? There is a little bit of nuance required to make sure you get the performance you want.
https://t.co/H8zZlKOZPV

[SQL Daily @sqldaily]

To find rows matching a #SQL query, the Oracle optimizer can use

ACCESS - get all of a subset of rows (usually via an index)
FILTER - check a set of rows, discarding unwanted data

But how does it pick which to use?

@connor_mc_d investigates https://t.co/5kCWSVNheG