Chris Antognini
@chris.antognini.ch
Striving for Optimal Performance
https://antognini.ch
https://antognini.ch
Reposted by Chris Antognini
For those who can't past the paywall, you can also find the list of books here:
fiendatcourt.com/six-books-ab...
fiendatcourt.com/six-books-ab...
Six Books About Tennis's Greatest Players (According to the Economist)
Explore eight must-read tennis books according to The Economist. This roundup includes capsules of my original reviews for each title.
fiendatcourt.com
July 8, 2025 at 6:02 PM
For those who can't past the paywall, you can also find the list of books here:
fiendatcourt.com/six-books-ab...
fiendatcourt.com/six-books-ab...
The issue was due to the COLUMN TRANSFORM clause. According to my tests:
- COLUMN TRANSFORM is needed when NO offset/length is specified.
- COLUMN TRANSFORM is NOT needed when offset/length is specified.
Even though I don't understand why such an inconsistency exists, now I know how to implement it.
- COLUMN TRANSFORM is needed when NO offset/length is specified.
- COLUMN TRANSFORM is NOT needed when offset/length is specified.
Even though I don't understand why such an inconsistency exists, now I know how to implement it.
June 11, 2025 at 12:46 PM
The issue was due to the COLUMN TRANSFORM clause. According to my tests:
- COLUMN TRANSFORM is needed when NO offset/length is specified.
- COLUMN TRANSFORM is NOT needed when offset/length is specified.
Even though I don't understand why such an inconsistency exists, now I know how to implement it.
- COLUMN TRANSFORM is needed when NO offset/length is specified.
- COLUMN TRANSFORM is NOT needed when offset/length is specified.
Even though I don't understand why such an inconsistency exists, now I know how to implement it.
The non-working example provided in the documentation can be found in "Oracle Database Utilities Guide - 18.7.2.2 Loading LOBs from LOBFILE Files".
docs.oracle.com/en/database/...
docs.oracle.com/en/database/...
Utilities
Learn from these examples how to use the ORACLE_LOADER, ORACLE_DATAPUMP,ORACLE_HDFS, ORACLE_HIVE access drivers, and to use external tables with vector data.
docs.oracle.com
May 28, 2025 at 1:17 PM
The non-working example provided in the documentation can be found in "Oracle Database Utilities Guide - 18.7.2.2 Loading LOBs from LOBFILE Files".
docs.oracle.com/en/database/...
docs.oracle.com/en/database/...
I also don't use mine that often. But, I'm not ready to get rid of it. Let's see how long it will take...
May 21, 2025 at 9:55 AM
I also don't use mine that often. But, I'm not ready to get rid of it. Let's see how long it will take...
If it's related to wind, I guess that there are still plenty of electrical overhead lines. In CH, except for trains and HT, they are getting very rare...
April 23, 2025 at 6:17 PM
If it's related to wind, I guess that there are still plenty of electrical overhead lines. In CH, except for trains and HT, they are getting very rare...
Out of curiosity, what's the frequency of power cuts?
April 23, 2025 at 5:42 PM
Out of curiosity, what's the frequency of power cuts?
According to Oracle Support it's bug 36628068 - HIGH CONTENTION ON SHARED POOL LATCH WHEN ALLOCATING FSO SCN FIELDS. Waiting on a backport to verify how good the patch works.
April 22, 2025 at 9:53 AM
According to Oracle Support it's bug 36628068 - HIGH CONTENTION ON SHARED POOL LATCH WHEN ALLOCATING FSO SCN FIELDS. Waiting on a backport to verify how good the patch works.