I've been busy in the last months!
Announcing a brand new "Practical Exadata Performance" training course!
I'm not aware of any other training *like this* offered in the world. 😎 Also, a *free* seminar!
Exadata is an awesome platform, if used right!
learn.tanelpoder.com
As I can't see any advantage to using this feature over SQL trace and active session history, especially given the limited number of monitored SQL statements. To make it useful, a much better implementation is needed.
We couldn't have done it without her.💐
There are several harvests per year. So, it depends ;-)
I fully agree, it's a very good one. Since it’s set in the region where I live, it comes up in conversation quite regularly.
youtube.com/watch?v=mD1g...
My favorites: #10 and #1.
But all are spot on.
Very good collection.
IMO it's even worse. Both things are true at the same time (lying and no clue). You can't believe anything he's saying. Ever.
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/reason...
Being prepared to improvise is essential during a presentation...
IMO that's good news!
Bitcoin mining is no longer profitable after crypto's latest downward turn, analyst says
www.cnbc.com/2026/02/24/b...
In this area you should also be aware of the difference between thin and tick driver...
github.com/oracle/pytho...
First of all, there are not many important contacts to notify (at least for most people you are referring to who are unable to own their own domain). You can notify them. Second, you don't disable your old address when you start using the new one. This gives you months to react to things you forgot.
You should not feel held hostage. In fact, you can move your emails somewhere else, and you can change your email address. No big deal. It's like moving to another place. We are used doing it and we don't care that much.
NB: in any case, I'm happy to use my own domain since 1999.
Also note that when the feature is enabled PDB-wide, I can disable and re-enable it using the ALTER SESSION statement. It seems that the implementation is rather peculiar... Also, the way buffers disappear and reappear when you disable and re-enable it is quite strange.
Yes, things seem to work as expected when I enable it at the system level.
Am I the only one who cannot activate SQL History at the session level in #OracleDatabase 26ai?
The "ALTER SESSION SET SQL_HISTORY_ENABLED = TRUE" command runs successfully but has no effect...
Yeap, since 12.2 using v$diag_trace_file_contents is the way to go. The only issue I'm aware with it is that lines that don't fit in the VARCHAR2(4000) are silently cut.
English is the only one that matters to me (and, I guess, to Apress too). Additional languages depend on other publishers that are interested in buying the rights and pay for the translation.
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
www.youtube.com/watch?v=zSn8...
From what I see, #OracleDatabase between version 23.3 and version 23.26.1 ships with a buggy TRCSESS script.
To fix it, just correctly set the variable JDK_HOME at line 54.
I seems that the problem was introduced by the change "adadhich 04/12/23 - use s_jdkLocation".
This is an interesting case of censorship. The two images show the front covers of the same book. One was printed in Switzerland and the other by Amazon. I suppose Donald's ego is just too fragile.
It was a great pleasure to have you at those events.
Since I'm still 9.5 years away from reaching the official retirement age, plenty of things could happen.
Anyway, I'll try my best to enjoy life ;-)
I love(d) my job too. But, on the one hand, there are plenty of other things I want to do; on the other hand, I was more and more tired of the (uninteresting) business obligations. In any case, IT will be part of my future too... but only for fun or personal interests.
The journey that began with Trivadis in 1999 ends today. It has been a great and memorable one. I had the chance to make so many positive experiences and meet great people inside and outside the company. But it's time for me to move on and enable pre-retirement mode.
Infographic showing that PostgreSQL supports FILTER since 2015, followed by H2 and SQLite in 2019, DuckDB 2024 (first tested release) and now Oracle in 2026.
I’m a simple man.
While Oracle people are ecstatic about ASSERTION in the just released version 23.26.1 of the Oracle Database, I’m happy to see something as simple as FILTER :)
🧵
www.youtube.com/watch?v=dNvI...
The installer doesn't ask whether the installation have to be EE or SE2. Is it expected?
Finally.