On Oracle
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...
Sunday, December 4, 2022
One Test of Oracle too many parse errors with ORA-12850 and ORA-12872
›
In this Blog, we first make a test to demonstrate Oracle "too many parse errors" associated with ORA-12850 and ORA-12872. Then we...
Monday, October 24, 2022
How many times SYSDATE is called in SQL and Plsql ?
›
In this Blog, we will try to count the number of SYSDATE and SYSTIMESTAMP executions in SQL and Plsql. Note: Tested in Oracle 19.13 1....
Monday, October 3, 2022
Oracle WITH subquery_factoring_clause TEMP TABLE TRANSFORMATION and log file sync
›
If WITH subquery_factoring_clause in a query is transformed as a temporary table, the session can experience log file sync when Log Write (L...
Monday, September 12, 2022
Update Restart and Undo Extends
›
In Blog: That old restart problem again... there is a comment about update restart and undo extends. Thereafter two Blogs are c...
‹
›
Home
View web version