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

Über mich

Mein Bild
Martin Berger
Mein Profil vollständig anzeigen
Powered by Blogger.