The Demon-Haunted World, Carl Sagan, 1996

I'm looking for a working example of the LLS Clause in #OracleDatabase, but I'm unable to find it. Also the one provided in the doc is wrong (doesn't work).
When no offset/length is specified, it works as expected.
With offset/length, I always get a KUP-04001 error referencing an invalid file name.

#QlikConnect appreciation event took place in Disney's Animal Kingdom. I'm not a big fan of such parks, but it was fun. Avatar Flight is really impressive! Thanks to #Qlik and diamond sponsors #AWS and #Accenture.

First time I attended a conference using the silent-disco approach. E.g. on the photo, there are three "rooms" with parallel sessions. I must say it works really well.
#QlikConnect

#QlikConnect day 2 - general session with guest speaker Katie Ledecky

#QlikConnect day 1 - general session

Hey #Oracle, can you please remove from the 23 documentation references to Java classes (e.g. oracle.sql.STRUCT/OPAQUE/ARRAY/REF) that were deprecated more than one decade ago?

docs.oracle.com/en/database/...

Somehow, I find it strange to see my name on a conference agenda... I can't even remember the last time it happened (except for #tvdpdays #rip). Anyway, I'm happy to talk about what we developed in the last 5 years.
#ecaas #qlik #qlikconnect25

On the customer's database, I have limited access. Hence, I only took a systemstate (level 266).
On my notebook, I used perf to confirm that what I see seems equivalent to the customer's database.
It seems that the issue is caused by kdlwiOpen1/kdlwiClose1.
Next, I will try the fix for bug 35999726.

To be clear, the contention is due to the 8 parallel processes themselves; not to other concurrent operations. The following images illustrate what I observe on my notebook when moving a small 1-million-row table...

It might be just me, but when in #OracleDatabase you are hitting an ORA-22804, the available technique to workaround it is well hidden in the highlighted sentence (extracted from the the Object-Relational Developer's Guide). Why not providing an example?

Don't ask me why, but after watching that beautiful movie dozens of times, I realised only tonight that March 22 was a Monday, not a Saturday.

In 2024, the energy balance of our PV system (10 kWp) achieved my expectations: it produced more than what the house, pool and EV consumed; the self-consumption reached 50%.
Goal for 2025 is to take advantage of our EV (Skoda Enyaq) in a vehicle-to-home mode to drastically increase self-consumption.

Please, #snowflake, can you provide better error messages? I don't see how something like that can help when the query has many subqueries...

My first DOAG was also in 2004... Time flies!