Sunday, September 22, 2024

One OracleJVM TIME_MODEL Test

›
In this Blog, we will make 5 different scenario tests of Java Stored Procedure running in Oracle RDBMS embedded JVM, and collect their stats...
Thursday, April 18, 2024

Oracle AQ Dequeue 'KTC latch subh' Memory Leak and Dequeue Long Running Test

›
Following previous Blog: "Oracle dbms_aq.dequeue_array Shared Pool "KTC Latch Subh" Memory Leak" (http://ksun-oracle.bl...
Tuesday, April 9, 2024

One Test of Oracle Object Collection MEMBER OF Function

›
Following previous Blog: Performance of Oracle Object Collection Comparisons - Part1 (http://ksun-oracle.blogspot.com/2016/01/performance-o...

In Memoriam of Prof. Niklaus Wirth: One Email on Program Debugging

›
1. Email Reply from Prof. Wirth Sent: Tuesday, August 21, 2007 at 06:49:43 PM GMT+2 Subject: Re: Debugger Help Dear Mr. Sun, With your...
Thursday, January 18, 2024

One Test on the Different Errors of Oracle Global Temporary Tables vs. Private Temporary Tables

›
This Blog shows one different behaviour of Oracle Global Temporary Table (GTT since Oracle 8i) vs. Private Temporary Table (PTT since Oracle...
Wednesday, October 25, 2023

ORA-28268: Exceeded the maximum allowed size for Context information in a session

›
Note: Tested in Oracle 19.18. 1. Test Setup -- code from Blog: "library cache: mutex X" and Application Context -- (htt...
Wednesday, September 20, 2023

Oracle Index Root Modification CBC Latch Contention: Workaround Studies

›
In Oracle applications, often there are certain central tables, which are accessed concurrently by many sessions using indexes. If one ind...