Timur Akhmadeev's Avatar

Timur Akhmadeev

@tmmdv

Oracle Apps Database Consultant at Pythian. Views are my personal opinion.

92
Followers
39
Following
92
Posts
29.10.2024
Joined
Posts Following

Latest posts by Timur Akhmadeev @tmmdv

Adaptive Scalable LGWR Mode Switch Threshold Single->Scalable Oracle fundamentally reworked and redesigned the LGWR architecture in 12c. In earlier versions, LGWR ran as a single process, whereas Oracle 12c and later can dynamically switch between a single LGWR ...

When does lgwr transition from single to scalable mode?

t.ly/Ohe7a

03.03.2026 10:55 πŸ‘ 2 πŸ” 3 πŸ’¬ 0 πŸ“Œ 0

There are many of those. Full build is pricey (because they use top components), unless you want everything to be ideal right from the start. I’d go with a Ti frame with a cheap groupset (Cues, Microshift), and rest of parts of well established Chinese brands. Swap groupset later to smth wireless

22.02.2026 15:00 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Have you looked at some custom Titanium bike manufacturers? Possibly ordering just a frame then building the rest as you wish

22.02.2026 11:43 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

After a decade of planning, editing, delays due to my own busyness, further editing and waiting for 23c, the release of 26ai and my pre-retirement finally unblocked the situation. I have agreed with Apress to publish the third edition of Troubleshooting Oracle Performance in 2026. #TOP3

14.02.2026 14:39 πŸ‘ 32 πŸ” 5 πŸ’¬ 7 πŸ“Œ 0

You prefer a quick zoom call then?

08.02.2026 10:30 πŸ‘ 3 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Multiple copies of your data is called β€œbackups”.

22.01.2026 11:52 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Keep saying β€œon premise” instead of β€œon premises”. It was in a keynote.

21.01.2026 16:14 πŸ‘ 6 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

That’s a lot of screens to watch cats

20.01.2026 11:18 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

I felt like taking a closer look at this new datapatch feature and ended up making some interesting discoveries πŸ™‚

t.ly/Tufob

12.01.2026 10:42 πŸ‘ 7 πŸ” 1 πŸ’¬ 1 πŸ“Œ 0
Post image

The new, improved, way to display less than 4KB of text on the shiny support.oracle.com

26.12.2025 10:33 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Are you talking about MOS? Should be renamed to Minimal Oracle Support now

24.12.2025 10:26 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Didn’t know @jolliffe.bsky.social is with long hair now!

20.12.2025 13:51 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

You can get a few stack traces eith oradebug short_stack then check function meaning at orafun.info and most likely find the relevant fix_control to disable

20.12.2025 13:49 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Why is it still not on your avatar?

09.12.2025 14:40 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

This is how your profile pic looks like in a Reading mode of Chrome on the phone - I find it quite funny considering the topic

09.12.2025 10:57 πŸ‘ 2 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

It may look okay (I doubt so), yet functionality is totally broken.

08.12.2025 12:49 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

It's not new to 26ai, but it's the first time we've described it in the docs. So if you're still thinking there's only an SGA and a PGA ... let me introduce you to the MGA
docs.oracle.com/en/database/...

04.12.2025 07:24 πŸ‘ 1 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

Actually, it would be a nice speakers gift. Without the beer, just a print.

24.11.2025 09:23 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

There are literally two people on the pic :) need a better picture

18.11.2025 20:11 πŸ‘ 4 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image

πŸ€¦β€β™‚οΈ- me every time keynote speaker says β€œon premise”. Three times so far.

18.11.2025 09:34 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Fully disagree. Returned a broken TV once. Zero questions asked, pick up from home in a few days, money returned quickly. Returns are something that Amazon excels at.

14.11.2025 09:26 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Post image

New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity (both from AWR and regular V$ views)

tanelpoder.com/posts/oracle...

10.11.2025 05:51 πŸ‘ 6 πŸ” 2 πŸ’¬ 0 πŸ“Œ 0
Post image

Added a blog update about the V$PROCESS_MEMORY_DETAIL auto-population for processes with PGA growth to over 500MB. Enabled in Oracle 19.18+, so no "oradebug dump pga_get_detail" needed, just query the V$ views for a detailed "heapdump":

tanelpoder.com/2014/03/26/o...

10.11.2025 06:29 πŸ‘ 9 πŸ” 3 πŸ’¬ 0 πŸ“Œ 0

As far as I remember it’s available via sql test case builder. Haven’t checked in a while.

28.10.2025 10:30 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Do not like that (also, the way to get the traces)

27.10.2025 10:03 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
The AI World 2025 mega download! We’ve all been there… You head over to the Session Catalog for AI World and you want to download the files for all of the sessions you have been to, and all of the sessions you have missed. Then yo…

Missed some sessions at @OracleAIWorld? Here's the 2025 mega download of session content. Enjoy!
connor-mcdonald.com/2025/10/21/t...

21.10.2025 23:21 πŸ‘ 7 πŸ” 3 πŸ’¬ 0 πŸ“Œ 0
Post image Post image

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

tanelpoder.com/posts/tabhis...

20.10.2025 13:59 πŸ‘ 4 πŸ” 3 πŸ’¬ 1 πŸ“Œ 0
SQL Tuning Guide Cursor sharing can improve database application performance by orders of magnitude.

Apparently Oracle Docs have embedded videos docs.oracle.com/en/database/...

14.10.2025 15:50 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Post image Post image

Any idea what the new (?) light blue color in the SQL Monitor reports mean? It's different between those displayed directly in the console, and the stored & opened ones. It looks as if it tries to show active steps, but does it incorrectly in the OCI console. 1 - in console, 2 - same rep stored

13.10.2025 14:01 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

One good thing with a MacOS is ability to use iPad as a second monitor.

13.10.2025 09:16 πŸ‘ 2 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0