BalaJimVic
balajimvic.bsky.social
BalaJimVic
@balajimvic.bsky.social
Oracle Performance Geek. Technology Lover.
Big Fan of Tanel Poder. Oracle ACE.
Reposted by BalaJimVic
Thank you for joining us yesterday for our April 2025 Oracle ACE Program Update Meeting! ♠️
We had an amazing guest speaker, Susan Behn, Oracle ACE Director, who shared insights about Turning Tough Talks into Productive Conversations.
#OracleACE
April 17, 2025 at 9:49 AM
Reposted by BalaJimVic
Small Pages not allowed for SGA from 19.27 and newer on Exadata

Having good friends in Oracle is key. And honestly one of the best things in my role. Philippe Fierens, product manager for Oracle's Fleet Patching and Provisioning mailed me yesterday night sharing that there an interesting change…
Small Pages not allowed for SGA from 19.27 and newer on Exadata
Having good friends in Oracle is key. And honestly one of the best things in my role. Philippe Fierens, product manager for Oracle's Fleet Patching and Provisioning mailed me yesterday night sharing that there an interesting change will come with Database Release Update 19.27: Small Pages not allowed for SGA from 19.27 and newer on Exadata. What does this mean?
mikedietrichde.com
April 17, 2025 at 9:00 AM
Reposted by BalaJimVic
Retro blog post. Session level parallelism. https://connor-mcdonald.com/2016/01/21/session-level-parallelism
April 12, 2025 at 6:08 PM
Reposted by BalaJimVic
From the vault. New LINESIZE settings for SQLPlus. https://connor-mcdonald.com/2020/01/31/sqlplus-goodies-with-linesize/
April 16, 2025 at 6:08 PM
Reposted by BalaJimVic
Are you also eager to patch your Oracle Database, now that the new Release Updates are here?

Let me show you the easiest way to get those patches so the fun can begin.
The Easiest Way to Download 19.27 Release Update
Let me show you the easiest way to get the latest Release Updates. Once you see this, you'll never download patches any other way.
dohdatabase.com
April 16, 2025 at 7:39 PM
Reposted by BalaJimVic
I'm not a "full stack" performance specialist as I'm not good with frontend stuff and JavaScript, but I deal with pretty much everything else (app-network interactions, databases, OS and underlying storage I/O).

So I guess I'll call myself a 3/4-stack performance nerd from now on...
January 11, 2025 at 2:56 AM
Reposted by BalaJimVic
Old blog from 2018, but still worth reading to remind that SQL plan execution is just program execution like any other:

tanelpoder.com/posts/visual...
January 4, 2025 at 1:54 AM
Reposted by BalaJimVic
New post: Adding Loop and Row Counters to SQL Plan Execution FlameGraphs

tanelpoder.com/posts/sql-pl...
January 4, 2025 at 12:04 PM
Reposted by BalaJimVic
Computers are networks! Even your CPUs are networks, but thats for another day... If you want some holiday reading about how I achieved 66GiB/s and 11M IOPS in a single workstation (back in 2020) and which bottlenecks I hit, check this out!

tanelpoder.com/posts/11m-io...
December 20, 2024 at 1:36 AM
Reposted by BalaJimVic
The result cache stores the results of database queries in memory for reuse, improving performance by reducing execution time for repeated queries.
arsalandehghanis.medium.com/tuning-the-r...
Tuning the Result Cache
This post explores how to optimize database performance by tuning the result cache.
arsalandehghanis.medium.com
December 22, 2024 at 5:22 PM
Reposted by BalaJimVic
♠️ We are happy to invite you to the first Oracle ACE Virtual Conference! Join us on December 11 and learn from amazing ACE speakers. 👉

Book your FREE spot now 👉
asktom.oracle.com/ords/r/tech/...
#OracleACE
December 5, 2024 at 6:21 PM
Reposted by BalaJimVic
♠️ Reminder for all ACEs ♠️

On November 26, we are hosting an Oracle ACE Program Product Overview presenting NoSQL Updates, where we are joined by Dario Vega, Principal Member of technical staff.
Looking forward to seeing you!
#OracleACE
November 25, 2024 at 9:17 AM
Reposted by BalaJimVic
Reposted by BalaJimVic
Can a User Process Consume Kernel Mode CPU Without a Syscall?

(yes)

tanelpoder.com/posts/user-p...
November 23, 2024 at 2:16 AM
Reposted by BalaJimVic
Great news… LiveSQL for the #oracle database was amazing. V2 is a big step forward with so much more to come.
November 19, 2024 at 7:31 AM
Reposted by BalaJimVic
Starting to occasionally post my recent blog entries here as the audience here might find some of them interesting!

"Visualizing and Comparing Vector Embeddings as Heatmaps"

tanelpoder.com/posts/visual...
October 31, 2024 at 10:15 PM
Reposted by BalaJimVic
Blog entry: Python Supports Profiling with Perf - How Does It Work?

(Python 3.12+ on Linux can emit perf .map files so that you can see Python function names in the binary stack trace!)

tanelpoder.com/posts/python...
October 31, 2024 at 10:30 PM
Reposted by BalaJimVic
Introducing myself here: My name is Tanel Põder (originally from Estonia, living in Miami) and I'm a long time computer performance nerd.

I work on and write about systematic performance troubleshooting. Also, I'm the guy behind 0x.tools that gives you things like "top for wall-clock time", etc.
X-Ray vision for Linux systems
Always on Profiling for Production Systems
0x.tools
October 31, 2024 at 10:10 PM