berxblog
2025-03-05
Sessionless Transactions - the moving target
›
Sessionless Transactions are quite new to Oracle. Some might argue this is not true: XA transactions are available since Oracle 7. The ne...
2024-09-18
Custom parameters in Method-R Workbench
›
Method-R Workbench is a leading tool to analyze many aspects of Oracles SQL-Trace files. It can use parameters in its commands and let...
2024-02-08
reading a LOB in another session
›
Reading a LOB in Oracle is often quite easy: it's just a column in the query and all the libraries available today are doing the work n...
2023-12-24
remote external procedure
›
During the migration of an application from an older AIX onto modern Linux based database, I stumbled across a little issue: The applicatio...
2023-12-09
The cost of BIND information in SQL Trace files
›
Oracle SQL Trace files are a very valuable source of information - especially when it comes to performance analysis. But people often are ...
2023-10-28
23c–Fine Grained Locking–Lock Free Reservations - behind the scene
›
Oracle 23c has a very interesting feature: Lock Free Reservations. There are great posts already which explain this feature, I'm more i...
›
Startseite
Web-Version anzeigen