Страницы

▼
суббота, 15 апреля 2023 г.

X$MESSAGES hidden columns

›
Sometimes X$ tables might have seemingly unused gaps in a row. Here is an example with X$MESSAGES: SQL> select kqftarsz 2 from x$k...

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 queryin...
четверг, 13 апреля 2023 г.

Computing ORA_HASH

›
I wrote a short Python function to compute a hash value for a given expression. The return value of the function matches the return value o...
суббота, 25 марта 2023 г.

X$ tables: reading X$KQFCO from Oracle binary

›
Column definition structures are stored in kqftap : [oracle@db-21 ~]$ xinfo list 'X$KCCCP' -o json --with-kqftap { "457...
суббота, 18 марта 2023 г.

ORA-00855 PGA_AGGREGATE_TARGET cannot be set because of insufficient physical memory

›
Given the following amount of memory and %target parameters, what PGA_AGGREGATE_TARGET (PAT) can be set for this system? SQL> sho parame...
суббота, 19 февраля 2022 г.

X$ tables: table-level callbacks and column definitions (without parsing)

›
Thus far, I have reviewed the kqftab structure which is used to build the majority of tables in X$KQFTA . It is not clear yet where actual ...
пятница, 11 февраля 2022 г.

Virtual X$ tables

›
Some of X$ tables are not coming from the kqftab structure. For example, the xinfo tool outputs only 1,272 tables in 21.5, whereas X$KQFTA...