Tuesday, June 17, 2025

ORA-01002: fetch out of sequence: One Case Test

›
drop table test_tab; create table test_tab (x number, y varchar2(100)); declare l_cnt number := 0; begin execute immediate 'tru...
Friday, May 23, 2025

Oracle ORA-00600 [pfrsfm: stack mismatch] and [pfrsfm: stack mismatch] Reproducing

›
This Blog will demonstrate how to generate Oracle ORA-00600 [pfrsfm: stack mismatch] and [pfrsfm: stack mismatch]. Note: Tested on Oracle...
Tuesday, February 18, 2025

One Oracle CLOB Space Usage Test

›
In this Blog, we will make LOB space usage test to show the used_blocks, expired_blocks, unexpired_blocks. And in case of LOB "buffer ...
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...