Tuesday, November 5, 2024

Oracle Self-tune checkpointing lag of log switch

›
Often DB alert.log shows a lag of 5 minutes from log switch to Completed checkpoint as follows: (from 11:03:36 to 11:08:39) 2024-11-04T1...
Sunday, October 20, 2024

Find the skipped rows in select for update skip locked

›
This Blog will make a test to show how to find the skipped rows when running "select for update skip locked". It first gets the ...
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...