On Oracle
Wednesday, July 30, 2025
Reading CLOB Line by Line with SQL and Plsql
›
This blog will demonstrate different implementations of reading CLOB line by line in SQL and Plsql. For both SQL and Plsql, we show one sl...
Thursday, July 10, 2025
"library cache: bucket mutex X" on V$ Fixed Views: Case Test
›
Oracle DB experienced heavy "library cache: bucket mutex X" when V$ Fixed Views were queried frequently, which impeded Oracle no...
Tuesday, July 1, 2025
Oracle dbms_hprof: Uncatchable Time in PL/SQL Nested Program Units
›
This Blog will demonstrate dbms_hprof uncatchable time in PL/SQL nested procedures and packages, which often caused misleading in elapsed t...
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 ...
‹
›
Home
View web version