ganmuru

2.1K posts

ganmuru banner
ganmuru

ganmuru

@wolfbluelogan

Oracle ACE Associate

Se unió Ocak 2022
227 Siguiendo73 Seguidores
Tweet fijado
ganmuru
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! 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

English
0
2
6
184
ganmuru retuiteado
Tanel Poder 🇺🇦
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 🇺🇦 tweet media
English
1
1
8
570
ganmuru retuiteado
Tanel Poder 🇺🇦
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! tanelpoder.com/posts/oracle-g…
Tanel Poder 🇺🇦 tweet media
English
1
4
17
1K
ganmuru retuiteado
Tanel Poder 🇺🇦
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 🇺🇦 tweet mediaTanel Poder 🇺🇦 tweet media
English
1
4
24
2K
ganmuru retuiteado
Tanel Poder 🇺🇦
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. tanelpoder.com/posts/reasons-…
Tanel Poder 🇺🇦 tweet media
English
1
7
50
4.3K
ganmuru retuiteado
Tanel Poder 🇺🇦
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: tanelpoder.com/seminar/
Tanel Poder 🇺🇦@TanelPoder

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-orac…

English
0
4
12
1.9K
ganmuru retuiteado
Yuan Oracle ACE
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
Yuan Oracle ACE tweet mediaYuan Oracle ACE tweet media
English
0
2
6
128
ganmuru retuiteado
SQL Daily
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 blog.go-faster.co.uk/2025/09/refpar…
English
0
10
21
903
ganmuru retuiteado
Yuan Oracle ACE
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
Yuan Oracle ACE tweet media
English
0
2
3
133
ganmuru retuiteado
Tanel Poder 🇺🇦
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 :-)
Tanel Poder 🇺🇦 tweet media
English
1
6
20
4K
ganmuru
ganmuru@wolfbluelogan·
@TanelPoder 😀amazing and apt one and it suits reality.
English
0
0
1
9
ganmuru retuiteado
Tanel Poder 🇺🇦
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 😎 tanelpoder.com/posts/optimizi…
Tanel Poder 🇺🇦 tweet media
English
0
12
44
2.1K
ganmuru retuiteado
Tanel Poder 🇺🇦
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: oracle.com/cloud/free/
Tanel Poder 🇺🇦 tweet media
English
3
5
34
1.9K
ganmuru retuiteado
Connor on SQL and Database
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. youtu.be/1LMe6QHFFpM
YouTube video
YouTube
English
0
7
17
1.4K
ganmuru retuiteado
SQL Daily
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 youtube.com/watch?v=HwsRpa…
YouTube video
YouTube
English
0
11
27
2.9K
SQL Daily
SQL Daily@sqldaily·
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-…
English
1
15
40
1.8K

Descubrir

@davidmkurtz @TanelPoder @connor_mc_d @elonmusk @BarackObama @taylorswift13 @cristiano @BillGates