Oracle ACE Associate
Joined January 2022
- Tweets 2,123
- Following 226
- Followers 71
- Likes 3,370
33 Photos and videos
Pinned Tweet
1 Jun 2025
โ๐ฅ 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
11 Mar 2025
๐ 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!
aioug.org/ocyatra/2025
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
2
6
186
ganmuru retweeted
Apr 30
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
blogs.oracle.com/coretec/oraโฆ
(I'm working on something new & related too ;-)
1
7
25
1,310
ganmuru retweeted
Apr 10
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" :-)
1
1
8
591
ganmuru retweeted
Apr 10
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!
tanelpoder.com/posts/oracle-โฆ
1
4
17
1,053
ganmuru retweeted
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? ๐
1
4
24
2,027
ganmuru retweeted
Mar 13
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.
tanelpoder.com/posts/reasonsโฆ
1
7
51
4,327
ganmuru retweeted
Mar 24
Old but gold! (2025)
Find which Oracle SQL_ID hits the SQL*Net break/reset to client event:
tanelpoder.com/posts/find-whโฆ
3
7
738
ganmuru retweeted
3 Nov 2025
New blog: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates)
tanelpoder.com/posts/xb-sql-โฆ
1
7
20
2,752
ganmuru retweeted
31 Oct 2025
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:
tanelpoder.com/seminar/
22 Oct 2025
Announcing my new Oracle Optimizer, Partitioning and I/O-Intensive Database Handling Deep Dive Training!
If you run serious Oracle workloads on-premises or in the cloud and want to learn some practical *and* new things this year, this is it!
tanelpoder.com/posts/new-oraโฆ
4
12
1,867
ganmuru retweeted
20 Oct 2025
tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates
tanelpoder.com/posts/tabhistโฆ
7
15
1,220
ganmuru retweeted
8 Oct 2025
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
2
6
131
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
blog.go-faster.co.uk/2025/09โฆ
10
21
906
ganmuru retweeted
27 Aug 2025
Linux Storage Stack Diagram (up to kernel v6.16) published:
thomas-krenn.com/en/wiki/Linโฆ
2
43
260
14,818
ganmuru retweeted
26 Sep 2025
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
2
3
133
ganmuru retweeted
9 Sep 2025
Link to my blog announcement here:
tanelpoder.com/posts/xcapturโฆ
2
7
711
ganmuru retweeted
9 Sep 2025
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 :-)
1
6
20
4,026
ganmuru retweeted
16 Sep 2025
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 ๐
tanelpoder.com/posts/optimizโฆ
12
44
2,153
ganmuru retweeted
25 Jul 2025
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:
oracle.com/cloud/free/
3
5
34
1,855
ganmuru retweeted
21 Jul 2025
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.
youtu.be/1LMe6QHFFpM
7
17
1,370
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 youtube.com/watch?v=HwsRpaW9โฆ
11
27
2,910
Oracle Database has added many #SQL features in each RU for 23ai
@GeraldVenzl runs through what's new in 23.7
TIME_BUCKET Function
Materialized columns
DBMS_DEVELOPER.GET_METADATA
Call PL/SQL from JavaScript stored procedures
Smallfile Tablespace Shrink
geraldonit.com/whats-new-forโฆ
1
15
40
1,775