Thursday, January 18, 2024

One Test on the Different Errors of Oracle Global Temporary Tables vs. Private Temporary Tables

›
This Blog shows one different behaviour of Oracle Global Temporary Table (GTT since Oracle 8i) vs. Private Temporary Table (PTT since Oracle...
Wednesday, October 25, 2023

ORA-28268: Exceeded the maximum allowed size for Context information in a session

›
Note: Tested in Oracle 19.18. 1. Test Setup -- code from Blog: "library cache: mutex X" and Application Context -- (htt...
Wednesday, September 20, 2023

Oracle Index Root Modification CBC Latch Contention: Workaround Studies

›
In Oracle applications, often there are certain central tables, which are accessed concurrently by many sessions using indexes. If one ind...
Wednesday, September 6, 2023

Oracle 19.18 Wait Event 'latch: cache buffers chains' P3: block number

›
In Oracle 19.18, we observed that Wait Event 'latch: cache buffers chains' Parameter P3 stores DBA (Data Block Address) (for bigfi...
Sunday, September 3, 2023

Oracle Index Range Scan with LIKE Condition on Wildcard '_'

›
This Blog shows LIKE condition index range scan performance and space usage of Oracle index with Wildcard '_'. Note: Tested in Or...
Thursday, August 3, 2023

Oracle SYS_GUID Composition

›
Oracle Docu wrote: SYS_GUID generates and returns a globally unique identifier (RAW value) made up of 16 bytes. On most platforms, the g...
Wednesday, June 14, 2023

One Deadlock of 'row cache lock' and 'library cache lock'

›
In this Blog, we first demonstrate a deadlock of 'row cache lock' and 'library cache lock', and then provide an analysis. ...