On Oracle
Sunday, April 9, 2023
Oracle Multi-Consumer AQ dequeue with dbms_aq.listen Performance Analysis and Workaround (III)
›
Wait Events (I)   Performance Model (II)   Performance Analysis and Workaround (III) In the first...
Tuesday, March 7, 2023
One Test of Oracle JSON Plsql PGA Memory Leak
›
In this Blog, we make a test to demonstrate JSON PGA Memory Leak and eventual ORA-04030. Note: Tested in Oracle 19.17 Update (2023-04-...
Sunday, March 5, 2023
One Test of ORA-00600: [KGL-heap-size-exceeded] With AQ Subscriber
›
In this Blog, we will make tests with dbms_aqadm.add_subscriber / remove_subscriber to show: ORA-00600: internal error code, argume...
Sunday, February 26, 2023
Oracle Scalar Subquery Caching and Non-deterministic Functions
›
This Blog will demonstrate that Non-deterministic Function call in Scalar Subquery returns different result with Caching. Note : Tested on...
Monday, January 30, 2023
Oracle dbms_crypto.randombytes and Enhancement Suggestion
›
Oracle dbms_crypto provides three random functions: randombytes, randomnumber, randominteger. Internally they are subroutine kzstr called b...
Thursday, December 15, 2022
OracleJVM JAVA_JIT_ENABLED Linux /dev/shm mount noexec EPERM and Performance
›
In Linux, when JAVA_JIT_ENABLED is enabled, the native compiled Java code is stored in /dev/shm/JOEZSHM_*. However, if tmpfs /dev/shm/ is m...
‹
›
Home
View web version