On Oracle
Tuesday, June 17, 2025
Blog List
›
June 2025 (1) ORA-01002: fetch out of sequence: One Case Test May 2025 (1) Oracle ORA-00600 [pfrsfm: sta...
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 ...
›
Home
View web version