X$MESSAGES hidden columns
Sometimes X$ tables might have seemingly unused gaps in a row.
This post reviews such gaps in X$MESSAGES that turns out to be hidden columns.
2023¶
X$ tables: starting address
The starting address of X$ tables makes sense for tables residing in SGA or defined within the Oracle binary. It is usually found by querying an X$ table. This blog post describes an alternative method of obtaining the starting address by calling an Oracle C function.
Computing ORA_HASH
This post is written to demonstrate a Python function computing ORA_HASH.
X$ tables: reading X$KQFCO from Oracle binary
Let us find out how to get X$ table columns from the Oracle binary.
ORA-00855 PGA_AGGREGATE_TARGET cannot be set because of insufficient physical memory
I have been investigated a case with ORA-00855 recently, and decided to share my findings about this error in this post.