Archive

Oracle EE

This blogpost is about Oracle database and grid infrastructure software homes, which patches should be applied to which homes, and what it then looks like. This is fully documented by MyOracleSupport notes, but you will see that with version 18 and up this is unclear.

I keep a script-set that automatically installs and patches the Oracle database software and creates a database. This script-set is called vagrant-builder, and it can install any version with any PSU applied between 11.2.0.2 up to 19.5, which is the latest PSU of the latest version, with a few exceptions: for 11.2.0.2 and 11.2.0.3 I only created an install for the base version and the latest PSU for the database, and version 12.1.0.1 is left out entirely.

I recently reviewed my installs and verified everything is carried out correctly. First a simple overview of what I think should be applied on the database and grid infrastructure install:

Version  Grid               Database
-------- ------             ----------
11.2.0.2 -                  DB PSU
11.2.0.3 -                  DB PSU+OJVM
11.2.0.4 GI PSU+JDBC patch  DB PSU+OJVM
12.1.0.2 GI PSU+JDBC patch  DB PSU+OJVM
12.2.0.1 GI PSU             DB PSU+OJVM
18       GI PSU             DB PSU+OJVM
19       GI PSU             DB PSU+OJVM

(‘-‘ means not investigated)
My idea of what should be applied is based on MOS note 1929745.1: Oracle recommended patches.

Grid patches, JDBC patch
The JDBC patch for grid infrastructure 11.2.0.4 and 12.1.0.2 is a patch that updates java classes. Therefore the patch is a generic one, the java classes do not contain operating system dependent machine code. The table in the MOS note also show differences for the JDBC patch between = januari 2014 = july 2016 and higher. No surprise there. It’s especially easy because all versions in premier support as of the date of this blogpost do not need the JDBC patch.

Grid patches, GI PSU
For the GI PSU, there are a lot of patches that contain the GI PSU, because outside of the GI patch itself, there are also combination patches that for example contain both the GI and the DB PSU. I like to keep it as simple as I can. Therefore, I stick to MOS note 2118136.2: Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), bundle patches, Patchsets and Base releases, and look at the following:
– versions 11.2.0.4/12.1.0.2: Oracle Database PSU, SPU(CPU), Bundle Patches (Versions 12.1 & lower), version (11.2.0.4/12.1.0.2), GI PSU column.
– versions 12.2.0.1 and up: Oracle Database Updates, version (12.2.0.1,18.0.0.0,19.0.0.0), GI Update column.

Database patches, DB PSU
Here too there are multiple patches that can be used to apply the DB PSU, and I stick with MOS note 2118136.2: Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), bundle patches, Patchsets and Base releases, and look at the following:
– versions 11.2.0.4/12.1.0.2: Oracle Database PSU, SPU(CPU), Bundle Patches (Versions 12.1 & lower), version (11.2.0.4/12.1.0.2), PSU column.
– versions 12.2.0.1 and up: Oracle Database Updates, version (12.2.0.1,18.0.0.0,19.0.0.0), DB Update column.

Database patches, OJVM
There are multiple MOS documents talking about the database JavaVM patch, and there are multiple patches, but here I stick with MOS note 2118136.2: Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), bundle patches, Patchsets and Base releases once again, and look at the following:
– OJVM Update/PSU/Bundle Patches, 11.2.0.4/12.1.0.2/12.2.0.1/18.0.0.0/19.0.0.0, OJVM Update.

Okay. So we got the table above that is based on MOS note 1929745.1, and we got all the patches organised in MOS note 2118136.2. So that’s nice and simple, right?

Well, not entirely…

As I said, I was checking up on the latest PSU installs. This is the ‘opatch lspatches’ overview of 12.1.0.2 and 12.2.0.1:

-- 12.1.0.2
GI 190716
---------
23727148;
29509318;OCW PATCH SET UPDATE 12.1.0.2.190716 (29509318)
29494060;Database Patch Set Update : 12.1.0.2.190716 (29494060)
29423125;ACFS PATCH SET UPDATE 12.1.0.2.190716 (29423125)
26983807;WLM Patch Set Update: 12.1.0.2.180116 (26983807)
DB 190716
---------
29774383;Database PSU 12.1.0.2.190716, Oracle JavaVM Component (JUL2019)
29494060;Database Patch Set Update : 12.1.0.2.190716 (29494060)
-- 12.2.0.1
GI 191015
---------
30138470;Database Oct 2019 Release Update : 12.2.0.1.191015 (30138470)
30122828;ACFS OCT 2019 RELEASE UPDATE 12.2.0.1.0 (30122828)
30122814;OCW OCT 2019 RELEASE UPDATE 12.2.0.1.191015 (30122814)
30093408;TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:190208.0920) (30093408)
26839277;DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277
DB 191015
---------
30133625;OJVM RELEASE UPDATE: 12.2.0.1.191015 (30133625)
30138470;Database Oct 2019 Release Update : 12.2.0.1.191015 (30138470)

For the database (DB), we see two patches, which is exactly what is expected.
– The database patch, which is called release update with one and patch set update with the other.
– The OJVM update which also named differently between the two versions, but very much recognisable as such.
I think it’s bad that the names vary, but this is totally expected.

For the grid infrastructure (GI), we see 5 patches in both situations, but these are not the same patches between the homes!
– The unnamed patch in the 12.1.0.2 home is the JDBC patch, which should only be applied to 12.1.0.2, not to higher versions.
– The OCW patch (oracle clusterware).
– The database patch.
– The ACFS patch. The version indication in the patch name changed.
– The WLM/DBWLM patch. Sadly the name changed, and the name with 12.2.0.1 is actually quite useless, I can’t tell the actual version, I have to look up the patch number.
– Starting from version 12.2.0.1, there is a tomcat installation in the grid home, as this patch indicates. The name here is not helpful because it doesn’t indicate the actual version, like with the DBWLM patch.

So, outside of in my opinion bad naming, and a weird inclusion of a competing product of Oracle (Tomcat versus Weblogic), this still follows the rules of logic.

Now let’s look at the same output for version 18 and 19:

--18
GI 18.8
30116128;ACFS RELEASE UPDATE 18.8.0.0.0 (30116128)
30113775;OCW RELEASE UPDATE 18.8.0.0.0 (30113775)
30112122;Database Release Update : 18.8.0.0.191015 (30112122)
30093398;TOMCAT RELEASE UPDATE 18.0.0.0.0 (30093398)
28655963;DBWLM RELEASE UPDATE 18.4.0.0.0 (28655963)
27923415;OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)
DB 18.8
30133603;OJVM RELEASE UPDATE: 18.8.0.0.191015 (30133603)
30112122;Database Release Update : 18.8.0.0.191015 (30112122)
28090553;OCW RELEASE UPDATE 18.3.0.0.0 (28090553)
--19
GI 19.5
30125133;Database Release Update : 19.5.0.0.191015 (30125133)
30122167;ACFS RELEASE UPDATE 19.5.0.0.0 (30122167)
30122149;OCW RELEASE UPDATE 19.5.0.0.0 (30122149)
29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)
DB 19.5
30128191;OJVM RELEASE UPDATE: 19.5.0.0.191015 (30128191)
30125133;Database Release Update : 19.5.0.0.191015 (30125133)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

I must say that the naming in general looks more consistent, that is a good thing!

For the database (DB) we see THREE patches (I suspected 2):
– The database release update patch, which nicely reports its version.
– The OVM patch, which also reports its version.
– This is weird. One of the grid infrastructure patches, the “OCW” patch, is applied to the database home. In fact, this is applied to the base release. Because it’s not a patch that is documented to be needed to be applied, this will sit at this version and never be updated. However, this unexpected patch is consistently applied to the base release for both version 18 and 19.

For the grid home (GI) we see an inconsistent number of patches (!) between 18.8 and 19.5. This is partly as expected, but I found an weird patch applied too. Let’s go over the patches:
– The ACFS patch is totally expected and appropriately named.
– The OCW patch is expected and appropriately named too.
– The Database Release Update patch is expected and appropriately named.
– The TOMCAT patch is expected. I don’t understand why it can’t have the RU numbering, but at least it’s consistent between 18 and 19.
– The DBWLM patch is only applied to the 18 home. As far as I understand, this is how it’s supposed to be, DBWLM is not regularly updated like the other ones above, so it’s okay to have an older version of it with the other patches, and if there isn’t a patch to apply, it can simply not be there, like with version 19 in this case.
– The OJVM patch puzzles me. I don’t know what to think of it. Also, it’s only applied to the base release of version 18, not to the base release of version 19. This, very much like the OCW patch, will never be updated. But I just don’t understand, this patches the java virtual machine in the database, which for GI is the ASM instance, for which, as far as I know, the java virtual machine isn’t used.

Conclusion.
The naming of the patches as visible with “opatch lspatches” has certainly improved with version 18 and higher. Still it would be helpful if the grid infrastructure tomcat patch would follow the same naming of the other patches.

I am in doubts about the inclusion of two patches in the base releases of versions 18 and 19:
The OJVM patch inclusion in the base release of grid infrastructure of version 18 only.
The OCW patch inclusion in the base release of the database of version 18 and 19.

Addendum.
After debating this on twitter and with my colleagues, I found that my OCW assumptions were incorrect. The grid infrastructure patch versions 12.2 and up reasonably clearly describes that the OCW sub-patch that is part of the GI PSU/RU patch should be applied to the database home too (if cluster ware is used for that home). So that means that if you got another version of the database home than the grid infrastructure home and it is used with grid infrastructure, you should download the grid infrastructure PSU/RU patch and apply the OCW sub patch to the oracle database home, because the OCW patch is not in the database PSU/RU patch.
Because the database home patch itself is also in the grid infrastructure PSU/RU patch, I see no reason to bother downloading the database patch, and now only download and use the grid infrastructure PSU/RU patch, because that contains the database home patch as well as the OCW patch.

Addendum 2.
The OCW patch being installed into the grid infrastructure home and additionally in the database home turns out to be a change with PSU 11.2.0.4.5. Before that, the OCW patch did exist with the grid infrastructure home patch, but couldn’t be applied to the database home. This change was documented in the patch readme, but wasn’t really heavily marketed by Oracle.

Addendum 3.
Despite OCW being documented as being additionally applied to the database home for 11.2.0.4(.5) and higher, in my tests it was not possible to apply the 11.2.0.4 OCW patch to a database home for any 11.2.0.4 PSU; opatch fails with a dependency problem. It does succeed starting from 12.1.0.2 (12.1.0.1 not tested) and higher.

I have to say that when looking in the 11.2.0.4 OCW patch metadata, it says ‘rac’, so the OCW patch might succeed when the home is explicitly installed for a cluster database. I tested with grid infrastructure installed for a single machine (“siha”).

This blogpost is about an inconsistency I found in the X$ tables X$KQFTA and X$KQFCO. This is very specific. If you don’t care about that, you can skip this post.

The Oracle database’s “dynamic performance views” are views that are prefixed with “GV$” and “V$”. The “G” with “GV$” stands for “global” and gets you the results from its “V$” equivalent for all instances. In most cases, but that’s not the purpose of this blog. In most cases, the “V$” version simply is the “GV$” view with inst_id (instance id, used in RAC to specify the instance id) set to the current instance. I’ll refer to both simply as “V$” for simplicity.

The “V$” views are mostly build on top of “X$” tables. The “X$” tables are Oracle internal tables, and not officially supported, therefore you should use the “V$” views.

One of the things that certain “X$” tables expose is information about the “X$” tables and their columns theirselves. These “X$” tables are visible in “X$KQFTA” (kernel query fixed tables tables) for the “X$” tables, and “X$KQFCO” (kernel query fixed tables columns) for the columns of the “X$” tables. I learned about these tables a long time ago from Kyle Hailey, Anjo Kolk and James Morle regarding direct memory attachment for wait events, the reason being the ability to find the memory address for certain “X$” tables to fetch the data these hold directly. We are talking about the 1990s here. In fact, Kyle later put the history of how he learned about it in the “Oracle insights: tales of the oaktable” book.

I gather information about every PSU of every Oracle database version on linux once it comes out. This is how I am able to produce the posts about the difference between a current and a previous PSU. One of the things that I gather is information about X$ tables and their columns. In order to obtain the columns, I use X$KQFTA and X$KQFCO and join these in the way that is publicly known:

select t.kqftanam, c.kqfconam
from x$kqfta t, x$kqfco c
where t.inst_id = 1
and c.inst_id = 1
and t.indx = c.kqfcotab;

And this worked well…

…until I produced a difference report of versions 12.1.0.2.191015 and 12.1.0.2.190716, where the report reported the following difference:

x$ tables columns unique to 12.1.0.2.190716 versus 12.1.0.2.191015

NAME                                                                                                 COLUMN_NAME
---------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
X$KQFTVRTTST0                                                                                        ADDR
X$KQFTVRTTST0                                                                                        CHGROWID
X$KQFTVRTTST0                                                                                        CHGROWOP
X$KQFTVRTTST0                                                                                        COL0_0
X$KQFTVRTTST0                                                                                        COL0_1
X$KQFTVRTTST0                                                                                        COL0_2
X$KQFTVRTTST0                                                                                        COL0_3
X$KQFTVRTTST0                                                                                        COL0_4
...and so on...

This could happen, these are columns that seem to have vanished with 12.1.0.2.191015. However, I decided to check it, although I haven’t got access to the 12.1.0.2.191015 PSU, because it’s a PSU version only available for paid extended support.

I looked at the columns of X$KQFTVRTST0 in my current database, which happens to be an ancient 11.2.0.2 database. However, much to my surprise, this gave me radically different columns:

SYS@o112 AS SYSDBA> desc X$KQFTVRTTST0
 Name                                                                                                              Null?    Type
 ----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
 ADDR                                                                                                                       RAW(8)
 INDX                                                                                                                       NUMBER
 INST_ID                                                                                                                    NUMBER
 COLA                                                                                                                       VARCHAR2(64)
 COLB                                                                                                                       NUMBER

Okay, something weird is going on here.

First let’s look in which versions X$KQFTVRTTST0 is present:

ORAVER@o112 > @x_table_in_versions.sql

DATABASE_VERSION     NAME
-------------------- --------------------------------------------------------------------------------------------------------------------------------
11.2.0.1.0           X$KQFTVRTTST0
11.2.0.2.0           X$KQFTVRTTST0
11.2.0.2.12          X$KQFTVRTTST0
11.2.0.3.0           X$KQFTVRTTST0
11.2.0.3.15          X$KQFTVRTTST0
11.2.0.4.0           X$KQFTVRTTST0
11.2.0.4.1           X$KQFTVRTTST0
11.2.0.4.160119      X$KQFTVRTTST0
11.2.0.4.160419      X$KQFTVRTTST0
11.2.0.4.160719      X$KQFTVRTTST0
11.2.0.4.161018      X$KQFTVRTTST0
11.2.0.4.170418      X$KQFTVRTTST0
11.2.0.4.170718      X$KQFTVRTTST0
11.2.0.4.170814      X$KQFTVRTTST0
11.2.0.4.180116      X$KQFTVRTTST0
11.2.0.4.180417      X$KQFTVRTTST0
11.2.0.4.180717      X$KQFTVRTTST0
11.2.0.4.190115      X$KQFTVRTTST0
11.2.0.4.191015      X$KQFTVRTTST0
11.2.0.4.2           X$KQFTVRTTST0
11.2.0.4.3           X$KQFTVRTTST0
11.2.0.4.4           X$KQFTVRTTST0
11.2.0.4.5           X$KQFTVRTTST0
11.2.0.4.6           X$KQFTVRTTST0
11.2.0.4.7           X$KQFTVRTTST0
11.2.0.4.8           X$KQFTVRTTST0
12.1.0.2.0           X$KQFTVRTTST0
12.1.0.2.1           X$KQFTVRTTST0
12.1.0.2.160119      X$KQFTVRTTST0
12.1.0.2.160419      X$KQFTVRTTST0
12.1.0.2.160719      X$KQFTVRTTST0
12.1.0.2.161018      X$KQFTVRTTST0
12.1.0.2.170117      X$KQFTVRTTST0
12.1.0.2.170418      X$KQFTVRTTST0
12.1.0.2.170718      X$KQFTVRTTST0
12.1.0.2.170814      X$KQFTVRTTST0
12.1.0.2.171017      X$KQFTVRTTST0
12.1.0.2.180116      X$KQFTVRTTST0
12.1.0.2.180417      X$KQFTVRTTST0
12.1.0.2.181016      X$KQFTVRTTST0
12.1.0.2.190115      X$KQFTVRTTST0
12.1.0.2.190416      X$KQFTVRTTST0
12.1.0.2.190716      X$KQFTVRTTST0
12.1.0.2.191015      X$KQFTVRTTST0
12.1.0.2.3           X$KQFTVRTTST0
12.1.0.2.4           X$KQFTVRTTST0
12.1.0.2.5           X$KQFTVRTTST0
12.2.0.1.0           X$KQFTVRTTST0
12.2.0.1.170620      X$KQFTVRTTST0
12.2.0.1.170718      X$KQFTVRTTST0
12.2.0.1.170814      X$KQFTVRTTST0
12.2.0.1.171017      X$KQFTVRTTST0
12.2.0.1.180116      X$KQFTVRTTST0
12.2.0.1.180417      X$KQFTVRTTST0
12.2.0.1.180717      X$KQFTVRTTST0
12.2.0.1.181016      X$KQFTVRTTST0
12.2.0.1.190115      X$KQFTVRTTST0
12.2.0.1.190416      X$KQFTVRTTST0
12.2.0.1.190716      X$KQFTVRTTST0
12.2.0.1.191015      X$KQFTVRTTST0
18.3                 X$KQFTVRTTST0
18.4                 X$KQFTVRTTST0
18.5                 X$KQFTVRTTST0
18.6                 X$KQFTVRTTST0
18.7                 X$KQFTVRTTST0
18.8                 X$KQFTVRTTST0
19.2                 X$KQFTVRTTST0
19.3                 X$KQFTVRTTST0
19.4                 X$KQFTVRTTST0
19.5                 X$KQFTVRTTST0

So, X$KQFVRTTST0 appeared with 11.2.0.1. Now let’s take a look at how the columns look like in X$KQFVRTTST0 looks in version 11.2.0.1:

ORAVER@o112 > @x_table_cols_in_versions.sql

DATABASE_VERSION	       TABLE_NAME		      COLUMN_NAME
------------------------------ ------------------------------ ----------------------------------------
11.2.0.1.0		       X$KQFTVRTTST0		      COL3_9
11.2.0.1.0		       X$KQFTVRTTST0		      COL3_8
11.2.0.1.0		       X$KQFTVRTTST0		      COL3_7
11.2.0.1.0		       X$KQFTVRTTST0		      COL3_6
11.2.0.1.0		       X$KQFTVRTTST0		      COL3_5
11.2.0.1.0		       X$KQFTVRTTST0		      COL3_4
11.2.0.1.0		       X$KQFTVRTTST0		      COL3_3
11.2.0.1.0		       X$KQFTVRTTST0		      COL3_2
11.2.0.1.0		       X$KQFTVRTTST0		      COL3_1
11.2.0.1.0		       X$KQFTVRTTST0		      COL3_0
11.2.0.1.0		       X$KQFTVRTTST0		      COL2_9
11.2.0.1.0		       X$KQFTVRTTST0		      COL2_8
11.2.0.1.0		       X$KQFTVRTTST0		      COL2_7
11.2.0.1.0		       X$KQFTVRTTST0		      COL2_6
11.2.0.1.0		       X$KQFTVRTTST0		      COL2_5
11.2.0.1.0		       X$KQFTVRTTST0		      COL2_4
11.2.0.1.0		       X$KQFTVRTTST0		      COL2_3
11.2.0.1.0		       X$KQFTVRTTST0		      COL2_2
11.2.0.1.0		       X$KQFTVRTTST0		      COL2_1
11.2.0.1.0		       X$KQFTVRTTST0		      COL2_0
11.2.0.1.0		       X$KQFTVRTTST0		      COL1_9
11.2.0.1.0		       X$KQFTVRTTST0		      COL1_8
11.2.0.1.0		       X$KQFTVRTTST0		      COL1_7
11.2.0.1.0		       X$KQFTVRTTST0		      COL1_6
11.2.0.1.0		       X$KQFTVRTTST0		      COL1_5
11.2.0.1.0		       X$KQFTVRTTST0		      COL1_4
11.2.0.1.0		       X$KQFTVRTTST0		      COL1_3
11.2.0.1.0		       X$KQFTVRTTST0		      COL1_2
11.2.0.1.0		       X$KQFTVRTTST0		      COL1_1
11.2.0.1.0		       X$KQFTVRTTST0		      COL1_0
11.2.0.1.0		       X$KQFTVRTTST0		      COL0_9
11.2.0.1.0		       X$KQFTVRTTST0		      COL0_8
11.2.0.1.0		       X$KQFTVRTTST0		      COL0_7
11.2.0.1.0		       X$KQFTVRTTST0		      COL0_6
11.2.0.1.0		       X$KQFTVRTTST0		      COL0_5
11.2.0.1.0		       X$KQFTVRTTST0		      COL0_4
11.2.0.1.0		       X$KQFTVRTTST0		      COL0_3
11.2.0.1.0		       X$KQFTVRTTST0		      COL0_2
11.2.0.1.0		       X$KQFTVRTTST0		      COL0_1
11.2.0.1.0		       X$KQFTVRTTST0		      COL0_0
11.2.0.1.0		       X$KQFTVRTTST0		      CHGROWOP
11.2.0.1.0		       X$KQFTVRTTST0		      CHGROWID
11.2.0.1.0		       X$KQFTVRTTST0		      COL_OPERATION
11.2.0.1.0		       X$KQFTVRTTST0		      INST_ID
11.2.0.1.0		       X$KQFTVRTTST0		      INDX
11.2.0.1.0		       X$KQFTVRTTST0		      ADDR

These are the columns which were shown in the difference report that said they were removed. Now let’s look at the columns in version 19.5:

ORAVER@o112 > @x_table_cols_in_versions.sql

DATABASE_VERSION               TABLE_NAME                     COLUMN_NAME
------------------------------ ------------------------------ ----------------------------------------
19.5                           X$KQFTVRTTST0                  COL3_9
19.5                           X$KQFTVRTTST0                  COL3_8
19.5                           X$KQFTVRTTST0                  COL3_7
19.5                           X$KQFTVRTTST0                  COL3_6
19.5                           X$KQFTVRTTST0                  COL3_5
19.5                           X$KQFTVRTTST0                  COL3_4
19.5                           X$KQFTVRTTST0                  COL3_3
19.5                           X$KQFTVRTTST0                  COL3_2
19.5                           X$KQFTVRTTST0                  COL3_1
19.5                           X$KQFTVRTTST0                  COL3_0
19.5                           X$KQFTVRTTST0                  COL2_9
19.5                           X$KQFTVRTTST0                  COL2_8
19.5                           X$KQFTVRTTST0                  COL2_7
19.5                           X$KQFTVRTTST0                  COL2_6
19.5                           X$KQFTVRTTST0                  COL2_5
19.5                           X$KQFTVRTTST0                  COL2_4
19.5                           X$KQFTVRTTST0                  COL2_3
19.5                           X$KQFTVRTTST0                  COL2_2
19.5                           X$KQFTVRTTST0                  COL2_1
19.5                           X$KQFTVRTTST0                  COL2_0
19.5                           X$KQFTVRTTST0                  COL1_9
19.5                           X$KQFTVRTTST0                  COL1_8
19.5                           X$KQFTVRTTST0                  COL1_7
19.5                           X$KQFTVRTTST0                  COL1_6
19.5                           X$KQFTVRTTST0                  COL1_5
19.5                           X$KQFTVRTTST0                  COL1_4
19.5                           X$KQFTVRTTST0                  COL1_3
19.5                           X$KQFTVRTTST0                  COL1_2
19.5                           X$KQFTVRTTST0                  COL1_1
19.5                           X$KQFTVRTTST0                  COL1_0
19.5                           X$KQFTVRTTST0                  COL0_9
19.5                           X$KQFTVRTTST0                  COL0_8
19.5                           X$KQFTVRTTST0                  COL0_7
19.5                           X$KQFTVRTTST0                  COL0_6
19.5                           X$KQFTVRTTST0                  COL0_5
19.5                           X$KQFTVRTTST0                  COL0_4
19.5                           X$KQFTVRTTST0                  COL0_3
19.5                           X$KQFTVRTTST0                  COL0_2
19.5                           X$KQFTVRTTST0                  COL0_1
19.5                           X$KQFTVRTTST0                  COL0_0
19.5                           X$KQFTVRTTST0                  CHGROWOP
19.5                           X$KQFTVRTTST0                  CHGROWID
19.5                           X$KQFTVRTTST0                  COL_OPERATION
19.5                           X$KQFTVRTTST0                  CON_ID
19.5                           X$KQFTVRTTST0                  INST_ID
19.5                           X$KQFTVRTTST0                  INDX
19.5                           X$KQFTVRTTST0                  ADDR

These are exactly the same! So the columns for X$KQFTVRTTST0 that I obtained from the database are the same for all versions in my data, but when I look in an actual database using ‘describe’ I see ADDR, INDX, INST_ID and COLA and COLB. So my data seems to be wrong!

My first reaction was to change the columns for X$KQFTVRTST0 for every version to correct this. But then I realised that I had to investigate this deeper to understand the actual problem, there might be more X$ tables involved.

The first thing to do, is to see if I can reproduce the issue in my database. This can be quite easily be done by describing X$KQFTVRTTST0 to see the columns, and then query these using the above query that demonstrates the join between X$KQFTA and X$KQFCO by adding a filter on ‘X$KQFTVRTST0’:

SYS@o112 AS SYSDBA> desc X$KQFTVRTTST0
 Name                                                                                                              Null?    Type
 ----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
 ADDR                                                                                                                       RAW(8)
 INDX                                                                                                                       NUMBER
 INST_ID                                                                                                                    NUMBER
 COLA                                                                                                                       VARCHAR2(64)
 COLB                                                                                                                       NUMBER
SYS@o112 AS SYSDBA> l
  1  select t.kqftanam, c.kqfconam
  2  from x$kqfta t, x$kqfco c
  3  where t.inst_id = 1
  4  and c.inst_id = 1
  5  and t.indx = c.kqfcotab
  6* and kqftanam = 'X$KQFTVRTTST0'
SYS@o112 AS SYSDBA> /

KQFTANAM                       KQFCONAM
------------------------------ ------------------------------
X$KQFTVRTTST0                  ADDR
X$KQFTVRTTST0                  INDX
X$KQFTVRTTST0                  INST_ID
X$KQFTVRTTST0                  COL_OPERATION
X$KQFTVRTTST0                  CHGROWID
X$KQFTVRTTST0                  CHGROWOP
X$KQFTVRTTST0                  COL0_0
X$KQFTVRTTST0                  COL0_1
X$KQFTVRTTST0                  COL0_2
X$KQFTVRTTST0                  COL0_3
X$KQFTVRTTST0                  COL0_4
X$KQFTVRTTST0                  COL0_5
X$KQFTVRTTST0                  COL0_6
X$KQFTVRTTST0                  COL0_7
X$KQFTVRTTST0                  COL0_8
X$KQFTVRTTST0                  COL0_9
X$KQFTVRTTST0                  COL1_0
X$KQFTVRTTST0                  COL1_1
X$KQFTVRTTST0                  COL1_2
X$KQFTVRTTST0                  COL1_3
X$KQFTVRTTST0                  COL1_4
X$KQFTVRTTST0                  COL1_5
X$KQFTVRTTST0                  COL1_6
X$KQFTVRTTST0                  COL1_7
X$KQFTVRTTST0                  COL1_8
X$KQFTVRTTST0                  COL1_9
X$KQFTVRTTST0                  COL2_0
X$KQFTVRTTST0                  COL2_1
X$KQFTVRTTST0                  COL2_2
X$KQFTVRTTST0                  COL2_3
X$KQFTVRTTST0                  COL2_4
X$KQFTVRTTST0                  COL2_5
X$KQFTVRTTST0                  COL2_6
X$KQFTVRTTST0                  COL2_7
X$KQFTVRTTST0                  COL2_8
X$KQFTVRTTST0                  COL2_9
X$KQFTVRTTST0                  COL3_0
X$KQFTVRTTST0                  COL3_1
X$KQFTVRTTST0                  COL3_2
X$KQFTVRTTST0                  COL3_3
X$KQFTVRTTST0                  COL3_4
X$KQFTVRTTST0                  COL3_5
X$KQFTVRTTST0                  COL3_6
X$KQFTVRTTST0                  COL3_7
X$KQFTVRTTST0                  COL3_8
X$KQFTVRTTST0                  COL3_9

Bingo! Describe tells me about COLA and COLB, which is the actual situation, and querying X$KQFTA and X$KQFCO gives me different, wrong columns.

First let’s investigate if we can find the correct columns in X$KQFCO, and see what the difference is between X$KQFTA.INDX and X$KQFCO.KQFCOTAB:

SYS@o112 AS SYSDBA> select indx from x$kqfta where kqftanam = 'X$KQFTVRTTST0';

      INDX
----------
       841

SYS@o112 AS SYSDBA> select kqfcotab from x$kqfco where kqfconam = 'COLA';

  KQFCOTAB
----------
       842

Aha! So the join is off by one! So, that must mean that if I decrease KQFCOTAB by one, I do get the correct output:

SYS@o112 AS SYSDBA> ed
Wrote file afiedt.buf

  1  select t.kqftanam, c.kqfconam
  2  from x$kqfta t, x$kqfco c
  3  where t.inst_id = 1
  4  and c.inst_id = 1
  5  and t.indx = c.kqfcotab-1
  6* and kqftanam = 'X$KQFTVRTTST0'
  7  /

KQFTANAM                       KQFCONAM
------------------------------ ------------------------------
X$KQFTVRTTST0                  ADDR
X$KQFTVRTTST0                  INDX
X$KQFTVRTTST0                  INST_ID
X$KQFTVRTTST0                  COLA
X$KQFTVRTTST0                  COLB

Bingo! The next thing to do is see if this is only a problem for X$KQFTVRTTST0, or a bigger problem. Let’s take the next table based on X$KQFTA.INDX, and see if this shows the same problem:

SYS@o112 AS SYSDBA> select kqftanam from x$kqfta where indx = 842;

KQFTANAM
------------------------------
X$DIAG_ADR_CONTROL
SYS@o112 AS SYSDBA> desc X$DIAG_ADR_CONTROL
 Name                                                                                                              Null?    Type
 ----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
 ADDR                                                                                                                       RAW(8)
 INDX                                                                                                                       NUMBER
 INST_ID                                                                                                                    NUMBER
 ADR_PATH_IDX                                                                                                               VARCHAR2(445)
 ADR_HOME                                                                                                                   VARCHAR2(445)
 ADRID                                                                                                                      NUMBER
 SHORTP_POLICY                                                                                                              NUMBER
 LONGP_POLICY                                                                                                               NUMBER
 LAST_MOD_TIME                                                                                                              TIMESTAMP(9) WITH TIME ZONE
 LAST_AUTOPRG_TIME                                                                                                          TIMESTAMP(9) WITH TIME ZONE
 LAST_MANUPRG_TIME                                                                                                          TIMESTAMP(9) WITH TIME ZONE
 ADRDIR_VERSION                                                                                                             NUMBER
 ADRSCHM_VERSION                                                                                                            NUMBER
 ADRSCHMV_SUMMARY                                                                                                           NUMBER
 ADRALERT_VERSION                                                                                                           NUMBER
 CREATE_TIME                                                                                                                TIMESTAMP(9) WITH TIME ZONE
SYS@o112 AS SYSDBA> ed
Wrote file afiedt.buf

  1   select t.kqftanam, c.kqfconam
  2   from x$kqfta t, x$kqfco c
  3   where t.inst_id = 1
  4   and c.inst_id = 1
  5   and t.indx = c.kqfcotab
  6*  and kqftanam = 'X$DIAG_ADR_CONTROL'
SYS@o112 AS SYSDBA> /

KQFTANAM                       KQFCONAM
------------------------------ ------------------------------
X$DIAG_ADR_CONTROL             ADDR
X$DIAG_ADR_CONTROL             INDX
X$DIAG_ADR_CONTROL             INST_ID
X$DIAG_ADR_CONTROL             COLA
X$DIAG_ADR_CONTROL             COLB

Clearly the columns are wrong, these are the columns of X$KQFTVRTTST0! Let’s subtract X$KQFCO.KQFCOTAB by one:

SYS@o112 AS SYSDBA> ed
Wrote file afiedt.buf

  1   select t.kqftanam, c.kqfconam
  2   from x$kqfta t, x$kqfco c
  3   where t.inst_id = 1
  4   and c.inst_id = 1
  5   and t.indx = c.kqfcotab-1
  6*  and kqftanam = 'X$DIAG_ADR_CONTROL'
SYS@o112 AS SYSDBA> /

KQFTANAM                       KQFCONAM
------------------------------ ------------------------------
X$DIAG_ADR_CONTROL             ADDR
X$DIAG_ADR_CONTROL             INDX
X$DIAG_ADR_CONTROL             INST_ID
X$DIAG_ADR_CONTROL             ADR_PATH_IDX
X$DIAG_ADR_CONTROL             ADR_HOME
X$DIAG_ADR_CONTROL             ADRID
X$DIAG_ADR_CONTROL             SHORTP_POLICY
X$DIAG_ADR_CONTROL             LONGP_POLICY
X$DIAG_ADR_CONTROL             LAST_MOD_TIME
X$DIAG_ADR_CONTROL             LAST_AUTOPRG_TIME
X$DIAG_ADR_CONTROL             LAST_MANUPRG_TIME
X$DIAG_ADR_CONTROL             ADRDIR_VERSION
X$DIAG_ADR_CONTROL             ADRSCHM_VERSION
X$DIAG_ADR_CONTROL             ADRSCHMV_SUMMARY
X$DIAG_ADR_CONTROL             ADRALERT_VERSION
X$DIAG_ADR_CONTROL             CREATE_TIME

And this is correct again!

Now let’s verify the highest X$KQFTA.INDX number in the version of this database:

SYS@o112 AS SYSDBA> select max(indx) from x$kqfta;

 MAX(INDX)
----------
       927

SYS@o112 AS SYSDBA> select kqftanam from x$kqfta where indx = 927;

KQFTANAM
------------------------------
X$DIAG_VTEST_EXISTS

SYS@o112 AS SYSDBA> desc X$DIAG_VTEST_EXISTS
 Name                                                                                                              Null?    Type
 ----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
 ADDR                                                                                                                       RAW(8)
 INDX                                                                                                                       NUMBER
 INST_ID                                                                                                                    NUMBER
 ADR_PATH_IDX                                                                                                               VARCHAR2(445)
 ADR_HOME                                                                                                                   VARCHAR2(445)
 PROBLEM_ID                                                                                                                 NUMBER
 PROBLEM_KEY                                                                                                                VARCHAR2(552)
 FIRST_INCIDENT                                                                                                             NUMBER
 FIRSTINC_TIME                                                                                                              TIMESTAMP(9) WITH TIME ZONE
 LAST_INCIDENT                                                                                                              NUMBER
 LASTINC_TIME                                                                                                               TIMESTAMP(9) WITH TIME ZONE
SYS@o112 AS SYSDBA> ed
Wrote file afiedt.buf

  1  select t.kqftanam, c.kqfconam
  2  from x$kqfta t, x$kqfco c
  3  where t.inst_id = 1
  4  and c.inst_id = 1
  5  and t.indx = c.kqfcotab
  6* and kqftanam = 'X$DIAG_VTEST_EXISTS'
SYS@o112 AS SYSDBA> /

KQFTANAM                       KQFCONAM
------------------------------ ------------------------------
X$DIAG_VTEST_EXISTS            ADDR
X$DIAG_VTEST_EXISTS            INDX
X$DIAG_VTEST_EXISTS            INST_ID
X$DIAG_VTEST_EXISTS            ADR_PATH_IDX
X$DIAG_VTEST_EXISTS            ADR_HOME
X$DIAG_VTEST_EXISTS            INCIDENT_ID
X$DIAG_VTEST_EXISTS            PROBLEM_ID
X$DIAG_VTEST_EXISTS            CREATE_TIME
X$DIAG_VTEST_EXISTS            CLOSE_TIME
X$DIAG_VTEST_EXISTS            STATUS
X$DIAG_VTEST_EXISTS            FLAGS
X$DIAG_VTEST_EXISTS            FLOOD_CONTROLLED
X$DIAG_VTEST_EXISTS            ERROR_FACILITY
X$DIAG_VTEST_EXISTS            ERROR_NUMBER
X$DIAG_VTEST_EXISTS            ERROR_ARG1
X$DIAG_VTEST_EXISTS            ERROR_ARG2
X$DIAG_VTEST_EXISTS            ERROR_ARG3
X$DIAG_VTEST_EXISTS            ERROR_ARG4
X$DIAG_VTEST_EXISTS            ERROR_ARG5
X$DIAG_VTEST_EXISTS            ERROR_ARG6
X$DIAG_VTEST_EXISTS            ERROR_ARG7
X$DIAG_VTEST_EXISTS            ERROR_ARG8
X$DIAG_VTEST_EXISTS            SIGNALLING_COMPONENT
X$DIAG_VTEST_EXISTS            SIGNALLING_SUBCOMPONENT
X$DIAG_VTEST_EXISTS            SUSPECT_COMPONENT
X$DIAG_VTEST_EXISTS            SUSPECT_SUBCOMPONENT
X$DIAG_VTEST_EXISTS            ECID
X$DIAG_VTEST_EXISTS            IMPACT
X$DIAG_VTEST_EXISTS            IMPACT_STR
X$DIAG_VTEST_EXISTS            STATUS_STR
X$DIAG_VTEST_EXISTS            ERROR_ARG9
X$DIAG_VTEST_EXISTS            ERROR_ARG10
X$DIAG_VTEST_EXISTS            ERROR_ARG11
X$DIAG_VTEST_EXISTS            ERROR_ARG12

So that’s wrong, let’s try subtracting by one:

SYS@o112 AS SYSDBA> ed
Wrote file afiedt.buf

  1  select t.kqftanam, c.kqfconam
  2  from x$kqfta t, x$kqfco c
  3  where t.inst_id = 1
  4  and c.inst_id = 1
  5  and t.indx = c.kqfcotab-1
  6* and kqftanam = 'X$DIAG_VTEST_EXISTS'
SYS@o112 AS SYSDBA> /

KQFTANAM                       KQFCONAM
------------------------------ ------------------------------
X$DIAG_VTEST_EXISTS            ADDR
X$DIAG_VTEST_EXISTS            INDX
X$DIAG_VTEST_EXISTS            INST_ID
X$DIAG_VTEST_EXISTS            ADR_PATH_IDX
X$DIAG_VTEST_EXISTS            ADR_HOME
X$DIAG_VTEST_EXISTS            PROBLEM_ID
X$DIAG_VTEST_EXISTS            PROBLEM_KEY
X$DIAG_VTEST_EXISTS            FIRST_INCIDENT
X$DIAG_VTEST_EXISTS            FIRSTINC_TIME
X$DIAG_VTEST_EXISTS            LAST_INCIDENT
X$DIAG_VTEST_EXISTS            LASTINC_TIME

And correct again!

So at least starting from X$KQFTA.INDX = 841 up to the highest INDX number, 927, X$KQFCO.KQFCOTAB is off by one.

Starting from there, I decided to test INDX = 1, which was consistent with KQFCOTAB. Then I decided to go down in INDX number starting from 841 being the number of X$KQFTVRTTST0. In my database number 840 is X$KTCNQROW, which was off by one, then I found something weird:

SYS@o112 AS SYSDBA> select kqftanam from x$kqfta where indx = 839;

KQFTANAM
------------------------------
X$SKGXP_MISC

SYS@o112 AS SYSDBA> desc X$SKGXP_MISC
ERROR:
ORA-00942: table or view does not exist
SYS@o112 AS SYSDBA> ed
Wrote file afiedt.buf

  1      select t.kqftanam, c.kqfconam
  2      from x$kqfta t, x$kqfco c
  3      where t.inst_id = 1
  4      and c.inst_id = 1
  5      and t.indx = c.kqfcotab
  6*    and kqftanam = 'X$SKGXP_MISC'
SYS@o112 AS SYSDBA> /

no rows selected

So the X$ view X$SKGXP_MISC exists in X$KQFTA, but doesn’t exist in reality, nor in X$KQFCO. Please mind this is a separate, different issue from the X$KQFCO.KQFCOTAB inconsistency this blogpost is about. My current thinking is the issue of existing in X$KQFTA and not queryable and (rightfully because of that), not available in X$KQFCO, might be either just a screwup/bug, or the X$ tables being reserved in the X$ table array, but not actually created, maybe because of setting during compilation. Just a hunch, I don’t know.

The same issue of being visible in X$KQFTA and not existing is true for:
838, X$SKGXP_CONNECTION
837, X$SKGXP_PORT
836, X$KSXP_STATS

INDX number 835 is X$KSXPTESTTBL. This table has the X$KQFCO.KQFCOTAB off by one issue:

SYS@o112 AS SYSDBA> select kqftanam from x$kqfta where indx = 835;

KQFTANAM
------------------------------
X$KSXPTESTTBL
SYS@o112 AS SYSDBA> desc X$KSXPTESTTBL
 Name                                                                                                              Null?    Type
 ----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
 ADDR                                                                                                                       RAW(8)
 INDX                                                                                                                       NUMBER
 INST_ID                                                                                                                    NUMBER
 KSXPTESTF1                                                                                                                 NUMBER
 KSXPTESTF2                                                                                                                 VARCHAR2(10)
 KSXPTESTF3                                                                                                                 NUMBER
 KSXPTESTF4                                                                                                                 NUMBER
 KSXPTESTF5                                                                                                                 RAW(8)
 KSXPTESTF6                                                                                                                 DATE
 KSXPTESTF7                                                                                                                 TIMESTAMP(3)
 KSXPTESTF8                                                                                                                 TIMESTAMP(3) WITH TIME ZONE
 KSXPTESTF9                                                                                                                 VARCHAR2(10)
 KSXPTESTF10                                                                                                                RAW(2)
 KSXPTESTF11                                                                                                                RAW(10)
SYS@o112 AS SYSDBA> ed
Wrote file afiedt.buf

  1  select t.kqftanam, c.kqfconam
  2  from x$kqfta t, x$kqfco c
  3  where t.inst_id = 1
  4  and c.inst_id = 1
  5  and t.indx = c.kqfcotab
  6* and t.kqftanam = 'X$KSXPTESTTBL'
SYS@o112 AS SYSDBA> /

no rows selected
SYS@o112 AS SYSDBA> ed
Wrote file afiedt.buf

  1  select t.kqftanam, c.kqfconam
  2  from x$kqfta t, x$kqfco c
  3  where t.inst_id = 1
  4  and c.inst_id = 1
  5  and t.indx = c.kqfcotab-1
  6* and t.kqftanam = 'X$KSXPTESTTBL'
SYS@o112 AS SYSDBA> /

KQFTANAM                       KQFCONAM
------------------------------ ------------------------------
X$KSXPTESTTBL                  ADDR
X$KSXPTESTTBL                  INDX
X$KSXPTESTTBL                  INST_ID
X$KSXPTESTTBL                  KSXPTESTF1
X$KSXPTESTTBL                  KSXPTESTF2
X$KSXPTESTTBL                  KSXPTESTF3
X$KSXPTESTTBL                  KSXPTESTF4
X$KSXPTESTTBL                  KSXPTESTF5
X$KSXPTESTTBL                  KSXPTESTF6
X$KSXPTESTTBL                  KSXPTESTF7
X$KSXPTESTTBL                  KSXPTESTF8
X$KSXPTESTTBL                  KSXPTESTF9
X$KSXPTESTTBL                  KSXPTESTF10
X$KSXPTESTTBL                  KSXPTESTF11

After X$KSXPTESTTBL, INDX number 834 is X$CELL_NAME:

SYS@o112 AS SYSDBA> select kqftanam from x$kqfta where indx = 834;

KQFTANAM
------------------------------
X$CELL_NAME
SYS@o112 AS SYSDBA> desc X$CELL_NAME
 Name                                                                                                              Null?    Type
 ----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
 ADDR                                                                                                                       RAW(8)
 INDX                                                                                                                       NUMBER
 INST_ID                                                                                                                    NUMBER
 CELLPATH_CELLROW                                                                                                           VARCHAR2(400)
 CELLHASHVAL_CELLROW                                                                                                        NUMBER
SYS@o112 AS SYSDBA> ed
Wrote file afiedt.buf

  1  select t.kqftanam, c.kqfconam
  2  from x$kqfta t, x$kqfco c
  3  where t.inst_id = 1
  4  and c.inst_id = 1
  5  and t.indx = c.kqfcotab
  6* and t.kqftanam = 'X$CELL_NAME'
SYS@o112 AS SYSDBA> /

KQFTANAM                       KQFCONAM
------------------------------ ------------------------------
X$CELL_NAME                    ADDR
X$CELL_NAME                    INDX
X$CELL_NAME                    INST_ID
X$CELL_NAME                    CELLPATH_CELLROW
X$CELL_NAME                    CELLHASHVAL_CELLROW

And with X$CELL_NAME the X$KQFTA.INDX=X$KQFCO.KQFCOTAB link is restored.

So, this means that starting with X$KSXPTESTTBL the X$KQFCO.KQFCOTAB number is off by one. In fact, I tested version 18 (18.4), and found that the value X$KQFTA.INDX is 1217, so much higher, but still with X$KSXPTESTTBL the inconsistency of X$KQFCO.KQFCOTAB being one too high to correctly join with X$KQFTA.INDX.

Conclusion.
This means that based on my current investigations, it seems that starting from Oracle database version 11.2.0.1 up to version 19 and current PSU, starting with the X$KQFTA.INDX value of the table X$KSXPTESTTBL in X$KQFTA, the X$KQFCO.KQFCOTAB value needs to be subtracted by one to get the correct fields from X$KQFCO.KQFCOTAB to join to X$KQFTA.INDX.

A lot of X$ tables are not impacted, the majority of the tables have an X$KQFTA.INDX value lower than X$KSXPTESTTBL, but there are a reasonable amount of tables that are impacted, a lot of them related to ADR (starting with X$DIAG).

The reason for showing an additional oddity with X$SKGXP_MISC, X$SKGXP_CONNECTION, X$SKGXP_PORT and X$KSXP_STATS is that the X$ table where the join problem starts is X$KSXPTESTTBL. All these tables have something to do with cross instance IPC communication (skgxp/ksxp), and a lot of them have the weird property that they don’t exist whilst are visible in X$KQFTA, this might have something to do with X$KQFCO.KQFCOTAB being off by one. Of course this is something I can’t check, because it requires source code access, but I thought it would be good to mention.

It’s interesting to see that the join of X$KQFTA.INDX to X$KQFCO.KQFCOTAB is present in Oracle’s data dictionary with the view V$INDEXED_FIXED_COLUMN:

SQL> select view_definition from v$fixed_view_definition where view_name = 'GV$INDEXED_FIXED_COLUMN';

VIEW_DEFINITION
--------------------------------------------------------------------------------
select c.inst_id,kqftanam, kqfcoidx, kqfconam, kqfcoipo, c.con_id  from x$kqfco
c, x$kqfta t where t.indx = c.kqfcotab and kqfcoidx != 0

Which by now should be clear is not correct for X$ tables with an X$KQFTA.INDX number equal or higher than X$KSXPTESTTBL.

The amount of changes between version 18.7 and 18.8 is truly minimal. There’s one spare parameter renamed to an underscore parameter, which seems to be a back port of functionality created version 19:

DATABASE_VERSION                                                                                     NAME
---------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------
18.8                                                                                                 _ldap_password_oneway_auth
19.2                                                                                                 _ldap_password_oneway_auth
19.3                                                                                                 _ldap_password_oneway_auth
19.4                                                                                                 _ldap_password_oneway_auth
19.5                                                                                                 _ldap_password_oneway_auth

And it seems the DBA view DBA_REGISTRY_BACKPORTS is corrupted with 18.8, there only is a synonym with that name, which throws an ORA 1775: looping chain of synonyms when used. This is the reason it shows as gone in 18.8 (unique to version 18.7).

parameters unique in version 18.7 versus 18.8

NAME
--------------------------------------------------
_one-hundred-and-forty-sixth_spare_parameter

parameters unique in version 18.8 versus 18.7

NAME
--------------------------------------------------
_ldap_password_oneway_auth

parameter values changed isdefault between 18.7 versus 18.8

parameter values unique to 18.7 versus 18.8

parameter values unique to 18.8 versus 18.7

waitevents unique in version 18.7 versus 18.8

waitevents unique in version 18.8 versus 18.7

waitevents changed parameter description between 18.7 versus 18.8

x$ tables unique to 18.7 versus 18.8

x$ tables unique to 18.8 versus 18.7

x$ tables columns unique to 18.7 versus 18.8

x$ tables columns unique to 18.8 versus 18.7

v$ tables unique to 18.7 versus 18.8

v$ tables unique to 18.8 versus 18.7

v$ tables columns unique to 18.7 versus 18.8

v$ tables columns unique to 18.8 versus 18.7

gv$ tables unique to 18.7 versus 18.8

gv$ tables unique to 18.8 versus 18.7

gv$ tables columns unique to 18.7 versus 18.8

gv$ tables columns unique to 18.8 versus 18.7

sysstat statistics unique to 18.7 versus 18.8

sysstat statistics unique to 18.8 versus 18.7

sys_time_model statistics unique to 18.7 versus 18.8

sys_time_model statistics unique to 18.8 versus 18.7

dba tables unique to 18.7 versus 18.8

NAME
----------------------------------------------------------------------------------------------------
DBA_REGISTRY_BACKPORTS

dba tables unique to 18.8 versus 18.7

dba tables columns unique to 18.8 versus 18.7

dba tables columns unique to 18.7 versus 18.8

cdb tables unique to 18.7 versus 18.8

NAME
----------------------------------------------------------------------------------------------------
CDB_REGISTRY_BACKPORTS

cdb tables unique to 18.8 versus 18.7

cdb tables column unique to 18.7 versus 18.8

cdb tables column unique to 18.8 versus 18.7

And here are the differences in symbols (c functions).
The amount of functions added and removed is not huge this time (remember last time littecms was added).
The same java/domain functions as seen with version 19 have been removed, and the same PLSQL codegen layer functions, plus a singe DBMS_SODA function. There are some other functions that do not align with 19 removed.

The same batch of DBMS_SODA related functions are added, plus a lot of functions different than version 19.

code symbol names unique in version 18.7 versus 18.8

NAME                                                         RESOLVE                                                      ANNOTATION
------------------------------------------------------------ ------------------------------------------------------------ --------------------------------------------------------------------------------
joncl_at_domains                                             (jon)cl_at_domains                                           java ??
joncl_domains                                                (jon)cl_domains                                              java ??
joncl_set_domains                                            (jon)cl_set_domains                                          java ??
joncl_snor_domains                                           (jon)cl_snor_domains                                         java ??
joniul_at_domains                                            (jon)iul_at_domains                                          java ??
joniul_domains                                               (jon)iul_domains                                             java ??
joniul_set_domains                                           (jon)iul_set_domains                                         java ??
joniul_snor_domains                                          (jon)iul_snor_domains                                        java ??
jonndl_at_domains                                            (jon)ndl_at_domains                                          java ??
jonndl_domains                                               (jon)ndl_domains                                             java ??
jonndl_set_domains                                           (jon)ndl_set_domains                                         java ??
jonndl_snor_domains                                          (jon)ndl_snor_domains                                        java ??
jonoce_at_domains                                            (jon)oce_at_domains                                          java ??
jonoce_domains                                               (jon)oce_domains                                             java ??
jonoce_set_domains                                           (jon)oce_set_domains                                         java ??
jonoce_snor_domains                                          (jon)oce_snor_domains                                        java ??
jonosd_at_domains                                            (jon)osd_at_domains                                          java ??
jonosd_domains                                               (jon)osd_domains                                             java ??
jonosd_set_domains                                           (jon)osd_set_domains                                         java ??
jonosd_snor_domains                                          (jon)osd_snor_domains                                        java ??
jonvcl_at_domains                                            (jon)vcl_at_domains                                          java ??
jonvcl_domains                                               (jon)vcl_domains                                             java ??
jonvcl_set_domains                                           (jon)vcl_set_domains                                         java ??
jonvcl_snor_domains                                          (jon)vcl_snor_domains                                        java ??
kestsInitTCB                                                 (kest)sInitTCB                                               kernel event SQL manageability tokenize (?) ??
kglsim_get_bucket_info                                       (kglsim)_get_bucket_info                                     kernel generic library cache management simulator (library cache advise)  ??
kgskltyp                                                     (kgsk)ltyp                                                   kernel generic service resource manager ??
krvxdsr                                                      (krvx)dsr                                                    kernel redo recovery extract ??
pdzdM60_Make_RBST                                            (pdz)dM60_Make_RBST                                          PLSQL code execution codegen infrastructure ??
pdzdM66_Insert_At_Root                                       (pdz)dM66_Insert_At_Root                                     PLSQL code execution codegen infrastructure ??
qcsoPreNameres_ProcOpt                                       (qcso)PreNameres_ProcOpt                                     query compile semantic analysis (parser) OBJECTS ??
qsodasqlGetInsertOneSQL                                      (qsoda)sqlGetInsertOneSQL                                    query system DBMS_SODA ??

code symbol names unique in version 18.8 versus 18.7

NAME                                                         RESOLVE                                                      ANNOTATION
------------------------------------------------------------ ------------------------------------------------------------ --------------------------------------------------------------------------------
audIsSenCol                                                  (aud)IsSenCol                                                audit ??
audOptTab                                                    (aud)OptTab                                                  audit ??
audstwlk                                                     (aud)stwlk                                                   audit ??
kcfis_clear_lob                                              (kcfis)_clear_lob                                            kernel cache file management intelligent storage ??
kclcsb                                                       (kcl)csb                                                     kernel cache lock manager/buffer cache ??
kds_update_turbo_scan_pivot_statistics                       (kds)_update_turbo_scan_pivot_statistics                     kernel data seek/scan ??
kesdtcbResetDiagEvent                                        (kes)dtcbResetDiagEvent                                      kernel event SQL manageability ??
kfdDskComputeHashForRow                                      (kfd)DskComputeHashForRow                                    kernel automatic storage management disk ??
kfdp_chkSufOlnFGAvl                                          (kfdp)_chkSufOlnFGAvl                                        kernel automatic storage management disk PST ??
kfioSrMsgBuf_ack                                             (kfio)SrMsgBuf_ack                                           kernel automatic storage management translation I/O layer ??
kfkcrRefresh                                                 (kfk)crRefresh                                               kernel automatic storage management KFK ??
kfnFreeKfnpnmMem                                             (kfn)FreeKfnpnmMem                                           kernel automatic storage management networking subsystem ??
kgfvTermSkvol                                                (kgf)vTermSkvol                                              kernel generic ASM ??
kjznhcdn                                                     (kjzn)hcdn                                                   kernel lock management DIAG node layer ??
kjznhcds                                                     (kjzn)hcds                                                   kernel lock management DIAG node layer ??
kkopinlpInt                                                  (kko)pinlpInt                                                kernel compile optimizer ??
kkquIsCorrTransInList                                        (kkqu)IsCorrTransInList                                      kernel compile query  subquery unnesting ??
knlpmaxfmsgsize                                              (knl)pmaxfmsgsize                                            kernel replication streams replication ??
kpuxsoCurPrefetchFree                                        (kpu)xsoCurPrefetchFree                                      kernel programmatic interface user ??
kpuxsoDocContentSet                                          (kpu)xsoDocContentSet                                        kernel programmatic interface user ??
kpuxsoOperInit                                               (kpu)xsoOperInit                                             kernel programmatic interface user ??
krb_devtype_chk                                              (krb)_devtype_chk                                            kernel redo backup/restore ??
krvxgtf                                                      (krvx)gtf                                                    kernel redo recovery extract ??
krvxrsr_SkipRedo                                             (krvx)rsr_SkipRedo                                           kernel redo recovery extract ??
kzan_set_ddl_lock_timeout                                    (kza)n_set_ddl_lock_timeout                                  kernel security audit  ??
kzckmWalletInArchive                                         (kzck)mWalletInArchive                                       kernel security Code-Based Access Control encryption support ??
kzckmrOpenRootOnPlug                                         (kzck)mrOpenRootOnPlug                                       kernel security Code-Based Access Control encryption support ??
kzckmrXmlVldTDEKeys                                          (kzck)mrXmlVldTDEKeys                                        kernel security Code-Based Access Control encryption support ??
kzckmrXmlVldTDEKeysFile                                      (kzck)mrXmlVldTDEKeysFile                                    kernel security Code-Based Access Control encryption support ??
kzckmrXmlVldTDEMetaHSM                                       (kzck)mrXmlVldTDEMetaHSM                                     kernel security Code-Based Access Control encryption support ??
pfrcrt                                                       (pfr)crt                                                     PLSQL Code Execution runtime ??
qsodasqlGetContentDefine                                     (qsoda)sqlGetContentDefine                                   query system DBMS_SODA ??
qsodasqlGetCreatedOnDefine                                   (qsoda)sqlGetCreatedOnDefine                                 query system DBMS_SODA ??
qsodasqlGetInsertSQL                                         (qsoda)sqlGetInsertSQL                                       query system DBMS_SODA ??
qsodasqlGetKeyDefine                                         (qsoda)sqlGetKeyDefine                                       query system DBMS_SODA ??
qsodasqlGetLastModDefine                                     (qsoda)sqlGetLastModDefine                                   query system DBMS_SODA ??
qsodasqlGetMediaDefine                                       (qsoda)sqlGetMediaDefine                                     query system DBMS_SODA ??
qsodasqlGetVersionDefine                                     (qsoda)sqlGetVersionDefine                                   query system DBMS_SODA ??
qsodasqlPrefetchPrepare                                      (qsoda)sqlPrefetchPrepare                                    query system DBMS_SODA ??
qsodasqlSelectDocFieldsSQL                                   (qsoda)sqlSelectDocFieldsSQL                                 query system DBMS_SODA ??
qsodaxArrayFetchDocuments                                    (qsoda)xArrayFetchDocuments                                  query system DBMS_SODA ??
qsodaxDefineDocumentFields                                   (qsoda)xDefineDocumentFields                                 query system DBMS_SODA ??
qsodaxGetPrefetchDocument                                    (qsoda)xGetPrefetchDocument                                  query system DBMS_SODA ??
slmeset_s                                                    (sl)meset_s                                                  operating system (dependent) library ??

It seems that the most eye-catching difference between Oracle database versions 19.5 and 19.4 is three underscore parameters spare parameters being changed to specifically named underscore parameters, two of them have a bug number in them which is not publicly visible.

In v$sysstat/v$sesstat, a group of statistics are renamed from ‘OS %’ to ‘Server %’. All these statistics are about networking. One changed parameter directly points to networking (tcpinfo). These statistics are added in version 19.

One DBA view was added: DBA_DV_COMMON_OPERATION_STATUS. This view is specific and owned by to DVSYS.

NAME
--------------------------------------------------
_fourth_spare_parameter
_one-hundred-and-fifty-third_spare_parameter
_one-hundred-and-forty-sixth_spare_parameter

parameters unique in version 19.5 versus 19.4

NAME
--------------------------------------------------
_bug29302220_tcpinfo_statistics_save_atexit
_bug29903454_ksws_enable_alb
_session_modp_list

parameter values changed isdefault between 19.4 versus 19.5

parameter values unique to 19.4 versus 19.5

parameter values unique to 19.5 versus 19.4

waitevents unique in version 19.4 versus 19.5

waitevents unique in version 19.5 versus 19.4

waitevents changed parameter description between 19.4 versus 19.5

x$ tables unique to 19.4 versus 19.5

x$ tables unique to 19.5 versus 19.4

x$ tables columns unique to 19.4 versus 19.5

x$ tables columns unique to 19.5 versus 19.4

v$ tables unique to 19.4 versus 19.5

v$ tables unique to 19.5 versus 19.4

v$ tables columns unique to 19.4 versus 19.5

v$ tables columns unique to 19.5 versus 19.4

gv$ tables unique to 19.4 versus 19.5

gv$ tables unique to 19.5 versus 19.4

gv$ tables columns unique to 19.4 versus 19.5

gv$ tables columns unique to 19.5 versus 19.4

sysstat statistics unique to 19.4 versus 19.5

NAME
----------------------------------------------------------------------------------------------------
OS Advertised Receive Window
OS Advertised Send Window
OS Data Segments In
OS Data Segments Out
OS Lost Packets
OS Path Maximum Transmission Unit(MTU)
OS Send Congestion Window
OS Time (usec) Busy Sending Data
OS Time (usec) Busy Sending Data under Congestion
OS Time (usec) Last Ack Received
OS Time (usec) Last Ack Sent
OS Time (usec) Last Data Received
OS Time (usec) Last Data Sent
OS Time (usec) Limited by Receive Window
OS Time (usec) Limited by Send Buffer
OS Time (usec) Round Trip Time
OS Time (usec) Round Trip Time Variance
OS Total Bytes Acked
OS Total Bytes Received
OS Total Number of Retransmitted Packets

sysstat statistics unique to 19.5 versus 19.4

NAME
----------------------------------------------------------------------------------------------------
Server Advertised Receive Window
Server Advertised Send Window
Server Data Segments In
Server Data Segments Out
Server Elapsed Time (msec) Last Ack Received
Server Elapsed Time (msec) Last Ack Sent
Server Elapsed Time (msec) Last Data Received
Server Elapsed Time (msec) Last Data Sent
Server Lost Packets
Server Path Maximum Transmission Unit(MTU)
Server Send Congestion Window
Server Time (usec) Approximate Elapsed Time from the packet dro
Server Time (usec) Busy Sending Data
Server Time (usec) Limited by Receive Window
Server Time (usec) Limited by Send Buffer
Server Time (usec) Round Trip Time
Server Time (usec) Round Trip Time Variance
Server Total Bytes Acked
Server Total Bytes Received
Server Total Number of Retransmitted Packets

sys_time_model statistics unique to 19.4 versus 19.5

sys_time_model statistics unique to 19.5 versus 19.4

dba tables unique to 19.4 versus 19.5

dba tables unique to 19.5 versus 19.4

NAME
----------------------------------------------------------------------------------------------------
DBA_DV_COMMON_OPERATION_STATUS

dba tables columns unique to 19.5 versus 19.4

dba tables columns unique to 19.4 versus 19.5

cdb tables unique to 19.4 versus 19.5

cdb tables unique to 19.5 versus 19.4

cdb tables column unique to 19.4 versus 19.5

cdb tables column unique to 19.5 versus 19.4

And here are the differences in symbols (c functions).
The functions unique to 19.4 versus 19.5 (alias removed) are partly jon thus java related functions, which all have ‘domain’ in the name. Plus some diverse functions.

There is a significant amount number of functions added. The first ones starting with ‘aux_’ and ‘decode_krb5’ might have something to do with ‘krb5’, alias Kerberos version 5.

There is a ‘dbnest_dir_check’ function in between ‘aux’ and ‘decode’. It seems ‘dbnest’ is an entire layer in the database code at least, however I do not know if it relates to something that is public knowledge.

Among all kinds of singular added functions, what further is noticeable, is a high number of ASM related functions being added, of which a lot of them refer to ‘oss’ (oracle storage server?).

Additionally, a bunch of ‘ksp_modp’ functions are added which might have something to do with the ‘_session_modp_list’ parameter, and a bunch of parameters starting with ‘ksws_alb’ which might have something to do with the ‘_bug29903454_ksws_enable_alb’ parameter.

Further a group of functions starting with ‘soda’, which might be related to DBMS_SODA: a package implementing Simple Oracle Document Access (SODA), for managing document collections using PL/SQL.

code symbol names unique in version 19.4 versus 19.5

NAME                                                         RESOLVE                                                      ANNOTATION
------------------------------------------------------------ ------------------------------------------------------------ --------------------------------------------------------------------------------
drexogidx                                                    (drex)ogidx                                                  text index query ??
joncl_at_domains                                             (jon)cl_at_domains                                           java ??
joncl_domains                                                (jon)cl_domains                                              java ??
joncl_set_domains                                            (jon)cl_set_domains                                          java ??
joncl_snor_domains                                           (jon)cl_snor_domains                                         java ??
joniul_at_domains                                            (jon)iul_at_domains                                          java ??
joniul_domains                                               (jon)iul_domains                                             java ??
joniul_set_domains                                           (jon)iul_set_domains                                         java ??
joniul_snor_domains                                          (jon)iul_snor_domains                                        java ??
jonndl_at_domains                                            (jon)ndl_at_domains                                          java ??
jonndl_domains                                               (jon)ndl_domains                                             java ??
jonndl_set_domains                                           (jon)ndl_set_domains                                         java ??
jonndl_snor_domains                                          (jon)ndl_snor_domains                                        java ??
jonoce_at_domains                                            (jon)oce_at_domains                                          java ??
jonoce_domains                                               (jon)oce_domains                                             java ??
jonoce_set_domains                                           (jon)oce_set_domains                                         java ??
jonoce_snor_domains                                          (jon)oce_snor_domains                                        java ??
jonosd_at_domains                                            (jon)osd_at_domains                                          java ??
jonosd_domains                                               (jon)osd_domains                                             java ??
jonosd_set_domains                                           (jon)osd_set_domains                                         java ??
jonosd_snor_domains                                          (jon)osd_snor_domains                                        java ??
jonvcl_at_domains                                            (jon)vcl_at_domains                                          java ??
jonvcl_domains                                               (jon)vcl_domains                                             java ??
jonvcl_set_domains                                           (jon)vcl_set_domains                                         java ??
jonvcl_snor_domains                                          (jon)vcl_snor_domains                                        java ??
jsv_try_scan_3choice                                         (js)v_try_scan_3choice                                       job scheduing ??
kcbtse_raise_tbs_datafile_enc_mismatch_error                 (kcbtse)_raise_tbs_datafile_enc_mismatch_error               kernel cache buffers tablespace encryption ??
kffgAttrMaxPxCb                                              (kffg)AttrMaxPxCb                                            kernel automatic storage management KFF file group ??
kffgVolClientCheck                                           (kffg)VolClientCheck                                         kernel automatic storage management KFF file group ??
kgiflini                                                     (kgi)flini                                                   kernel generic instantiation manager ??
kgiflpop                                                     (kgi)flpop                                                   kernel generic instantiation manager ??
kjgcr_GetTopCPU                                              (kj)gcr_GetTopCPU                                            kernel lock management ??
kjgcr_RunSyncTask                                            (kj)gcr_RunSyncTask                                          kernel lock management ??
kjgcr_SlaveReqGetSlot                                        (kj)gcr_SlaveReqGetSlot                                      kernel lock management ??
kkdlpGetObjn                                                 (kkdl)pGetObjn                                               kernel compile dictionary lookup ??
kkjcjchk                                                     (kkj)cjchk                                                   kernel compile job queue ??
kkoarFreeCtx                                                 (kkoar)FreeCtx                                               kernel compile optimizer automatic (sql) reoptimisation ??
kkoarFreeStats                                               (kkoar)FreeStats                                             kernel compile optimizer automatic (sql) reoptimisation ??
kkqojeFroNoRid                                               (kkqoj)eFroNoRid                                             kernel compile query  outer join ??
kkquIsCorrTransInList                                        (kkqu)IsCorrTransInList                                      kernel compile query  subquery unnesting ??
kslsesftcb_int                                               (ksl)sesftcb_int                                             kernel service (VOS) latching and post-wait ??
ktcsnaInitMinActScnInEnv                                     (ktc)snaInitMinActScnInEnv                                   kernel transaction control component ??
nsmplxhash                                                   (ns)mplxhash                                                 network session ??
pdy7F89_Create_Frame_Descriptor                              (pdy)7F89_Create_Frame_Descriptor                            PLSQL code execution codegen MCode gen ??
pdzdM60_Make_RBST                                            (pdz)dM60_Make_RBST                                          PLSQL code execution codegen infrastructure ??
pdzdM66_Insert_At_Root                                       (pdz)dM66_Insert_At_Root                                     PLSQL code execution codegen infrastructure ??
pdzdM67_Create                                               (pdz)dM67_Create                                             PLSQL code execution codegen infrastructure ??
qerocnStart                                                  (qeroc)nStart                                                query execute rowsource object collection iterator ??
qesmmCUpdProfile                                             (qesmm)CUpdProfile                                           query execute services memory manager (pga) ??
qosdMonNonCGCol                                              (qosd)MonNonCGCol                                            query optimizer statistics sql plan directive ??
qsodasqlGetInsertOneSQL                                      (qsoda)sqlGetInsertOneSQL                                    query system DBMS_SODA ??

code symbol names unique in version 19.5 versus 19.4

NAME                                                         RESOLVE                                                      ANNOTATION
------------------------------------------------------------ ------------------------------------------------------------ --------------------------------------------------------------------------------
aux_loadptr_external_principal_identifier_ptr                aux_loadptr_external_principal_identifier_ptr                ??
aux_loadptr_pkinit_krb5_principal_name                       aux_loadptr_pkinit_krb5_principal_name                       ??
aux_loadptr_ptr_kdf_alg_id                                   aux_loadptr_ptr_kdf_alg_id                                   ??
aux_loadptr_ptr_seqof_external_principal_identifier          aux_loadptr_ptr_seqof_external_principal_identifier          ??
aux_loadptr_ptr_supported_kdfs                               aux_loadptr_ptr_supported_kdfs                               ??
aux_loadptr_subject_pk_info_ptr                              aux_loadptr_subject_pk_info_ptr                              ??
aux_present_opt_ptr_kdf_alg_id                               aux_present_opt_ptr_kdf_alg_id                               ??
aux_present_opt_ptr_seqof_external_principal_identifier      aux_present_opt_ptr_seqof_external_principal_identifier      ??
aux_present_opt_ptr_supported_kdfs                           aux_present_opt_ptr_supported_kdfs                           ??
aux_present_opt_subject_pk_info_ptr                          aux_present_opt_subject_pk_info_ptr                          ??
aux_storeptr_external_principal_identifier_ptr               aux_storeptr_external_principal_identifier_ptr               ??
aux_storeptr_pkinit_krb5_principal_name                      aux_storeptr_pkinit_krb5_principal_name                      ??
aux_storeptr_ptr_kdf_alg_id                                  aux_storeptr_ptr_kdf_alg_id                                  ??
aux_storeptr_ptr_seqof_external_principal_identifier         aux_storeptr_ptr_seqof_external_principal_identifier         ??
aux_storeptr_ptr_supported_kdfs                              aux_storeptr_ptr_supported_kdfs                              ??
aux_storeptr_subject_pk_info_ptr                             aux_storeptr_subject_pk_info_ptr                             ??
dbnest_dir_check                                             dbnest_dir_check                                             ??
decode_krb5_auth_pack                                        decode_krb5_auth_pack                                        ??
decode_krb5_auth_pack_draft9                                 decode_krb5_auth_pack_draft9                                 ??
decode_krb5_kdc_dh_key_info                                  decode_krb5_kdc_dh_key_info                                  ??
decode_krb5_pa_pk_as_rep                                     decode_krb5_pa_pk_as_rep                                     ??
decode_krb5_pa_pk_as_req                                     decode_krb5_pa_pk_as_req                                     ??
decode_krb5_pa_pk_as_req_draft9                              decode_krb5_pa_pk_as_req_draft9                              ??
decode_krb5_principal_name                                   decode_krb5_principal_name                                   ??
decode_krb5_reply_key_pack                                   decode_krb5_reply_key_pack                                   ??
decode_krb5_reply_key_pack_draft9                            decode_krb5_reply_key_pack_draft9                            ??
decode_krb5_td_dh_parameters                                 decode_krb5_td_dh_parameters                                 ??
decode_krb5_td_trusted_certifiers                            decode_krb5_td_trusted_certifiers                            ??
encode_krb5_auth_pack                                        encode_krb5_auth_pack                                        ??
encode_krb5_auth_pack_draft9                                 encode_krb5_auth_pack_draft9                                 ??
encode_krb5_kdc_dh_key_info                                  encode_krb5_kdc_dh_key_info                                  ??
encode_krb5_pa_pk_as_rep                                     encode_krb5_pa_pk_as_rep                                     ??
encode_krb5_pa_pk_as_rep_draft9                              encode_krb5_pa_pk_as_rep_draft9                              ??
encode_krb5_pa_pk_as_req                                     encode_krb5_pa_pk_as_req                                     ??
encode_krb5_pa_pk_as_req_draft9                              encode_krb5_pa_pk_as_req_draft9                              ??
encode_krb5_reply_key_pack                                   encode_krb5_reply_key_pack                                   ??
encode_krb5_reply_key_pack_draft9                            encode_krb5_reply_key_pack_draft9                            ??
encode_krb5_td_dh_parameters                                 encode_krb5_td_dh_parameters                                 ??
encode_krb5_td_trusted_certifiers                            encode_krb5_td_trusted_certifiers                            ??
kafcpy_one_row                                               (kaf)cpy_one_row                                             kernel access fetch ??
kcbflc_reap_internal                                         (kcb)flc_reap_internal                                       kernel cache buffers ??
kcbo_incr_doc                                                (kcbo)_incr_doc                                              kernel cache buffers object queue ??
kcbtse_raise_tbs_datafile_enc_mismatch                       (kcbtse)_raise_tbs_datafile_enc_mismatch                     kernel cache buffers tablespace encryption ??
kcfis_clear_lob                                              (kcfis)_clear_lob                                            kernel cache file management intelligent storage ??
kcslcu8                                                      (kcs)lcu8                                                    kernel cache scn management ??
kdilm_row_diskcompress_policy_type                           (kdil)m_row_diskcompress_policy_type                         kernel data index load ??
kdiss_optimize                                               (kdiss)_optimize                                             kernel data index split skip scan ??
kdlfForcedType                                               (kdl)fForcedType                                             kernel data lob ??
kdmrIMCULoadAvg                                              (kdmr)IMCULoadAvg                                            kernel data in-memory data layer background ??
kewraxc_attribute_xcb                                        (kewr)axc_attribute_xcb                                      kernel event AWR repository ??
kewxgenstbcb                                                 (kewx)genstbcb                                               kernel event AWR sysaux? ??
kewxgsc_generic_space_cbf                                    (kewx)gsc_generic_space_cbf                                  kernel event AWR sysaux? ??
kfIsZdlra                                                    (kf)IsZdlra                                                  kernel automatic storage management ??
kfdDskComputeHashForRow                                      (kfd)DskComputeHashForRow                                    kernel automatic storage management disk ??
kfdDskTableCbInternal                                        (kfd)DskTableCbInternal                                      kernel automatic storage management disk ??
kffgAddChildBlk                                              (kffg)AddChildBlk                                            kernel automatic storage management KFF file group ??
kffgAddDefault                                               (kffg)AddDefault                                             kernel automatic storage management KFF file group ??
kffgAttrMaxParCb                                             (kffg)AttrMaxParCb                                           kernel automatic storage management KFF file group ??
kffgAttrParSchmOvrdCb                                        (kffg)AttrParSchmOvrdCb                                      kernel automatic storage management KFF file group ??
kffgAuthenticate                                             (kffg)Authenticate                                           kernel automatic storage management KFF file group ??
kffgCalDeltaRedChg                                           (kffg)CalDeltaRedChg                                         kernel automatic storage management KFF file group ??
kffgCalRealQuota                                             (kffg)CalRealQuota                                           kernel automatic storage management KFF file group ??
kffgCalTargetRedun                                           (kffg)CalTargetRedun                                         kernel automatic storage management KFF file group ??
kffgCmp                                                      (kffg)Cmp                                                    kernel automatic storage management KFF file group ??
kffgFillFg                                                   (kffg)FillFg                                                 kernel automatic storage management KFF file group ??
kffgFindFree                                                 (kffg)FindFree                                               kernel automatic storage management KFF file group ??
kffgGetParOvrd                                               (kffg)GetParOvrd                                             kernel automatic storage management KFF file group ??
kffgIsParitySupported                                        (kffg)IsParitySupported                                      kernel automatic storage management KFF file group ??
kffgIsRedunAvailable                                         (kffg)IsRedunAvailable                                       kernel automatic storage management KFF file group ??
kffgIsUnsplit                                                (kffg)IsUnsplit                                              kernel automatic storage management KFF file group ??
kffgMakeName                                                 (kffg)MakeName                                               kernel automatic storage management KFF file group ??
kffgParseParOvrd                                             (kffg)ParseParOvrd                                           kernel automatic storage management KFF file group ??
kffgVerifyRedunChg                                           (kffg)VerifyRedunChg                                         kernel automatic storage management KFF file group ??
kffgcSyncDBLazy                                              (kffg)cSyncDBLazy                                            kernel automatic storage management KFF file group ??
kffgcSyncEnd                                                 (kffg)cSyncEnd                                               kernel automatic storage management KFF file group ??
kffgftMap                                                    (kffg)ftMap                                                  kernel automatic storage management KFF file group ??
kffgptAddDefault                                             (kffg)ptAddDefault                                           kernel automatic storage management KFF file group ??
kffgptFixRedun                                               (kffg)ptFixRedun                                             kernel automatic storage management KFF file group ??
kffgptGetStrVal                                              (kffg)ptGetStrVal                                            kernel automatic storage management KFF file group ??
kffgptLookup                                                 (kffg)ptLookup                                               kernel automatic storage management KFF file group ??
kffgptLookupDump                                             (kffg)ptLookupDump                                           kernel automatic storage management KFF file group ??
kffgptParseNum                                               (kffg)ptParseNum                                             kernel automatic storage management KFF file group ??
kfgComputeGrpProp                                            (kfg)ComputeGrpProp                                          kernel automatic storage management diskgroups ??
kfgGrpTableCbInternal                                        (kfg)GrpTableCbInternal                                      kernel automatic storage management diskgroups ??
kfiQuantize2                                                 (kf)iQuantize2                                               kernel automatic storage management ??
kfioComputeStripeIndex                                       (kfio)ComputeStripeIndex                                     kernel automatic storage management translation I/O layer ??
kfioGetXSetSize                                              (kfio)GetXSetSize                                            kernel automatic storage management translation I/O layer ??
kfioLoadParity                                               (kfio)LoadParity                                             kernel automatic storage management translation I/O layer ??
kfioParityWriteBegin                                         (kfio)ParityWriteBegin                                       kernel automatic storage management translation I/O layer ??
kfk_alloc_kfkio_freelist                                     (kfk)_alloc_kfkio_freelist                                   kernel automatic storage management KFK ??
kfk_asm_ioerror                                              (kfk)_asm_ioerror                                            kernel automatic storage management KFK ??
kfk_bld_sbmtptr_arry                                         (kfk)_bld_sbmtptr_arry                                       kernel automatic storage management KFK ??
kfk_bld_waitptr_arry                                         (kfk)_bld_waitptr_arry                                       kernel automatic storage management KFK ??
kfk_block_asmlib                                             (kfk)_block_asmlib                                           kernel automatic storage management KFK ??
kfk_block_oss                                                (kfk)_block_oss                                              kernel automatic storage management KFK ??
kfk_block_ufs                                                (kfk)_block_ufs                                              kernel automatic storage management KFK ??
kfk_build_osdstruct                                          (kfk)_build_osdstruct                                        kernel automatic storage management KFK ??
kfk_chk_xor_valid                                            (kfk)_chk_xor_valid                                          kernel automatic storage management KFK ??
kfk_do_abn_xor_chk                                           (kfk)_do_abn_xor_chk                                         kernel automatic storage management KFK ??
kfk_error_emulate                                            (kfk)_error_emulate                                          kernel automatic storage management KFK ??
kfk_fill_ksfdrq                                              (kfk)_fill_ksfdrq                                            kernel automatic storage management KFK ??
kfk_find_io_subsys                                           (kfk)_find_io_subsys                                         kernel automatic storage management KFK ??
kfk_get_asmioc_oper                                          (kfk)_get_asmioc_oper                                        kernel automatic storage management KFK ??
kfk_get_free_kfkrq                                           (kfk)_get_free_kfkrq                                         kernel automatic storage management KFK ??
kfk_get_unreaped_ios                                         (kfk)_get_unreaped_ios                                       kernel automatic storage management KFK ??
kfk_hard_abn_set                                             (kfk)_hard_abn_set                                           kernel automatic storage management KFK ??
kfk_hard_getoffs                                             (kfk)_hard_getoffs                                           kernel automatic storage management KFK ??
kfk_iodone_merge_slave                                       (kfk)_iodone_merge_slave                                     kernel automatic storage management KFK ??
kfk_lib_abn_check                                            (kfk)_lib_abn_check                                          kernel automatic storage management KFK ??
kfk_lib_xor_check                                            (kfk)_lib_xor_check                                          kernel automatic storage management KFK ??
kfk_oss_cell_timedout                                        (kfk)_oss_cell_timedout                                      kernel automatic storage management KFK ??
kfk_oss_dump_orq                                             (kfk)_oss_dump_orq                                           kernel automatic storage management KFK ??
kfk_oss_get_orq                                              (kfk)_oss_get_orq                                            kernel automatic storage management KFK ??
kfk_oss_offload_fill_orq                                     (kfk)_oss_offload_fill_orq                                   kernel automatic storage management KFK ??
kfk_oss_offload_submit                                       (kfk)_oss_offload_submit                                     kernel automatic storage management KFK ??
kfk_oss_post_wait                                            (kfk)_oss_post_wait                                          kernel automatic storage management KFK ??
kfk_oss_put_orq                                              (kfk)_oss_put_orq                                            kernel automatic storage management KFK ??
kfk_parse_disk_path                                          (kfk)_parse_disk_path                                        kernel automatic storage management KFK ??
kfk_proc_submitted_lib_reqs                                  (kfk)_proc_submitted_lib_reqs                                kernel automatic storage management KFK ??
kfk_process_an_ioq                                           (kfk)_process_an_ioq                                         kernel automatic storage management KFK ??
kfk_put_free_kfkios                                          (kfk)_put_free_kfkios                                        kernel automatic storage management KFK ??
kfk_reap_io_from_kfks                                        (kfk)_reap_io_from_kfks                                      kernel automatic storage management KFK ??
kfk_reap_lib_async_io                                        (kfk)_reap_lib_async_io                                      kernel automatic storage management KFK ??
kfk_reap_oss_async_io                                        (kfk)_reap_oss_async_io                                      kernel automatic storage management KFK ??
kfk_reap_ufs_async_io                                        (kfk)_reap_ufs_async_io                                      kernel automatic storage management KFK ??
kfk_rebuild_kfdrqs                                           (kfk)_rebuild_kfdrqs                                         kernel automatic storage management KFK ??
kfk_retry_submit_oss_io                                      (kfk)_retry_submit_oss_io                                    kernel automatic storage management KFK ??
kfk_submit_lib_io                                            (kfk)_submit_lib_io                                          kernel automatic storage management KFK ??
kfk_submit_oss_io                                            (kfk)_submit_oss_io                                          kernel automatic storage management KFK ??
kfk_submit_oss_io_no_wtevt                                   (kfk)_submit_oss_io_no_wtevt                                 kernel automatic storage management KFK ??
kfk_submit_oss_io_wtevt                                      (kfk)_submit_oss_io_wtevt                                    kernel automatic storage management KFK ??
kfk_submit_ufs_io                                            (kfk)_submit_ufs_io                                          kernel automatic storage management KFK ??
kfk_transit_fetchIO                                          (kfk)_transit_fetchIO                                        kernel automatic storage management KFK ??
kfk_transit_waitIO                                           (kfk)_transit_waitIO                                         kernel automatic storage management KFK ??
kfk_update_iodone_stats                                      (kfk)_update_iodone_stats                                    kernel automatic storage management KFK ??
kfk_zero_reap_array                                          (kfk)_zero_reap_array                                        kernel automatic storage management KFK ??
kfmdIsDGMountedCluster                                       (kfmd)IsDGMountedCluster                                     kernel automatic storage management node monitor interface implementation layer
                                                                                                                          for diskgroup registration ??

kfmsGetGrpMemCnt                                             (kfms)GetGrpMemCnt                                           kernel automatic storage management node monitor interface implementation layers
                                                                                                                           support function interface ??

kgfdDiscoverSubmit                                           (kgfd)DiscoverSubmit                                         kernel generic ASM io subsystem driver ??
kgh_size_sanity_check                                        (kgh)_size_sanity_check                                      kernel generic heap manager ??
kjac_allow_tg                                                (kjac)_allow_tg                                              kernel lock management application continuity  ??
kjccspbat                                                    (kjc)cspbat                                                  kernel lock management communication ??
kkocfbFindOldActual                                          (kkocfb)FindOldActual                                        kernel compile optimizer cardinality feedback ??
kkopinlpInt                                                  (kko)pinlpInt                                                kernel compile optimizer ??
kkscsGetPQSharingParameters                                  (kkscs)GetPQSharingParameters                                kernel compile shared objects (cursor) child cursor ??
kkscsGetSessionLimitDOP                                      (kkscs)GetSessionLimitDOP                                    kernel compile shared objects (cursor) child cursor ??
kokegAddOneGarbageItem                                       (koke)gAddOneGarbageItem                                     kernel objects kernel side OBJECTS images ??
kokegRepinLob                                                (koke)gRepinLob                                              kernel objects kernel side OBJECTS images ??
kpochalts                                                    (kpo)chalts                                                  kernel programmatic interface oracle ??
kpossGetEncNonTemplateOverflow                               (kpo)ssGetEncNonTemplateOverflow                             kernel programmatic interface oracle ??
kpossSetEncNonTemplateOverflow                               (kpo)ssSetEncNonTemplateOverflow                             kernel programmatic interface oracle ??
kpossTemplateMatch_                                          (kpo)ssTemplateMatch_                                        kernel programmatic interface oracle ??
kpossTemplateSet                                             (kpo)ssTemplateSet                                           kernel programmatic interface oracle ??
kpueONSTraceWrite                                            (kpu)eONSTraceWrite                                          kernel programmatic interface user ??
kpueONSTrcCb                                                 (kpu)eONSTrcCb                                               kernel programmatic interface user ??
kpussTemplateSend                                            (kpu)ssTemplateSend                                          kernel programmatic interface user ??
kpuxcOpenCurCntDecr                                          (kpu)xcOpenCurCntDecr                                        kernel programmatic interface user ??
kpuxcOpenCurCntIncr                                          (kpu)xcOpenCurCntIncr                                        kernel programmatic interface user ??
kpuxcRefCurDfnMarkOpen                                       (kpu)xcRefCurDfnMarkOpen                                     kernel programmatic interface user ??
kpuxcRefCurOutBndMarkOpen                                    (kpu)xcRefCurOutBndMarkOpen                                  kernel programmatic interface user ??
kpuxcSessionSignatureRecv                                    (kpu)xcSessionSignatureRecv                                  kernel programmatic interface user ??
kpuxcSessionTemplateSend                                     (kpu)xcSessionTemplateSend                                   kernel programmatic interface user ??
kpuxcSessionTemplatesFree                                    (kpu)xcSessionTemplatesFree                                  kernel programmatic interface user ??
kpuxcTACService                                              (kpu)xcTACService                                            kernel programmatic interface user ??
kpuxsoCurPrefetchFree                                        (kpu)xsoCurPrefetchFree                                      kernel programmatic interface user ??
kpuxsoOperInit                                               (kpu)xsoOperInit                                             kernel programmatic interface user ??
krbbCountThreads                                             (krbb)CountThreads                                           kernel redo backup/restore creation of a backuppiece ??
ksdhng_wdat_rem_dup                                          (ksdhng)_wdat_rem_dup                                        kernel service (VOS) debug internal errors hang analyze ??
ksfdafGetXsetSize                                            (ksfdaf)GetXsetSize                                          kernel service (VOS) functions disk IO asm files ??
ksfdafParityWrite                                            (ksfdaf)ParityWrite                                          kernel service (VOS) functions disk IO asm files ??
ksfdafParityWriteAbort                                       (ksfdaf)ParityWriteAbort                                     kernel service (VOS) functions disk IO asm files ??
ksfdafParityWriteBegin                                       (ksfdaf)ParityWriteBegin                                     kernel service (VOS) functions disk IO asm files ??
ksfdafParityWriteEnd                                         (ksfdaf)ParityWriteEnd                                       kernel service (VOS) functions disk IO asm files ??
kslwt_event_stats                                            (kslwt)_event_stats                                          kernel service (VOS) latching and post-wait wait interface ??
kslwt_push_stats                                             (kslwt)_push_stats                                           kernel service (VOS) latching and post-wait wait interface ??
ksmsq_spendingi                                              (ksmsq)_spendingi                                            kernel service (VOS) memory sga heap message queue services ??
ksp_init_modp_send                                           (ksp)_init_modp_send                                         kernel service (VOS) parameter ??
ksp_modp_get_enckeyvals                                      (ksp)_modp_get_enckeyvals                                    kernel service (VOS) parameter ??
ksp_modp_get_keyvals                                         (ksp)_modp_get_keyvals                                       kernel service (VOS) parameter ??
ksp_modp_set_enckeyvals                                      (ksp)_modp_set_enckeyvals                                    kernel service (VOS) parameter ??
ksp_modp_set_keyvals                                         (ksp)_modp_set_keyvals                                       kernel service (VOS) parameter ??
ksp_modp_update_sign                                         (ksp)_modp_update_sign                                       kernel service (VOS) parameter ??
kspdecbuf                                                    (ksp)decbuf                                                  kernel service (VOS) parameter ??
kspencbuf                                                    (ksp)encbuf                                                  kernel service (VOS) parameter ??
ksucln_expired_cleanup_timer                                 (ksucln)_expired_cleanup_timer                               kernel service (VOS) user cleanup detached process ??
kswrListDelete                                               (ksw)rListDelete                                             kernel service (VOS) workgroup ??
ksws_alb_alloc_pga_memory                                    (ksws)_alb_alloc_pga_memory                                  kernel service (VOS) workgroup services ??
ksws_alb_block_service                                       (ksws)_alb_block_service                                     kernel service (VOS) workgroup services ??
ksws_alb_check_sessions_to_mark                              (ksws)_alb_check_sessions_to_mark                            kernel service (VOS) workgroup services ??
ksws_alb_check_threshold                                     (ksws)_alb_check_threshold                                   kernel service (VOS) workgroup services ??
ksws_alb_clear_mark_drain_session                            (ksws)_alb_clear_mark_drain_session                          kernel service (VOS) workgroup services ??
ksws_alb_dump_service                                        (ksws)_alb_dump_service                                      kernel service (VOS) workgroup services ??
ksws_alb_dump_session                                        (ksws)_alb_dump_session                                      kernel service (VOS) workgroup services ??
ksws_alb_filter_session                                      (ksws)_alb_filter_session                                    kernel service (VOS) workgroup services ??
ksws_alb_mark_target_sessions                                (ksws)_alb_mark_target_sessions                              kernel service (VOS) workgroup services ??
ksws_alb_process_directives                                  (ksws)_alb_process_directives                                kernel service (VOS) workgroup services ??
ksws_alb_run_gv_sql                                          (ksws)_alb_run_gv_sql                                        kernel service (VOS) workgroup services ??
ksws_alb_safe_session                                        (ksws)_alb_safe_session                                      kernel service (VOS) workgroup services ??
ksws_alb_safe_to_block_service                               (ksws)_alb_safe_to_block_service                             kernel service (VOS) workgroup services ??
ksws_alb_selection_bias_apply                                (ksws)_alb_selection_bias_apply                              kernel service (VOS) workgroup services ??
ksws_alb_set_mark_drain_session                              (ksws)_alb_set_mark_drain_session                            kernel service (VOS) workgroup services ??
ksws_alb_unblock_fix_delta_services                          (ksws)_alb_unblock_fix_delta_services                        kernel service (VOS) workgroup services ??
ksws_alb_unblock_service                                     (ksws)_alb_unblock_service                                   kernel service (VOS) workgroup services ??
ksws_alb_update_service_session_metrics                      (ksws)_alb_update_service_session_metrics                    kernel service (VOS) workgroup services ??
ksws_alb_update_threshold                                    (ksws)_alb_update_threshold                                  kernel service (VOS) workgroup services ??
ksws_alb_valid_session                                       (ksws)_alb_valid_session                                     kernel service (VOS) workgroup services ??
kwraChkOptdef                                                (k)wraChkOptdef                                              kernel ??
kwrachkopnTree                                               (k)wrachkopnTree                                             kernel ??
kwraplschkLogdef                                             (k)wraplschkLogdef                                           kernel ??
kxccXRkxck                                                   (kxcc)XRkxck                                                 kernel execution constraints catch all ??
kzctxgIsGlobal                                               (kzctxg)IsGlobal                                             kernel security Code-Based Access Control context routines global_context ??
kzrtGetAndCheckTriggerCache                                  (kzrt)GetAndCheckTriggerCache                                kernel security virtual private database privileges ??
kzrtTriggerPresent                                           (kzrt)TriggerPresent                                         kernel security virtual private database privileges ??
kzvdveCommOpBypass                                           (kzvd)veCommOpBypass                                         kernel security data vault ??
kzvdveIsAppCommonUserId                                      (kzvd)veIsAppCommonUserId                                    kernel security data vault ??
kzvradmAllowCommOp                                           (kz)vradmAllowCommOp                                         kernel security ??
kzvradmAllowCommOpCB                                         (kz)vradmAllowCommOpCB                                       kernel security ??
kzvradmAllowCommOp_int                                       (kz)vradmAllowCommOp_int                                     kernel security ??
kzvutilGetACOStatus                                          (kz)vutilGetACOStatus                                        kernel security ??
kzvutilGetACOStatus0                                         (kz)vutilGetACOStatus0                                       kernel security ??
psdvcn                                                       (psd)vcn                                                     PLSQL infrastructure programmatic interfaces to/from  ??
qesrcTol_New                                                 (qesrc)Tol_New                                               query execute services result cache ??
qsodasqlGetContentDefine                                     (qsoda)sqlGetContentDefine                                   query system DBMS_SODA ??
qsodasqlGetCreatedOnDefine                                   (qsoda)sqlGetCreatedOnDefine                                 query system DBMS_SODA ??
qsodasqlGetInsertSQL                                         (qsoda)sqlGetInsertSQL                                       query system DBMS_SODA ??
qsodasqlGetKeyDefine                                         (qsoda)sqlGetKeyDefine                                       query system DBMS_SODA ??
qsodasqlGetLastModDefine                                     (qsoda)sqlGetLastModDefine                                   query system DBMS_SODA ??
qsodasqlGetMediaDefine                                       (qsoda)sqlGetMediaDefine                                     query system DBMS_SODA ??
qsodasqlGetVersionDefine                                     (qsoda)sqlGetVersionDefine                                   query system DBMS_SODA ??
qsodasqlPrefetchPrepare                                      (qsoda)sqlPrefetchPrepare                                    query system DBMS_SODA ??
qsodasqlSelectDocFieldsSQL                                   (qsoda)sqlSelectDocFieldsSQL                                 query system DBMS_SODA ??
qsodaxArrayFetchDocuments                                    (qsoda)xArrayFetchDocuments                                  query system DBMS_SODA ??
qsodaxDefineDocumentFields                                   (qsoda)xDefineDocumentFields                                 query system DBMS_SODA ??
qsodaxGetPrefetchDocument                                    (qsoda)xGetPrefetchDocument                                  query system DBMS_SODA ??
sskgds_dw_is_context_valid                                   (sskg)ds_dw_is_context_valid                                 operating system dependent system kernel generic ??
sskgds_dw_is_pccontext_valid                                 (sskg)ds_dw_is_pccontext_valid                               operating system dependent system kernel generic ??

In the article oracle memory troubleshooting using analysis on heap dumps I introduced heap_analyze.awk.

The reason the tool exists is because I am using it myself. Therefore, I ran into additional things that I wanted the tool to do. I added some stuff, which is that significant, that I decided to make another blogpost to introduce the new features.

1. Percentages
In order to get an idea of the relative size of the summarised topic, I added a percentage. For example:

top 5 allocation by total size per alloc reason per heap
==================================================================================================
heap             alloc_reason            #chunks       total_size   %
--------------------------------------------------------------------------------------------------
sga heap(1,0)    perm                         19        182947456  72
sga heap(1,0)                                 43         14488960   5
sga heap(1,0)    SO private sga               18         14284168   5
sga heap(1,0)    KGLHD                      5787          4318400   1
sga heap(1,0)    KSFD SGA I/O b                1          4190416   1

2. Enhanced perm (permanent) memory descriptions
It seems that for PGA heap dumps, sometimes there is a description for memory area’s that are perm (permanent memory, memory allocated for the lifetime of the process). This is how that’s visible in the dump:

PERMANENT CHUNKS:
  Chunk     7fcbcad6c020 sz=    20632    perm      "perm           "  alo=20632
            7fcbcad6c020 sz=    20632    cpmlst    "callback hsn   "

I must say I don’t know what ‘cpmlst’ means, so if anyone knows or has a good guess, please let me know. However, the two addresses and sizes are an exact match, so I now change the alloc_reason for the cpmlst text.
This is helpful because there is a quite some memory allocated as perm. Sadly, this is not done for SGA dumps.

3. Excel mode
If you want to store and compare different dumps, one way of doing that is pasting the output in Microsoft excel. Once you set the ‘Text To Columns’ option to space as a separator, it will put the information in its own cells. But there are a few problems with that, one of them is that the heap names and alloc_reasons can have spaces in them, so that the placement of the figures can vary. I created excel mode for that.
If you set excel mode (set the variable excel_mode to 1 on line 5):

#!/bin/awk -f
BEGIN {
  printf "Heap dump analyzer v0.2 by Frits Hoogland\n";
  group_sum_nr=5;
  excel_mode=1;
}

In this mode, the horizontal lines (with ‘-‘ and ‘=’) are omitted in the output, and all spaces are changed to underscores, so a table stays consistent when pasted in excel:

heap             alloc_reason            #chunks       total_size   %
sga_heap(1,0)    perm___________              19        182947456  72
sga_heap(1,0)    _______________              43         14488960   5
sga_heap(1,0)    SO_private_sga_              18         14284168   5
sga_heap(1,0)    KGLHD__________            5787          4318400   1
sga_heap(1,0)    KSFD_SGA_I/O_b_               1          4190416   1

4. New table which shows memory by type
Another way of looking at memory in a heap is by grouping it by type. This allows you to very quickly see if a certain type of chunk is dominating a heap:

heap                        type    #chunks         min_size         max_size       total_size   %
--------------------------------------------------------------------------------------------------
top call heap               free          7            16408            65512           390064  99
top call heap           recreate          2              992              992             1984   0
top call heap               perm          2              120              904             1024   0

This is an overview of the top call heap of a session that is not active, and therefore most of it should be empty, which is true for this dump.

Once again, get the awk script here: https://gitlab.com/FritsHoogland/oracle_memory_analyze/blob/master/heap_analyze.awk

This blogpost is about analysing Oracle heap dumps. It is an extension to earlier work, Tanel Poder’s heap dump analyzer. So hat tip to Tanel, he’s done the hard work, I merely increased the presentation options. The heap analyser script that I wrote analyses Oracle heapdumps from the trace file that the dump was written to by the Oracle database. Because the heap dump representation is the same between PGA and SGA memory, it can work on both. The reason for this is that memory management is done by the same memory manager, and is commonly called ‘kgh’ (kernel generic heap) managed memory.

Please mind that for PGA analysis, not all memory is managed by the kgh memory manager. For example memory used for networking (sqlnet) is allocated totally outside of the kgh memory manager.

Let’s take the output of a PGA heap dump at level 29 (PGA, UGA, CGA, top call heaps, call heaps, session heap; executed via ‘alter session set events ‘immediate trace name heapdump level 29”):

$ ./heap_analyze.awk /u01/app/oracle/diag/rdbms/tt/tt/trace/tt_ora_6515.trc
Heap dump analyzer v0.1 by Frits Hoogland
heap size totals (all sizes in bytes)
==============================================================================================
heap name                       total size
----------------------------------------------------------------------------------------------
top call heap                       393096
callheap                             36200
pga heap                           1016816
top uga heap                        262048
session heap                        261744
------------------------------------------
total                              1969904

top 5 allocation by total size per alloc reason per heap
==============================================================================================
heap             alloc reason            #chunks       total size
----------------------------------------------------------------------------------------------
top call heap                                  5           354456
top call heap    callheap                     11            37616
top call heap    perm                          2             1024
heap             alloc reason            #chunks       total size
----------------------------------------------------------------------------------------------
callheap                                      10            35920
callheap         ctxtcds: kksQui               1              160
callheap         perm                          1              120
heap             alloc reason            #chunks       total size
----------------------------------------------------------------------------------------------
pga heap         perm                         44           290256
pga heap         Fixed UGA heap                1           226232
pga heap         diag pga                     21           214048
pga heap                                       7            62616
pga heap         kfkio bucket                  1            40984
heap             alloc reason            #chunks       total size
----------------------------------------------------------------------------------------------
top uga heap     session heap                  4           261928
top uga heap     perm                          1              120
heap             alloc reason            #chunks       total size
----------------------------------------------------------------------------------------------
session heap     perm                          3            63608
session heap                                   8            63528
session heap     koh-kghu sessi                5            28288
session heap     kxsFrame4kPage                6            24912
session heap     kxsFrame8kPage                3            24744

top 5 allocations by total size per alloc reason, type, chunk size per heap
==============================================================================================
heap             alloc reason            #chunks       type       chunk size       total size
----------------------------------------------------------------------------------------------
top call heap                                  1       free           131048           131048
top call heap                                  2       free            65512           131024
top call heap                                  1       free            63496            63496
top call heap                                  1       free            28888            28888
top call heap    callheap                      6   freeable             4224            25344
heap             alloc reason            #chunks       type       chunk size       total size
----------------------------------------------------------------------------------------------
callheap                                       6       free             4184            25104
callheap                                       2       free             4192             8384
callheap                                       1       free             1784             1784
callheap                                       1       free              648              648
callheap         ctxtcds: kksQui               1   freeable              160              160
heap             alloc reason            #chunks       type       chunk size       total size
----------------------------------------------------------------------------------------------
pga heap         Fixed UGA heap                1   recreate           226232           226232
pga heap         perm                          1       perm            71720            71720
pga heap         diag pga                      1   freeable            55048            55048
pga heap         diag pga                      2   freeable            27456            54912
pga heap                                       1       free            47296            47296
heap             alloc reason            #chunks       type       chunk size       total size
----------------------------------------------------------------------------------------------
session heap     perm                          1       perm            43584            43584
session heap                                   1       free            36544            36544
session heap     kxsFrame4kPage                6   freeable             4152            24912
session heap     kxsFrame8kPage                3   freeable             8248            24744
session heap                                   1       free            20352            20352
heap             alloc reason            #chunks       type       chunk size       total size
----------------------------------------------------------------------------------------------
top uga heap     session heap                  3   freeable            65512           196536
top uga heap     session heap                  1   recreate            65392            65392
top uga heap     perm                          1       perm              120              120

top 5 allocations by total size per heap, alloc reason, type, chunk size
==============================================================================================
heap             alloc reason            #chunks       type       chunk size       total size
----------------------------------------------------------------------------------------------
pga heap         Fixed UGA heap                1   recreate           226232           226232
top uga heap     session heap                  3   freeable            65512           196536
top call heap                                  1       free           131048           131048
top call heap                                  2       free            65512           131024
pga heap         perm                          1       perm            71720            71720

I figured that the first thing you want to see, are the heaps that are in the dump, and their sizes. That’s what is visible in rows 2-12.
I summed the heap sizes, which might make sense, or it might not.
In this case, with a heap dump that includes PGA, UGA and CGA plus session and call heaps, it means there are heaps in the dump that are part of another heap that is in the dump. So the total size here is bogus. This means that you need to have an understanding of what is actually dumped.

The next section, top 5 allocations by total size per alloc reason per dump, shows a per-heap summary by the allocation reason in the dump. If there’s no alloc reason, it’s free memory. Because this is a heap dump of a session that has done nothing (I just started sqlplus and ran the dump of its own PGA memory), you see that a lot of memory chunks are free memory. If you look closely to the allocation reasons, you can see that the ‘top call heap’ has a memory section that is called ‘callheap’ which is slightly larger than the ‘callheap’ section in the heap totals, and the ‘top uga heap’ section has a memory section called ‘session heap’ that is slightly larger than the ‘session heap’ section in the heap totals. In this case, it means that you can actually see the subheads in the parent heap allocation totals. The subheap size must be slightly larger in the parent heap because of headers in the memory allocations which are needed memory management. Please mind that this is based on my knowledge of how process memory is created, the only way to be absolutely sure is that a heap is part of another heap is to look at the memory addresses. This output only shows the heap names, not the addresses. The purpose of this section is to have an understanding of where memory is allocated to in a heap.

The following section, top 5 allocations by total size per alloc reason, type, chunk size per heap shows a per-heap summary by reason, type and chunksize, so you can investigate if specific types and sizes of chunks are causing issues or weird behaviour.

The last section is the same as the previous section, but doesn’t do it per heap. This is identical to what Tanel’s heapdump_analyzer shows.

You can find the heap_analyze.awk script here: https://gitlab.com/FritsHoogland/oracle_memory_analyze/blob/master/heap_analyze.awk

This is the output of a dump of the SGA of my small test database (oradebug dump heapdump 2):

$ ./heap_analyze.awk /u01/app/oracle/diag/rdbms/tt/tt/trace/tt_ora_9461.trc
Heap dump analyzer v0.1 by Frits Hoogland
heap size totals (all sizes in bytes)
==============================================================================================
heap name                       total size
----------------------------------------------------------------------------------------------
sga heap(1,0)                    285210904
sga heap(1,3)                     83885560
------------------------------------------
total                            369096464

top 5 allocation by total size per alloc reason per heap
==============================================================================================
heap             alloc reason            #chunks       total size
----------------------------------------------------------------------------------------------
sga heap(1,0)    perm                         22        188068904
sga heap(1,0)                                141         17975320
sga heap(1,0)    SO private sga               17         14268008
sga heap(1,0)    KQR PO                     8271          7568912
sga heap(1,0)    KGLHD                      9381          7023960
heap             alloc reason            #chunks       total size
----------------------------------------------------------------------------------------------
sga heap(1,3)                                 51         14120288
sga heap(1,3)    SQLA^6d9b8a7e               337          1380352
sga heap(1,3)    SQLA^31cc505b               167           684032
sga heap(1,3)    SQLA^aab93e92               162           663552
sga heap(1,3)    PLDIA^191e0a8d              155           634880

top 5 allocations by total size per alloc reason, type, chunk size per heap
==============================================================================================
heap             alloc reason            #chunks       type       chunk size       total size
----------------------------------------------------------------------------------------------
sga heap(1,0)    perm                          1       perm         15937496         15937496
sga heap(1,0)    perm                          1       perm         15931312         15931312
sga heap(1,0)    perm                          1       perm         15811464         15811464
sga heap(1,0)    perm                          1       perm         15741952         15741952
sga heap(1,0)    perm                          1       perm         15723584         15723584
heap             alloc reason            #chunks       type       chunk size       total size
----------------------------------------------------------------------------------------------
sga heap(1,3)                                  1       free          9883208          9883208
sga heap(1,3)                                  4     R-free           839480          3357920
sga heap(1,3)    SQLA^6d9b8a7e               336  freeableU             4096          1376256
sga heap(1,3)                                  1     R-free           839360           839360
sga heap(1,3)    SQLA^31cc505b               166  freeableU             4096           679936

top 5 allocations by total size per heap, alloc reason, type, chunk size
==============================================================================================
heap             alloc reason            #chunks       type       chunk size       total size
----------------------------------------------------------------------------------------------
sga heap(1,0)    perm                          1       perm         15937496         15937496
sga heap(1,0)    perm                          1       perm         15931312         15931312
sga heap(1,0)    perm                          1       perm         15811464         15811464
sga heap(1,0)    perm                          1       perm         15741952         15741952
sga heap(1,0)    perm                          1       perm         15723584         15723584

It’s interesting to see only subpool 1 sub-sub pool 1 and 3 are used. Subpool 1,1 contains a lot of permanent allocations and a lot of allocations that might have a more permanent nature, like KQR (dictionary cache) allocations, Subpool 1,3 seems to have allocations that are deemed more transient in nature, like SQLA (sql area) allocations. This might be wildly different in databases that are actually heavily used, this is an idle lab database.

Please mind it’s important to understand that dumping the shared pool requires obtaining the respective latches, so doing that on a live production system might lead to (severe) issues. Only do this if you know what you are doing. For the PGA there can only be one using process by definition, but be careful there too, if you request a PGA dump you are interacting with memory that is deemed private by the process that is using that.

If you require more rows to be shown than the 5 that are shown, set the ‘group_sum_nr’ variable to the amount you need on row 4 of the script.

The most notable thing here is an “official” (non-underscore) parameter has been introduced with 19.4, “ignore_session_set_param_errors”. The description is: ‘Ignore errors during alter session param set’. I did a quick check to see if I could set it to true or false, which I couldn’t (resulted in an error).

With the Oracle database version 19.3 patched to 19.4 on linux, the following things have changed:

parameters unique in version 19.3 versus 19.4

NAME
--------------------------------------------------
_eighty-first_spare_parameter
_first_spare_parameter
_one-hundred-and-forty-fifth_spare_parameter
_one-hundred-and-forty-fourth_spare_parameter
_one-hundred-and-thirty-first_spare_parameter
_second_spare_parameter

parameters unique in version 19.4 versus 19.3

NAME
--------------------------------------------------
_bug27355984_xt_preproc_timeout
_bug29386835_enable_per_container_acl
_bug29394014_allow_triggers_on_vpd_table
_eighty-second_spare_parameter
_result_cache_rac_rolling
ignore_session_set_param_errors

parameter values changed isdefault between 19.3 versus 19.4

parameter values unique to 19.3 versus 19.4

parameter values unique to 19.4 versus 19.3

waitevents unique in version 19.3 versus 19.4

waitevents unique in version 19.4 versus 19.3

waitevents changed parameter description between 19.3 versus 19.4

x$ tables unique to 19.3 versus 19.4

x$ tables unique to 19.4 versus 19.3

x$ tables columns unique to 19.3 versus 19.4

x$ tables columns unique to 19.4 versus 19.3

v$ tables unique to 19.3 versus 19.4

v$ tables unique to 19.4 versus 19.3

v$ tables columns unique to 19.3 versus 19.4

v$ tables columns unique to 19.4 versus 19.3

gv$ tables unique to 19.3 versus 19.4

gv$ tables unique to 19.4 versus 19.3

gv$ tables columns unique to 19.3 versus 19.4

gv$ tables columns unique to 19.4 versus 19.3

sysstat statistics unique to 19.3 versus 19.4

sysstat statistics unique to 19.4 versus 19.3

sys_time_model statistics unique to 19.3 versus 19.4

sys_time_model statistics unique to 19.4 versus 19.3

dba tables unique to 19.3 versus 19.4

dba tables unique to 19.4 versus 19.3

dba tables columns unique to 19.4 versus 19.3

dba tables columns unique to 19.3 versus 19.4

cdb tables unique to 19.3 versus 19.4

cdb tables unique to 19.4 versus 19.3

cdb tables column unique to 19.3 versus 19.4

cdb tables column unique to 19.4 versus 19.3

And here are the differences in symbols (c functions).
Most notable are two things:
– there seem to be a lot of kkfg and kfk functions that have been removed.
– a lot of functions have been added that seem to be part of ‘little cms’, which seems to be a color management suite. I have no idea currently what these are doing in the oracle database executable.

code symbol names unique in version 19.3 versus 19.4

NAME                                                         RESOLVE                                                      ANNOTATION
------------------------------------------------------------ ------------------------------------------------------------ --------------------------------------------------------------------------------
R_CR_entropy_resource_init                                   R_CR_entropy_resource_init                                   ??
dbfsp_symlinkpp_cbk                                          dbfsp_symlinkpp_cbk                                          ??
eok_nkprberr_free_1                                          eok_nkprberr_free_1                                          ??
jonbit8_copy_from_int_array                                  (jon)bit8_copy_from_int_array                                java ??
jonbit8_copy_from_int_array__cst__                           (jon)bit8_copy_from_int_array__cst__                         java ??
jonbit8_copy_from_long_array                                 (jon)bit8_copy_from_long_array                               java ??
jonbit8_copy_from_long_array__cst__                          (jon)bit8_copy_from_long_array__cst__                        java ??
jonbit8_copy_from_short_array                                (jon)bit8_copy_from_short_array                              java ??
jonbit8_copy_from_short_array__cst__                         (jon)bit8_copy_from_short_array__cst__                       java ??
jonbit8_copy_to_int_array                                    (jon)bit8_copy_to_int_array                                  java ??
jonbit8_copy_to_int_array__cst__                             (jon)bit8_copy_to_int_array__cst__                           java ??
jonbit8_copy_to_long_array                                   (jon)bit8_copy_to_long_array                                 java ??
jonbit8_copy_to_long_array__cst__                            (jon)bit8_copy_to_long_array__cst__                          java ??
jonbit8_copy_to_short_array                                  (jon)bit8_copy_to_short_array                                java ??
jonbit8_copy_to_short_array__cst__                           (jon)bit8_copy_to_short_array__cst__                         java ??
jonbit9_copy_from_int_array                                  (jon)bit9_copy_from_int_array                                java ??
jonbit9_copy_from_long_array                                 (jon)bit9_copy_from_long_array                               java ??
jonbit9_copy_from_short_array                                (jon)bit9_copy_from_short_array                              java ??
jonbit9_copy_to_int_array                                    (jon)bit9_copy_to_int_array                                  java ??
jonbit9_copy_to_long_array                                   (jon)bit9_copy_to_long_array                                 java ??
jonbit9_copy_to_short_array                                  (jon)bit9_copy_to_short_array                                java ??
jonfci8_position0                                            (jon)fci8_position0                                          java ??
jonfci8_position0__cst__                                     (jon)fci8_position0__cst__                                   java ??
jonfci9_position0                                            (jon)fci9_position0                                          java ??
jonfdi8_allocate0                                            (jon)fdi8_allocate0                                          java ??
jonfdi8_allocate0__cst__                                     (jon)fdi8_allocate0__cst__                                   java ??
jonfdi9_allocate0                                            (jon)fdi9_allocate0                                          java ??
joxLdiToInt                                                  (jox)LdiToInt                                                java jit compiler ??
jox_actx_if_ok_to_call_ioe                                   (jox)_actx_if_ok_to_call_ioe                                 java jit compiler ??
jox_compose_jarred_name                                      (jox)_compose_jarred_name                                    java jit compiler ??
jox_dump_instruction_memory                                  (jox)_dump_instruction_memory                                java jit compiler ??
jox_dump_joxcx                                               (jox)_dump_joxcx                                             java jit compiler ??
jox_dump_joxhp                                               (jox)_dump_joxhp                                             java jit compiler ??
jox_get_edition_handle_from_objn                             (jox)_get_edition_handle_from_objn                           java jit compiler ??
jox_init_pga_heap                                            (jox)_init_pga_heap                                          java jit compiler ??
jox_iterate_sos                                              (jox)_iterate_sos                                            java jit compiler ??
jox_ncomp_get_name                                           (jox)_ncomp_get_name                                         java jit compiler ??
jox_ncomp_lib_prefix                                         (jox)_ncomp_lib_prefix                                       java jit compiler ??
jox_ncomp_set_file_name                                      (jox)_ncomp_set_file_name                                    java jit compiler ??
jox_ok_to_use_execution_heap_from_binary                     (jox)_ok_to_use_execution_heap_from_binary                   java jit compiler ??
jox_printf_internal                                          (jox)_printf_internal                                        java jit compiler ??
jox_push_session                                             (jox)_push_session                                           java jit compiler ??
jox_signal_pushed_session_use_during_eoc_error               (jox)_signal_pushed_session_use_during_eoc_error             java jit compiler ??
jox_startcln_joezshm                                         (jox)_startcln_joezshm                                       java jit compiler ??
jox_ujs_set_stat_addr                                        (jox)_ujs_set_stat_addr                                      java jit compiler ??
jox_vcs_receive                                              (jox)_vcs_receive                                            java jit compiler ??
joxbtl_pop_aurora_ctx                                        (jox)btl_pop_aurora_ctx                                      java jit compiler ??
joxbtl_push_aurora_ctx                                       (jox)btl_push_aurora_ctx                                     java jit compiler ??
joxccnc_copy_name_component                                  (jox)ccnc_copy_name_component                                java jit compiler ??
joxcmmn_match_method_name                                    (jox)cmmn_match_method_name                                  java jit compiler ??
joxcre2rbld                                                  (jox)cre2rbld                                                java jit compiler ??
joxcsys_adjust_kglhdadr_for_endianess                        (joxcsys)_adjust_kglhdadr_for_endianess                      java jit compiler create or replace java system ??
joxcsys_ensure_classes_not_in_use_cleanup                    (joxcsys)_ensure_classes_not_in_use_cleanup                  java jit compiler create or replace java system ??
joxctc_type_code                                             (jox)ctc_type_code                                           java jit compiler ??
joxdlc_flush_out                                             (jox)dlc_flush_out                                           java jit compiler ??
joxdst                                                       (jox)dst                                                     java jit compiler ??
joxhpkinit                                                   (jox)hpkinit                                                 java jit compiler ??
joxjit_last_pdb_used_and_time                                (jox)jit_last_pdb_used_and_time                              java jit compiler ??
joxjit_last_pdb_used_time_differs                            (jox)jit_last_pdb_used_time_differs                          java jit compiler ??
joxjit_set_last_pdb_used                                     (jox)jit_set_last_pdb_used                                   java jit compiler ??
joxjit_start_process                                         (jox)jit_start_process                                       java jit compiler ??
joxjitpinit                                                  (jox)jitpinit                                                java jit compiler ??
joxlid_translate_joxnm                                       (jox)lid_translate_joxnm                                     java jit compiler ??
joxlid_translate_joxnt                                       (jox)lid_translate_joxnt                                     java jit compiler ??
joxnsmcopy                                                   (jox)nsmcopy                                                 java jit compiler ??
joxobind_parse_internal                                      (jox)obind_parse_internal                                    java jit compiler ??
joxpfn4_put_namesctx                                         (jox)pfn4_put_namesctx                                       java jit compiler ??
joxpfn5_note_namesctx                                        (jox)pfn5_note_namesctx                                      java jit compiler ??
joxrv0d_put_dep                                              (jox)rv0d_put_dep                                            java jit compiler ??
joxrv28_note_used                                            (jox)rv28_note_used                                          java jit compiler ??
joxrv29_receive_output                                       (jox)rv29_receive_output                                     java jit compiler ??
joxrv42_push_used_by_comp                                    (jox)rv42_push_used_by_comp                                  java jit compiler ??
joxrv_push_resolved_if_not_already_pending                   (jox)rv_push_resolved_if_not_already_pending                 java jit compiler ??
joxskipjarprefix                                             (jox)skipjarprefix                                           java jit compiler ??
joxsltu                                                      (jox)sltu                                                    java jit compiler ??
jznOctGetScalarValueC                                        (jzn)OctGetScalarValueC                                      json ??
jznParserNextBsonEvent                                       (jzn)ParserNextBsonEvent                                     json ??
jznpEngCmpBoolNull                                           (jzn)pEngCmpBoolNull                                         json ??
jznuDateTimeStringToUtc                                      (jzn)uDateTimeStringToUtc                                    json ??
kcbo_incr_doc                                                (kcbo)_incr_doc                                              kernel cache buffers object queue ??
kcfis_clear_lob                                              (kcfis)_clear_lob                                            kernel cache file management intelligent storage ??
kclcsb                                                       (kcl)csb                                                     kernel cache lock manager/buffer cache ??
kewmfdms_flush_drmsum                                        (kewm)fdms_flush_drmsum                                      kernel event AWR metrics ??
kewmusmdb_update_smdbuf                                      (kewm)usmdb_update_smdbuf                                    kernel event AWR metrics ??
kewramcs_app_map_condbid_str                                 (kewr)amcs_app_map_condbid_str                               kernel event AWR repository ??
kewramvn_append_mdb_vvwname                                  (kewr)amvn_append_mdb_vvwname                                kernel event AWR repository ??
kewratr_alloc_topn_rowset                                    (kewr)atr_alloc_topn_rowset                                  kernel event AWR repository ??
kewraxc_attribute_xcb                                        (kewr)axc_attribute_xcb                                      kernel event AWR repository ??
kewrbtsg_build_topseg                                        (kewr)btsg_build_topseg                                      kernel event AWR repository ??
kewrccsq_collect_csql                                        (kewr)ccsq_collect_csql                                      kernel event AWR repository ??
kewrcdm_clear_dstat_mapping                                  (kewr)cdm_clear_dstat_mapping                                kernel event AWR repository ??
kewrcts_compute_topntb_stat                                  (kewr)cts_compute_topntb_stat                                kernel event AWR repository ??
kewrfcd_fetch_colored_seg                                    (kewrf)cd_fetch_colored_seg                                  kernel event AWR repository flush ??
kewrfpc_fet_prevstat_cb                                      (kewrf)pc_fet_prevstat_cb                                    kernel event AWR repository flush ??
kewrftdc_fet_top_dstat_cb                                    (kewrf)tdc_fet_top_dstat_cb                                  kernel event AWR repository flush ??
kewrgcfes_get_cacheid_from_enum_str                          (kewr)gcfes_get_cacheid_from_enum_str                        kernel event AWR repository ??
kewrpcds_prepare_colored_dstats                              (kewr)pcds_prepare_colored_dstats                            kernel event AWR repository ??
kewrpfbue_pdb_from_buffer_entry                              (kewr)pfbue_pdb_from_buffer_entry                            kernel event AWR repository ??
kewrptsq_prep_topsql                                         (kewr)ptsq_prep_topsql                                       kernel event AWR repository ??
kewrrdsi_rank_dstat_item                                     (kewr)rdsi_rank_dstat_item                                   kernel event AWR repository ??
kewrrtsq_rank_topsql                                         (kewr)rtsq_rank_topsql                                       kernel event AWR repository ??
kewrsaobn_set_all_objnames                                   (kewr)saobn_set_all_objnames                                 kernel event AWR repository ??
kewrsonie_set_object_names_in_entry                          (kewr)sonie_set_object_names_in_entry                        kernel event AWR repository ??
kewrsqlc_sql_iscolored_cb                                    (kewr)sqlc_sql_iscolored_cb                                  kernel event AWR repository ??
kewrtnsit_fetch_next_entry                                   (kewr)tnsit_fetch_next_entry                                 kernel event AWR repository ??
kewrtopnstcx_alloc_dstat_rowset                              (kewr)topnstcx_alloc_dstat_rowset                            kernel event AWR repository ??
kfdDskComputeHashForRow                                      (kfd)DskComputeHashForRow                                    kernel automatic storage management disk ??
kfdDskTableCbInternal                                        (kfd)DskTableCbInternal                                      kernel automatic storage management disk ??
kffFdFmtMap                                                  (kff)FdFmtMap                                                kernel automatic storage management KFF ??
kffPreFormat                                                 (kff)PreFormat                                               kernel automatic storage management KFF ??
kffgAddChildBlk                                              (kffg)AddChildBlk                                            kernel automatic storage management KFF file group ??
kffgAddDefault                                               (kffg)AddDefault                                             kernel automatic storage management KFF file group ??
kffgAuthenticate                                             (kffg)Authenticate                                           kernel automatic storage management KFF file group ??
kffgCalDeltaRedChg                                           (kffg)CalDeltaRedChg                                         kernel automatic storage management KFF file group ??
kffgCalRealQuota                                             (kffg)CalRealQuota                                           kernel automatic storage management KFF file group ??
kffgCalTargetRedun                                           (kffg)CalTargetRedun                                         kernel automatic storage management KFF file group ??
kffgCmp                                                      (kffg)Cmp                                                    kernel automatic storage management KFF file group ??
kffgFillFg                                                   (kffg)FillFg                                                 kernel automatic storage management KFF file group ??
kffgFindFree                                                 (kffg)FindFree                                               kernel automatic storage management KFF file group ??
kffgIsRedunAvailable                                         (kffg)IsRedunAvailable                                       kernel automatic storage management KFF file group ??
kffgIsUnsplit                                                (kffg)IsUnsplit                                              kernel automatic storage management KFF file group ??
kffgIsWriteOnce                                              (kffg)IsWriteOnce                                            kernel automatic storage management KFF file group ??
kffgMakeName                                                 (kffg)MakeName                                               kernel automatic storage management KFF file group ??
kffgVerifyRedunChg                                           (kffg)VerifyRedunChg                                         kernel automatic storage management KFF file group ??
kffgcSyncDBLazy                                              (kffg)cSyncDBLazy                                            kernel automatic storage management KFF file group ??
kffgcSyncEnd                                                 (kffg)cSyncEnd                                               kernel automatic storage management KFF file group ??
kffgftKey                                                    (kffg)ftKey                                                  kernel automatic storage management KFF file group ??
kffgftMap                                                    (kffg)ftMap                                                  kernel automatic storage management KFF file group ??
kffgptAddDefault                                             (kffg)ptAddDefault                                           kernel automatic storage management KFF file group ??
kffgptFixRedun                                               (kffg)ptFixRedun                                             kernel automatic storage management KFF file group ??
kffgptGetStrVal                                              (kffg)ptGetStrVal                                            kernel automatic storage management KFF file group ??
kffgptLookup                                                 (kffg)ptLookup                                               kernel automatic storage management KFF file group ??
kffgptLookupDump                                             (kffg)ptLookupDump                                           kernel automatic storage management KFF file group ??
kffgptParseNum                                               (kffg)ptParseNum                                             kernel automatic storage management KFF file group ??
kfgComputeGrpProp                                            (kfg)ComputeGrpProp                                          kernel automatic storage management diskgroups ??
kfgGrpTableCbInternal                                        (kfg)GrpTableCbInternal                                      kernel automatic storage management diskgroups ??
kfk_alloc_kfkio_freelist                                     (kfk)_alloc_kfkio_freelist                                   kernel automatic storage management KFK ??
kfk_asm_ioerror                                              (kfk)_asm_ioerror                                            kernel automatic storage management KFK ??
kfk_bld_sbmtptr_arry                                         (kfk)_bld_sbmtptr_arry                                       kernel automatic storage management KFK ??
kfk_bld_waitptr_arry                                         (kfk)_bld_waitptr_arry                                       kernel automatic storage management KFK ??
kfk_block_asmlib                                             (kfk)_block_asmlib                                           kernel automatic storage management KFK ??
kfk_block_oss                                                (kfk)_block_oss                                              kernel automatic storage management KFK ??
kfk_block_ufs                                                (kfk)_block_ufs                                              kernel automatic storage management KFK ??
kfk_build_osdstruct                                          (kfk)_build_osdstruct                                        kernel automatic storage management KFK ??
kfk_chk_xor_valid                                            (kfk)_chk_xor_valid                                          kernel automatic storage management KFK ??
kfk_do_abn_xor_chk                                           (kfk)_do_abn_xor_chk                                         kernel automatic storage management KFK ??
kfk_error_emulate                                            (kfk)_error_emulate                                          kernel automatic storage management KFK ??
kfk_fill_ksfdrq                                              (kfk)_fill_ksfdrq                                            kernel automatic storage management KFK ??
kfk_find_io_subsys                                           (kfk)_find_io_subsys                                         kernel automatic storage management KFK ??
kfk_get_asmioc_oper                                          (kfk)_get_asmioc_oper                                        kernel automatic storage management KFK ??
kfk_get_free_kfkrq                                           (kfk)_get_free_kfkrq                                         kernel automatic storage management KFK ??
kfk_get_unreaped_ios                                         (kfk)_get_unreaped_ios                                       kernel automatic storage management KFK ??
kfk_hard_abn_set                                             (kfk)_hard_abn_set                                           kernel automatic storage management KFK ??
kfk_hard_getoffs                                             (kfk)_hard_getoffs                                           kernel automatic storage management KFK ??
kfk_iodone_merge_slave                                       (kfk)_iodone_merge_slave                                     kernel automatic storage management KFK ??
kfk_lib_abn_check                                            (kfk)_lib_abn_check                                          kernel automatic storage management KFK ??
kfk_lib_xor_check                                            (kfk)_lib_xor_check                                          kernel automatic storage management KFK ??
kfk_oss_cell_timedout                                        (kfk)_oss_cell_timedout                                      kernel automatic storage management KFK ??
kfk_oss_dump_orq                                             (kfk)_oss_dump_orq                                           kernel automatic storage management KFK ??
kfk_oss_get_orq                                              (kfk)_oss_get_orq                                            kernel automatic storage management KFK ??
kfk_oss_offload_fill_orq                                     (kfk)_oss_offload_fill_orq                                   kernel automatic storage management KFK ??
kfk_oss_offload_submit                                       (kfk)_oss_offload_submit                                     kernel automatic storage management KFK ??
kfk_oss_post_wait                                            (kfk)_oss_post_wait                                          kernel automatic storage management KFK ??
kfk_oss_put_orq                                              (kfk)_oss_put_orq                                            kernel automatic storage management KFK ??
kfk_parse_disk_path                                          (kfk)_parse_disk_path                                        kernel automatic storage management KFK ??
kfk_proc_submitted_lib_reqs                                  (kfk)_proc_submitted_lib_reqs                                kernel automatic storage management KFK ??
kfk_process_an_ioq                                           (kfk)_process_an_ioq                                         kernel automatic storage management KFK ??
kfk_put_free_kfkios                                          (kfk)_put_free_kfkios                                        kernel automatic storage management KFK ??
kfk_reap_io_from_kfks                                        (kfk)_reap_io_from_kfks                                      kernel automatic storage management KFK ??
kfk_reap_lib_async_io                                        (kfk)_reap_lib_async_io                                      kernel automatic storage management KFK ??
kfk_reap_oss_async_io                                        (kfk)_reap_oss_async_io                                      kernel automatic storage management KFK ??
kfk_reap_ufs_async_io                                        (kfk)_reap_ufs_async_io                                      kernel automatic storage management KFK ??
kfk_rebuild_kfdrqs                                           (kfk)_rebuild_kfdrqs                                         kernel automatic storage management KFK ??
kfk_retry_submit_oss_io                                      (kfk)_retry_submit_oss_io                                    kernel automatic storage management KFK ??
kfk_submit_lib_io                                            (kfk)_submit_lib_io                                          kernel automatic storage management KFK ??
kfk_submit_oss_io                                            (kfk)_submit_oss_io                                          kernel automatic storage management KFK ??
kfk_submit_oss_io_no_wtevt                                   (kfk)_submit_oss_io_no_wtevt                                 kernel automatic storage management KFK ??
kfk_submit_oss_io_wtevt                                      (kfk)_submit_oss_io_wtevt                                    kernel automatic storage management KFK ??
kfk_submit_ufs_io                                            (kfk)_submit_ufs_io                                          kernel automatic storage management KFK ??
kfk_transit_fetchIO                                          (kfk)_transit_fetchIO                                        kernel automatic storage management KFK ??
kfk_transit_waitIO                                           (kfk)_transit_waitIO                                         kernel automatic storage management KFK ??
kfk_update_iodone_stats                                      (kfk)_update_iodone_stats                                    kernel automatic storage management KFK ??
kfk_zero_reap_array                                          (kfk)_zero_reap_array                                        kernel automatic storage management KFK ??
kfrcDirCreate                                                (kfrc)DirCreate                                              kernel automatic storage management recovery COD ??
kgfdDiscoverSubmit                                           (kgfd)DiscoverSubmit                                         kernel generic ASM io subsystem driver ??
kgskltyp                                                     (kgsk)ltyp                                                   kernel generic service resource manager ??
kjccspbat                                                    (kjc)cspbat                                                  kernel lock management communication ??
kjrbkthk                                                     (kjr)bkthk                                                   kernel lock management resource table ??
kkqjfCopyFroNoChn                                            (kkqjf)CopyFroNoChn                                          kernel compile query  join analysis join factorization ??
kkqjfFindWifCB                                               (kkqjf)FindWifCB                                             kernel compile query  join analysis join factorization ??
kkqwReplOpnPar                                               (kkq)wReplOpnPar                                             kernel compile query  ??
kksFreeSqlText                                               (kks)FreeSqlText                                             kernel compile shared objects (cursor) ??
kpondexpnfy                                                  (kpond)expnfy                                                kernel programmatic interface oracle notification advanced queuing  ??
kqlfFreeMem                                                  (kql)fFreeMem                                                kernel query library cache ??
krbbCountThreads                                             (krbb)CountThreads                                           kernel redo backup/restore creation of a backuppiece ??
ksmsq_spendingi                                              (ksmsq)_spendingi                                            kernel service (VOS) memory sga heap message queue services ??
ksols_reset_all                                              (ksols)_reset_all                                            kernel service (VOS) operations object level statistics(?) ??
ksolscar_cleanup_after_ranking                               (ksols)car_cleanup_after_ranking                             kernel service (VOS) operations object level statistics(?) ??
ksolspfr_prepare_for_ranking                                 (ksols)pfr_prepare_for_ranking                               kernel service (VOS) operations object level statistics(?) ??
ksucln_expired_cleanup_timer                                 (ksucln)_expired_cleanup_timer                               kernel service (VOS) user cleanup detached process ??
ksunetstat                                                   (ksu)netstat                                                 kernel service (VOS) user ??
ksws_map_fo_restore_to_text                                  (ksws)_map_fo_restore_to_text                                kernel service (VOS) workgroup services ??
kxfxsHandleSchdEvt                                           (kxfx)sHandleSchdEvt                                         kernel execution parallel query execution ??
kxsSegAllocate                                               (kxs)SegAllocate                                             kernel execution shared cursor ??
opixmffl                                                     (opix)mffl                                                   oracle program interface transfer to remote ??
qesrcCM_GetObn                                               (qesrcCM)_GetObn                                             query execute services result cache commit? ??
qesrcTol_New                                                 (qesrc)Tol_New                                               query execute services result cache ??
qknRefOutOfLineCtx                                           (qkn)RefOutOfLineCtx                                         query kernel allocate ??
ri_entcb_cmd_func                                            ri_entcb_cmd_func                                            ??
updTrace                                                     (upd)Trace                                                   update ??
zt_yield_entropy_source_cb                                   (zt)_yield_entropy_source_cb                                 security encryption ??

code symbol names unique in version 19.4 versus 19.3

NAME                                                         RESOLVE                                                      ANNOTATION
------------------------------------------------------------ ------------------------------------------------------------ --------------------------------------------------------------------------------
AddConversion                                                AddConversion                                                ??
AllocArray                                                   AllocArray                                                   ??
AllocEmptyTransform                                          AllocEmptyTransform                                          ??
AllocateToneCurveStruct                                      AllocateToneCurveStruct                                      ??
BilinearInterp16                                             BilinearInterp16                                             ??
BilinearInterpFloat                                          BilinearInterpFloat                                          ??
BlackPreservingGrayOnlySampler                               BlackPreservingGrayOnlySampler                               ??
BlackPreservingKOnlyIntents                                  BlackPreservingKOnlyIntents                                  ??
BlackPreservingKPlaneIntents                                 BlackPreservingKPlaneIntents                                 ??
BlackPreservingSampler                                       BlackPreservingSampler                                       ??
CLUTElemDup                                                  CLUTElemDup                                                  ??
CLutElemTypeFree                                             CLutElemTypeFree                                             ??
CachedXFORM                                                  CachedXFORM                                                  ??
CachedXFORMGamutCheck                                        CachedXFORMGamutCheck                                        ??
Clipper                                                      Clipper                                                      ??
ComputeAbsoluteIntent                                        ComputeAbsoluteIntent                                        ??
CurveSetDup                                                  CurveSetDup                                                  ??
CurveSetElemTypeFree                                         CurveSetElemTypeFree                                         ??
CurvesDup                                                    CurvesDup                                                    ??
CurvesFree                                                   CurvesFree                                                   ??
DecideCurveType                                              DecideCurveType                                              ??
DecideLUTtypeA2B                                             DecideLUTtypeA2B                                             ??
DecideLUTtypeB2A                                             DecideLUTtypeB2A                                             ??
DecideTextDescType                                           DecideTextDescType                                           ??
DecideTextType                                               DecideTextType                                               ??
DecideXYZtype                                                DecideXYZtype                                                ??
DefaultEvalParametricFn                                      DefaultEvalParametricFn                                      ??
DefaultICCintents                                            DefaultICCintents                                            ??
DefaultLogErrorHandlerFunction                               DefaultLogErrorHandlerFunction                               ??
DupMatShaper                                                 DupMatShaper                                                 ??
DupNamedColorList                                            DupNamedColorList                                            ??
EstimateTAC                                                  EstimateTAC                                                  ??
Eval16nop1D                                                  Eval16nop1D                                                  ??
Eval1Input                                                   Eval1Input                                                   ??
Eval1InputFloat                                              Eval1InputFloat                                              ??
Eval4Inputs                                                  Eval4Inputs                                                  ??
Eval4InputsFloat                                             Eval4InputsFloat                                             ??
Eval5Inputs                                                  Eval5Inputs                                                  ??
Eval5InputsFloat                                             Eval5InputsFloat                                             ??
Eval6Inputs                                                  Eval6Inputs                                                  ??
Eval6InputsFloat                                             Eval6InputsFloat                                             ??
Eval7Inputs                                                  Eval7Inputs                                                  ??
Eval7InputsFloat                                             Eval7InputsFloat                                             ??
Eval8Inputs                                                  Eval8Inputs                                                  ??
Eval8InputsFloat                                             Eval8InputsFloat                                             ??
EvalNamedColor                                               EvalNamedColor                                               ??
EvalNamedColorPCS                                            EvalNamedColorPCS                                            ??
EvaluateCLUTfloat                                            EvaluateCLUTfloat                                            ??
EvaluateCLUTfloatIn16                                        EvaluateCLUTfloatIn16                                        ??
EvaluateCurves                                               EvaluateCurves                                               ??
EvaluateIdentity                                             EvaluateIdentity                                             ??
EvaluateLab2XYZ                                              EvaluateLab2XYZ                                              ??
EvaluateMatrix                                               EvaluateMatrix                                               ??
EvaluateXYZ2Lab                                              EvaluateXYZ2Lab                                              ??
FastEvaluateCurves16                                         FastEvaluateCurves16                                         ??
FastEvaluateCurves8                                          FastEvaluateCurves8                                          ??
FastIdentity16                                               FastIdentity16                                               ??
FileClose                                                    FileClose                                                    ??
FileRead                                                     FileRead                                                     ??
FileSeek                                                     FileSeek                                                     ??
FileTell                                                     FileTell                                                     ??
FileWrite                                                    FileWrite                                                    ??
FixWhiteMisalignment                                         FixWhiteMisalignment                                         ??
FloatXFORM                                                   FloatXFORM                                                   ??
FreeMatShaper                                                FreeMatShaper                                                ??
FreeNamedColorList                                           FreeNamedColorList                                           ??
GamutSampler                                                 GamutSampler                                                 ??
GenericMPEdup                                                GenericMPEdup                                                ??
GenericMPEfree                                               GenericMPEfree                                               ??
IdentitySampler                                              IdentitySampler                                              ??
InkLimitingSampler                                           InkLimitingSampler                                           ??
Java_sun_java2d_cmm_lcms_LCMS_colorConvert                   Java_sun_java2d_cmm_lcms_LCMS_colorConvert                   ??
Java_sun_java2d_cmm_lcms_LCMS_createNativeTransform          Java_sun_java2d_cmm_lcms_LCMS_createNativeTransform          ??
Java_sun_java2d_cmm_lcms_LCMS_getProfileDataNative           Java_sun_java2d_cmm_lcms_LCMS_getProfileDataNative           ??
Java_sun_java2d_cmm_lcms_LCMS_getProfileID                   Java_sun_java2d_cmm_lcms_LCMS_getProfileID                   ??
Java_sun_java2d_cmm_lcms_LCMS_getProfileSizeNative           Java_sun_java2d_cmm_lcms_LCMS_getProfileSizeNative           ??
Java_sun_java2d_cmm_lcms_LCMS_getTagNative                   Java_sun_java2d_cmm_lcms_LCMS_getTagNative                   ??
Java_sun_java2d_cmm_lcms_LCMS_initLCMS                       Java_sun_java2d_cmm_lcms_LCMS_initLCMS                       ??
Java_sun_java2d_cmm_lcms_LCMS_loadProfileNative              Java_sun_java2d_cmm_lcms_LCMS_loadProfileNative              ??
Java_sun_java2d_cmm_lcms_LCMS_setTagDataNative               Java_sun_java2d_cmm_lcms_LCMS_setTagDataNative               ??
JsonBinaryCtxCreate                                          JsonBinaryCtxCreate                                          ??
JsonBinaryCtxDestroy                                         JsonBinaryCtxDestroy                                         ??
JsonBinaryCtxReset                                           JsonBinaryCtxReset                                           ??
JsonBinaryDecodeAll                                          JsonBinaryDecodeAll                                          ??
JsonBinaryEncodeAll                                          JsonBinaryEncodeAll                                          ??
JsonDomCreate                                                JsonDomCreate                                                ??
JsonDomCreateVA                                              JsonDomCreateVA                                              ??
JsonEventSourceCreate                                        JsonEventSourceCreate                                        ??
JsonEventSourceCreateVA                                      JsonEventSourceCreateVA                                      ??
JsonEventWriterCreate                                        JsonEventWriterCreate                                        ??
JsonEventWriterCreateVA                                      JsonEventWriterCreateVA                                      ??
JsonSaveDom                                                  JsonSaveDom                                                  ??
JsonSaveDomVA                                                JsonSaveDomVA                                                ??
LCMS_freeProfile                                             LCMS_freeProfile                                             ??
LCMS_freeTransform                                           LCMS_freeTransform                                           ??
LinLerp1D                                                    LinLerp1D                                                    ??
LinLerp1Dfloat                                               LinLerp1Dfloat                                               ??
MatShaperEval16                                              MatShaperEval16                                              ??
MatrixElemDup                                                MatrixElemDup                                                ??
MatrixElemTypeFree                                           MatrixElemTypeFree                                           ??
MemoryClose                                                  MemoryClose                                                  ??
MemoryRead                                                   MemoryRead                                                   ??
MemorySeek                                                   MemorySeek                                                   ??
MemoryTell                                                   MemoryTell                                                   ??
MemoryWrite                                                  MemoryWrite                                                  ??
NULLClose                                                    NULLClose                                                    ??
NULLRead                                                     NULLRead                                                     ??
NULLSeek                                                     NULLSeek                                                     ??
NULLTell                                                     NULLTell                                                     ??
NULLWrite                                                    NULLWrite                                                    ??
NullFloatXFORM                                               NullFloatXFORM                                               ??
NullXFORM                                                    NullXFORM                                                    ??
OptimizeByComputingLinearization                             OptimizeByComputingLinearization                             ??
OptimizeByJoiningCurves                                      OptimizeByJoiningCurves                                      ??
OptimizeByResampling                                         OptimizeByResampling                                         ??
OptimizeMatrixShaper                                         OptimizeMatrixShaper                                         ??
Pack1Byte                                                    Pack1Byte                                                    ??
Pack1ByteReversed                                            Pack1ByteReversed                                            ??
Pack1ByteSkip1                                               Pack1ByteSkip1                                               ??
Pack1ByteSkip1SwapFirst                                      Pack1ByteSkip1SwapFirst                                      ??
Pack1Word                                                    Pack1Word                                                    ??
Pack1WordBigEndian                                           Pack1WordBigEndian                                           ??
Pack1WordReversed                                            Pack1WordReversed                                            ??
Pack1WordSkip1                                               Pack1WordSkip1                                               ??
Pack1WordSkip1SwapFirst                                      Pack1WordSkip1SwapFirst                                      ??
Pack3Bytes                                                   Pack3Bytes                                                   ??
Pack3BytesAndSkip1                                           Pack3BytesAndSkip1                                           ??
Pack3BytesAndSkip1Optimized                                  Pack3BytesAndSkip1Optimized                                  ??
Pack3BytesAndSkip1Swap                                       Pack3BytesAndSkip1Swap                                       ??
Pack3BytesAndSkip1SwapFirst                                  Pack3BytesAndSkip1SwapFirst                                  ??
Pack3BytesAndSkip1SwapFirstOptimized                         Pack3BytesAndSkip1SwapFirstOptimized                         ??
Pack3BytesAndSkip1SwapOptimized                              Pack3BytesAndSkip1SwapOptimized                              ??
Pack3BytesAndSkip1SwapSwapFirst                              Pack3BytesAndSkip1SwapSwapFirst                              ??
Pack3BytesAndSkip1SwapSwapFirstOptimized                     Pack3BytesAndSkip1SwapSwapFirstOptimized                     ??
Pack3BytesOptimized                                          Pack3BytesOptimized                                          ??
Pack3BytesSwap                                               Pack3BytesSwap                                               ??
Pack3BytesSwapOptimized                                      Pack3BytesSwapOptimized                                      ??
Pack3Words                                                   Pack3Words                                                   ??
Pack3WordsAndSkip1                                           Pack3WordsAndSkip1                                           ??
Pack3WordsAndSkip1Swap                                       Pack3WordsAndSkip1Swap                                       ??
Pack3WordsAndSkip1SwapFirst                                  Pack3WordsAndSkip1SwapFirst                                  ??
Pack3WordsAndSkip1SwapSwapFirst                              Pack3WordsAndSkip1SwapSwapFirst                              ??
Pack3WordsBigEndian                                          Pack3WordsBigEndian                                          ??
Pack3WordsSwap                                               Pack3WordsSwap                                               ??
Pack4Bytes                                                   Pack4Bytes                                                   ??
Pack4BytesReverse                                            Pack4BytesReverse                                            ??
Pack4BytesSwap                                               Pack4BytesSwap                                               ??
Pack4BytesSwapFirst                                          Pack4BytesSwapFirst                                          ??
Pack4BytesSwapSwapFirst                                      Pack4BytesSwapSwapFirst                                      ??
Pack4Words                                                   Pack4Words                                                   ??
Pack4WordsBigEndian                                          Pack4WordsBigEndian                                          ??
Pack4WordsReverse                                            Pack4WordsReverse                                            ??
Pack4WordsSwap                                               Pack4WordsSwap                                               ??
Pack6Bytes                                                   Pack6Bytes                                                   ??
Pack6BytesSwap                                               Pack6BytesSwap                                               ??
Pack6Words                                                   Pack6Words                                                   ??
Pack6WordsSwap                                               Pack6WordsSwap                                               ??
PackALabV2_8                                                 PackALabV2_8                                                 ??
PackAnyBytes                                                 PackAnyBytes                                                 ??
PackAnyWords                                                 PackAnyWords                                                 ??
PackDoubleFrom16                                             PackDoubleFrom16                                             ??
PackDoublesFromFloat                                         PackDoublesFromFloat                                         ??
PackFloatFrom16                                              PackFloatFrom16                                              ??
PackFloatsFromFloat                                          PackFloatsFromFloat                                          ??
PackHalfFrom16                                               PackHalfFrom16                                               ??
PackHalfFromFloat                                            PackHalfFromFloat                                            ??
PackLabDoubleFrom16                                          PackLabDoubleFrom16                                          ??
PackLabDoubleFromFloat                                       PackLabDoubleFromFloat                                       ??
PackLabFloatFrom16                                           PackLabFloatFrom16                                           ??
PackLabFloatFromFloat                                        PackLabFloatFromFloat                                        ??
PackLabV2_16                                                 PackLabV2_16                                                 ??
PackLabV2_8                                                  PackLabV2_8                                                  ??
PackPlanarBytes                                              PackPlanarBytes                                              ??
PackPlanarWords                                              PackPlanarWords                                              ??
PackXYZDoubleFrom16                                          PackXYZDoubleFrom16                                          ??
PackXYZDoubleFromFloat                                       PackXYZDoubleFromFloat                                       ??
PackXYZFloatFrom16                                           PackXYZFloatFrom16                                           ??
PackXYZFloatFromFloat                                        PackXYZFloatFromFloat                                        ??
PreOptimize                                                  PreOptimize                                                  ??
PrecalculatedXFORM                                           PrecalculatedXFORM                                           ??
PrecalculatedXFORMGamutCheck                                 PrecalculatedXFORMGamutCheck                                 ??
Prelin16dup                                                  Prelin16dup                                                  ??
Prelin8dup                                                   Prelin8dup                                                   ??
Prelin8free                                                  Prelin8free                                                  ??
PrelinEval16                                                 PrelinEval16                                                 ??
PrelinEval8                                                  PrelinEval8                                                  ??
PrelinOpt16free                                              PrelinOpt16free                                              ??
ReadMPECurve                                                 ReadMPECurve                                                 ??
ReadMPEElem                                                  ReadMPEElem                                                  ??
ReadSeqID                                                    ReadSeqID                                                    ??
ReadSetOfCurves                                              ReadSetOfCurves                                              ??
SaveTags                                                     SaveTags                                                     ??
TetrahedralInterp16                                          TetrahedralInterp16                                          ??
TetrahedralInterpFloat                                       TetrahedralInterpFloat                                       ??
TrilinearInterp16                                            TrilinearInterp16                                            ??
TrilinearInterpFloat                                         TrilinearInterpFloat                                         ??
Type_Chromaticity_Dup                                        Type_Chromaticity_Dup                                        ??
Type_Chromaticity_Free                                       Type_Chromaticity_Free                                       ??
Type_Chromaticity_Read                                       Type_Chromaticity_Read                                       ??
Type_Chromaticity_Write                                      Type_Chromaticity_Write                                      ??
Type_ColorantOrderType_Dup                                   Type_ColorantOrderType_Dup                                   ??
Type_ColorantOrderType_Free                                  Type_ColorantOrderType_Free                                  ??
Type_ColorantOrderType_Read                                  Type_ColorantOrderType_Read                                  ??
Type_ColorantOrderType_Write                                 Type_ColorantOrderType_Write                                 ??
Type_ColorantTable_Dup                                       Type_ColorantTable_Dup                                       ??
Type_ColorantTable_Free                                      Type_ColorantTable_Free                                      ??
Type_ColorantTable_Read                                      Type_ColorantTable_Read                                      ??
Type_ColorantTable_Write                                     Type_ColorantTable_Write                                     ??
Type_CrdInfo_Dup                                             Type_CrdInfo_Dup                                             ??
Type_CrdInfo_Free                                            Type_CrdInfo_Free                                            ??
Type_CrdInfo_Read                                            Type_CrdInfo_Read                                            ??
Type_CrdInfo_Write                                           Type_CrdInfo_Write                                           ??
Type_Curve_Dup                                               Type_Curve_Dup                                               ??
Type_Curve_Free                                              Type_Curve_Free                                              ??
Type_Curve_Read                                              Type_Curve_Read                                              ??
Type_Curve_Write                                             Type_Curve_Write                                             ??
Type_Data_Dup                                                Type_Data_Dup                                                ??
Type_Data_Free                                               Type_Data_Free                                               ??
Type_Data_Read                                               Type_Data_Read                                               ??
Type_Data_Write                                              Type_Data_Write                                              ??
Type_DateTime_Dup                                            Type_DateTime_Dup                                            ??
Type_DateTime_Free                                           Type_DateTime_Free                                           ??
Type_DateTime_Read                                           Type_DateTime_Read                                           ??
Type_DateTime_Write                                          Type_DateTime_Write                                          ??
Type_Dictionary_Dup                                          Type_Dictionary_Dup                                          ??
Type_Dictionary_Free                                         Type_Dictionary_Free                                         ??
Type_Dictionary_Read                                         Type_Dictionary_Read                                         ??
Type_Dictionary_Write                                        Type_Dictionary_Write                                        ??
Type_LUT16_Dup                                               Type_LUT16_Dup                                               ??
Type_LUT16_Free                                              Type_LUT16_Free                                              ??
Type_LUT16_Read                                              Type_LUT16_Read                                              ??
Type_LUT16_Write                                             Type_LUT16_Write                                             ??
Type_LUT8_Dup                                                Type_LUT8_Dup                                                ??
Type_LUT8_Free                                               Type_LUT8_Free                                               ??
Type_LUT8_Read                                               Type_LUT8_Read                                               ??
Type_LUT8_Write                                              Type_LUT8_Write                                              ??
Type_LUTA2B_Dup                                              Type_LUTA2B_Dup                                              ??
Type_LUTA2B_Free                                             Type_LUTA2B_Free                                             ??
Type_LUTA2B_Read                                             Type_LUTA2B_Read                                             ??
Type_LUTA2B_Write                                            Type_LUTA2B_Write                                            ??
Type_LUTB2A_Dup                                              Type_LUTB2A_Dup                                              ??
Type_LUTB2A_Free                                             Type_LUTB2A_Free                                             ??
Type_LUTB2A_Read                                             Type_LUTB2A_Read                                             ??
Type_LUTB2A_Write                                            Type_LUTB2A_Write                                            ??
Type_MLU_Dup                                                 Type_MLU_Dup                                                 ??
Type_MLU_Free                                                Type_MLU_Free                                                ??
Type_MLU_Read                                                Type_MLU_Read                                                ??
Type_MLU_Write                                               Type_MLU_Write                                               ??
Type_MPE_Dup                                                 Type_MPE_Dup                                                 ??
Type_MPE_Free                                                Type_MPE_Free                                                ??
Type_MPE_Read                                                Type_MPE_Read                                                ??
Type_MPE_Write                                               Type_MPE_Write                                               ??
Type_MPEclut_Read                                            Type_MPEclut_Read                                            ??
Type_MPEclut_Write                                           Type_MPEclut_Write                                           ??
Type_MPEcurve_Read                                           Type_MPEcurve_Read                                           ??
Type_MPEcurve_Write                                          Type_MPEcurve_Write                                          ??
Type_MPEmatrix_Read                                          Type_MPEmatrix_Read                                          ??
Type_MPEmatrix_Write                                         Type_MPEmatrix_Write                                         ??
Type_Measurement_Dup                                         Type_Measurement_Dup                                         ??
Type_Measurement_Free                                        Type_Measurement_Free                                        ??
Type_Measurement_Read                                        Type_Measurement_Read                                        ??
Type_Measurement_Write                                       Type_Measurement_Write                                       ??
Type_NamedColor_Dup                                          Type_NamedColor_Dup                                          ??
Type_NamedColor_Free                                         Type_NamedColor_Free                                         ??
Type_NamedColor_Read                                         Type_NamedColor_Read                                         ??
Type_NamedColor_Write                                        Type_NamedColor_Write                                        ??
Type_ParametricCurve_Dup                                     Type_ParametricCurve_Dup                                     ??
Type_ParametricCurve_Free                                    Type_ParametricCurve_Free                                    ??
Type_ParametricCurve_Read                                    Type_ParametricCurve_Read                                    ??
Type_ParametricCurve_Write                                   Type_ParametricCurve_Write                                   ??
Type_ProfileSequenceDesc_Dup                                 Type_ProfileSequenceDesc_Dup                                 ??
Type_ProfileSequenceDesc_Free                                Type_ProfileSequenceDesc_Free                                ??
Type_ProfileSequenceDesc_Read                                Type_ProfileSequenceDesc_Read                                ??
Type_ProfileSequenceDesc_Write                               Type_ProfileSequenceDesc_Write                               ??
Type_ProfileSequenceId_Dup                                   Type_ProfileSequenceId_Dup                                   ??
Type_ProfileSequenceId_Free                                  Type_ProfileSequenceId_Free                                  ??
Type_ProfileSequenceId_Read                                  Type_ProfileSequenceId_Read                                  ??
Type_ProfileSequenceId_Write                                 Type_ProfileSequenceId_Write                                 ??
Type_S15Fixed16_Dup                                          Type_S15Fixed16_Dup                                          ??
Type_S15Fixed16_Free                                         Type_S15Fixed16_Free                                         ??
Type_S15Fixed16_Read                                         Type_S15Fixed16_Read                                         ??
Type_S15Fixed16_Write                                        Type_S15Fixed16_Write                                        ??
Type_Screening_Dup                                           Type_Screening_Dup                                           ??
Type_Screening_Free                                          Type_Screening_Free                                          ??
Type_Screening_Read                                          Type_Screening_Read                                          ??
Type_Screening_Write                                         Type_Screening_Write                                         ??
Type_Signature_Dup                                           Type_Signature_Dup                                           ??
Type_Signature_Free                                          Type_Signature_Free                                          ??
Type_Signature_Read                                          Type_Signature_Read                                          ??
Type_Signature_Write                                         Type_Signature_Write                                         ??
Type_Text_Description_Dup                                    Type_Text_Description_Dup                                    ??
Type_Text_Description_Free                                   Type_Text_Description_Free                                   ??
Type_Text_Description_Read                                   Type_Text_Description_Read                                   ??
Type_Text_Description_Write                                  Type_Text_Description_Write                                  ??
Type_Text_Dup                                                Type_Text_Dup                                                ??
Type_Text_Free                                               Type_Text_Free                                               ??
Type_Text_Read                                               Type_Text_Read                                               ??
Type_Text_Write                                              Type_Text_Write                                              ??
Type_U16Fixed16_Dup                                          Type_U16Fixed16_Dup                                          ??
Type_U16Fixed16_Free                                         Type_U16Fixed16_Free                                         ??
Type_U16Fixed16_Read                                         Type_U16Fixed16_Read                                         ??
Type_U16Fixed16_Write                                        Type_U16Fixed16_Write                                        ??
Type_UcrBg_Dup                                               Type_UcrBg_Dup                                               ??
Type_UcrBg_Free                                              Type_UcrBg_Free                                              ??
Type_UcrBg_Read                                              Type_UcrBg_Read                                              ??
Type_UcrBg_Write                                             Type_UcrBg_Write                                             ??
Type_ViewingConditions_Dup                                   Type_ViewingConditions_Dup                                   ??
Type_ViewingConditions_Free                                  Type_ViewingConditions_Free                                  ??
Type_ViewingConditions_Read                                  Type_ViewingConditions_Read                                  ??
Type_ViewingConditions_Write                                 Type_ViewingConditions_Write                                 ??
Type_XYZ_Dup                                                 Type_XYZ_Dup                                                 ??
Type_XYZ_Free                                                Type_XYZ_Free                                                ??
Type_XYZ_Read                                                Type_XYZ_Read                                                ??
Type_XYZ_Write                                               Type_XYZ_Write                                               ??
Type_vcgt_Dup                                                Type_vcgt_Dup                                                ??
Type_vcgt_Free                                               Type_vcgt_Free                                               ??
Type_vcgt_Read                                               Type_vcgt_Read                                               ??
Type_vcgt_Write                                              Type_vcgt_Write                                              ??
Unroll1Byte                                                  Unroll1Byte                                                  ??
Unroll1ByteReversed                                          Unroll1ByteReversed                                          ??
Unroll1ByteSkip1                                             Unroll1ByteSkip1                                             ??
Unroll1ByteSkip2                                             Unroll1ByteSkip2                                             ??
Unroll1Word                                                  Unroll1Word                                                  ??
Unroll1WordReversed                                          Unroll1WordReversed                                          ??
Unroll1WordSkip3                                             Unroll1WordSkip3                                             ??
Unroll2Bytes                                                 Unroll2Bytes                                                 ??
Unroll2Words                                                 Unroll2Words                                                 ??
Unroll3Bytes                                                 Unroll3Bytes                                                 ??
Unroll3BytesSkip1Swap                                        Unroll3BytesSkip1Swap                                        ??
Unroll3BytesSkip1SwapFirst                                   Unroll3BytesSkip1SwapFirst                                   ??
Unroll3BytesSkip1SwapSwapFirst                               Unroll3BytesSkip1SwapSwapFirst                               ??
Unroll3BytesSwap                                             Unroll3BytesSwap                                             ??
Unroll3Words                                                 Unroll3Words                                                 ??
Unroll3WordsSkip1Swap                                        Unroll3WordsSkip1Swap                                        ??
Unroll3WordsSkip1SwapFirst                                   Unroll3WordsSkip1SwapFirst                                   ??
Unroll3WordsSwap                                             Unroll3WordsSwap                                             ??
Unroll4Bytes                                                 Unroll4Bytes                                                 ??
Unroll4BytesReverse                                          Unroll4BytesReverse                                          ??
Unroll4BytesSwap                                             Unroll4BytesSwap                                             ??
Unroll4BytesSwapFirst                                        Unroll4BytesSwapFirst                                        ??
Unroll4BytesSwapSwapFirst                                    Unroll4BytesSwapSwapFirst                                    ??
Unroll4Words                                                 Unroll4Words                                                 ??
Unroll4WordsReverse                                          Unroll4WordsReverse                                          ??
Unroll4WordsSwap                                             Unroll4WordsSwap                                             ??
Unroll4WordsSwapFirst                                        Unroll4WordsSwapFirst                                        ??
Unroll4WordsSwapSwapFirst                                    Unroll4WordsSwapSwapFirst                                    ??
UnrollALabV2_8                                               UnrollALabV2_8                                               ??
UnrollAnyWords                                               UnrollAnyWords                                               ??
UnrollChunkyBytes                                            UnrollChunkyBytes                                            ??
UnrollDouble1Chan                                            UnrollDouble1Chan                                            ??
UnrollDoubleTo16                                             UnrollDoubleTo16                                             ??
UnrollDoublesToFloat                                         UnrollDoublesToFloat                                         ??
UnrollFloatTo16                                              UnrollFloatTo16                                              ??
UnrollFloatsToFloat                                          UnrollFloatsToFloat                                          ??
UnrollHalfTo16                                               UnrollHalfTo16                                               ??
UnrollHalfToFloat                                            UnrollHalfToFloat                                            ??
UnrollLabDoubleTo16                                          UnrollLabDoubleTo16                                          ??
UnrollLabDoubleToFloat                                       UnrollLabDoubleToFloat                                       ??
UnrollLabFloatTo16                                           UnrollLabFloatTo16                                           ??
UnrollLabFloatToFloat                                        UnrollLabFloatToFloat                                        ??
UnrollLabV2_16                                               UnrollLabV2_16                                               ??
UnrollLabV2_8                                                UnrollLabV2_8                                                ??
UnrollPlanarBytes                                            UnrollPlanarBytes                                            ??
UnrollPlanarWords                                            UnrollPlanarWords                                            ??
UnrollXYZDoubleTo16                                          UnrollXYZDoubleTo16                                          ??
UnrollXYZDoubleToFloat                                       UnrollXYZDoubleToFloat                                       ??
UnrollXYZFloatTo16                                           UnrollXYZFloatTo16                                           ??
UnrollXYZFloatToFloat                                        UnrollXYZFloatToFloat                                        ??
WriteMPECurve                                                WriteMPECurve                                                ??
WriteSeqID                                                   WriteSeqID                                                   ??
WriteSetOfCurves                                             WriteSetOfCurves                                             ??
XFormSampler16                                               XFormSampler16                                               ??
_LUTeval16                                                   _LUTeval16                                                   ??
_LUTevalFloat                                                _LUTevalFloat                                                ??
_cms15Fixed16toDouble                                        (_cms)15Fixed16toDouble                                      color management system (little cms) ??
_cms8Fixed8toDouble                                          (_cms)8Fixed8toDouble                                        color management system (little cms) ??
_cmsAdaptationMatrix                                         (_cms)AdaptationMatrix                                       color management system (little cms) ??
_cmsAdjustEndianess16                                        (_cms)AdjustEndianess16                                      color management system (little cms) ??
_cmsAdjustEndianess32                                        (_cms)AdjustEndianess32                                      color management system (little cms) ??
_cmsAdjustEndianess64                                        (_cms)AdjustEndianess64                                      color management system (little cms) ??
_cmsAllocAdaptationStateChunk                                (_cms)AllocAdaptationStateChunk                              color management system (little cms) ??
_cmsAllocAlarmCodesChunk                                     (_cms)AllocAlarmCodesChunk                                   color management system (little cms) ??
_cmsAllocCurvesPluginChunk                                   (_cms)AllocCurvesPluginChunk                                 color management system (little cms) ??
_cmsAllocFormattersPluginChunk                               (_cms)AllocFormattersPluginChunk                             color management system (little cms) ??
_cmsAllocIntentsPluginChunk                                  (_cms)AllocIntentsPluginChunk                                color management system (little cms) ??
_cmsAllocInterpPluginChunk                                   (_cms)AllocInterpPluginChunk                                 color management system (little cms) ??
_cmsAllocLogErrorChunk                                       (_cms)AllocLogErrorChunk                                     color management system (little cms) ??
_cmsAllocMPETypePluginChunk                                  (_cms)AllocMPETypePluginChunk                                color management system (little cms) ??
_cmsAllocMemPluginChunk                                      (_cms)AllocMemPluginChunk                                    color management system (little cms) ??
_cmsAllocMutexPluginChunk                                    (_cms)AllocMutexPluginChunk                                  color management system (little cms) ??
_cmsAllocOptimizationPluginChunk                             (_cms)AllocOptimizationPluginChunk                           color management system (little cms) ??
_cmsAllocTagPluginChunk                                      (_cms)AllocTagPluginChunk                                    color management system (little cms) ??
_cmsAllocTagTypePluginChunk                                  (_cms)AllocTagTypePluginChunk                                color management system (little cms) ??
_cmsAllocTransformPluginChunk                                (_cms)AllocTransformPluginChunk                              color management system (little cms) ??
_cmsBuildKToneCurve                                          (_cms)BuildKToneCurve                                        color management system (little cms) ??
_cmsBuildRGB2XYZtransferMatrix                               (_cms)BuildRGB2XYZtransferMatrix                             color management system (little cms) ??
_cmsCalloc                                                   (_cms)Calloc                                                 color management system (little cms) ??
_cmsCallocDefaultFn                                          (_cms)CallocDefaultFn                                        color management system (little cms) ??
_cmsChain2Lab                                                (_cms)Chain2Lab                                              color management system (little cms) ??
_cmsCompileProfileSequence                                   (_cms)CompileProfileSequence                                 color management system (little cms) ??
_cmsComputeInterpParams                                      (_cms)ComputeInterpParams                                    color management system (little cms) ??
_cmsComputeInterpParamsEx                                    (_cms)ComputeInterpParamsEx                                  color management system (little cms) ??
_cmsContextGetClientChunk                                    (_cms)ContextGetClientChunk                                  color management system (little cms) ??
_cmsCreateGamutCheckPipeline                                 (_cms)CreateGamutCheckPipeline                               color management system (little cms) ??
_cmsCreateMutex                                              (_cms)CreateMutex                                            color management system (little cms) ??
_cmsCreateSubAlloc                                           (_cms)CreateSubAlloc                                         color management system (little cms) ??
_cmsDecodeDateTimeNumber                                     (_cms)DecodeDateTimeNumber                                   color management system (little cms) ??
_cmsDefaultICCintents                                        (_cms)DefaultICCintents                                      color management system (little cms) ??
_cmsDestroyMutex                                             (_cms)DestroyMutex                                           color management system (little cms) ??
_cmsDoubleTo15Fixed16                                        (_cms)DoubleTo15Fixed16                                      color management system (little cms) ??
_cmsDoubleTo8Fixed8                                          (_cms)DoubleTo8Fixed8                                        color management system (little cms) ??
_cmsDupDefaultFn                                             (_cms)DupDefaultFn                                           color management system (little cms) ??
_cmsDupMem                                                   (_cms)DupMem                                                 color management system (little cms) ??
_cmsEncodeDateTimeNumber                                     (_cms)EncodeDateTimeNumber                                   color management system (little cms) ??
_cmsEndPointsBySpace                                         (_cms)EndPointsBySpace                                       color management system (little cms) ??
_cmsFloat2Half                                               (_cms)Float2Half                                             color management system (little cms) ??
_cmsFormatterIs8bit                                          (_cms)FormatterIs8bit                                        color management system (little cms) ??
_cmsFormatterIsFloat                                         (_cms)FormatterIsFloat                                       color management system (little cms) ??
_cmsFree                                                     (_cms)Free                                                   color management system (little cms) ??
_cmsFreeDefaultFn                                            (_cms)FreeDefaultFn                                          color management system (little cms) ??
_cmsFreeInterpParams                                         (_cms)FreeInterpParams                                       color management system (little cms) ??
_cmsGetContext                                               (_cms)GetContext                                             color management system (little cms) ??
_cmsGetFormatter                                             (_cms)GetFormatter                                           color management system (little cms) ??
_cmsGetTagDescriptor                                         (_cms)GetTagDescriptor                                       color management system (little cms) ??
_cmsGetTagTrueType                                           (_cms)GetTagTrueType                                         color management system (little cms) ??
_cmsGetTagTypeHandler                                        (_cms)GetTagTypeHandler                                      color management system (little cms) ??
_cmsGetTransformFormatters16                                 (_cms)GetTransformFormatters16                               color management system (little cms) ??
_cmsGetTransformFormattersFloat                              (_cms)GetTransformFormattersFloat                            color management system (little cms) ??
_cmsGetTransformUserData                                     (_cms)GetTransformUserData                                   color management system (little cms) ??
_cmsHalf2Float                                               (_cms)Half2Float                                             color management system (little cms) ??
_cmsHandleExtraChannels                                      (_cms)HandleExtraChannels                                    color management system (little cms) ??
_cmsICCcolorSpace                                            (_cms)ICCcolorSpace                                          color management system (little cms) ??
_cmsIOPrintf                                                 (_cms)IOPrintf                                               color management system (little cms) ??
_cmsInstallAllocFunctions                                    (_cms)InstallAllocFunctions                                  color management system (little cms) ??
_cmsLCMScolorSpace                                           (_cms)LCMScolorSpace                                         color management system (little cms) ??
_cmsLinkProfiles                                             (_cms)LinkProfiles                                           color management system (little cms) ??
_cmsLockMutex                                                (_cms)LockMutex                                              color management system (little cms) ??
_cmsMAT3eval                                                 (_cms)MAT3eval                                               color management system (little cms) ??
_cmsMAT3identity                                             (_cms)MAT3identity                                           color management system (little cms) ??
_cmsMAT3inverse                                              (_cms)MAT3inverse                                            color management system (little cms) ??
_cmsMAT3isIdentity                                           (_cms)MAT3isIdentity                                         color management system (little cms) ??
_cmsMAT3per                                                  (_cms)MAT3per                                                color management system (little cms) ??
_cmsMAT3solve                                                (_cms)MAT3solve                                              color management system (little cms) ??
_cmsMalloc                                                   (_cms)Malloc                                                 color management system (little cms) ??
_cmsMallocDefaultFn                                          (_cms)MallocDefaultFn                                        color management system (little cms) ??
_cmsMallocZero                                               (_cms)MallocZero                                             color management system (little cms) ??
_cmsMallocZeroDefaultFn                                      (_cms)MallocZeroDefaultFn                                    color management system (little cms) ??
_cmsOptimizePipeline                                         (_cms)OptimizePipeline                                       color management system (little cms) ??
_cmsPipelineSetOptimizationParameters                        (_cms)PipelineSetOptimizationParameters                      color management system (little cms) ??
_cmsPluginMalloc                                             (_cms)PluginMalloc                                           color management system (little cms) ??
_cmsQuantizeVal                                              (_cms)QuantizeVal                                            color management system (little cms) ??
_cmsRead15Fixed16Number                                      (_cms)Read15Fixed16Number                                    color management system (little cms) ??
_cmsReadAlignment                                            (_cms)ReadAlignment                                          color management system (little cms) ??
_cmsReadCHAD                                                 (_cms)ReadCHAD                                               color management system (little cms) ??
_cmsReadDevicelinkLUT                                        (_cms)ReadDevicelinkLUT                                      color management system (little cms) ??
_cmsReadFloat32Number                                        (_cms)ReadFloat32Number                                      color management system (little cms) ??
_cmsReadHeader                                               (_cms)ReadHeader                                             color management system (little cms) ??
_cmsReadInputLUT                                             (_cms)ReadInputLUT                                           color management system (little cms) ??
_cmsReadMediaWhitePoint                                      (_cms)ReadMediaWhitePoint                                    color management system (little cms) ??
_cmsReadOutputLUT                                            (_cms)ReadOutputLUT                                          color management system (little cms) ??
_cmsReadProfileSequence                                      (_cms)ReadProfileSequence                                    color management system (little cms) ??
_cmsReadTypeBase                                             (_cms)ReadTypeBase                                           color management system (little cms) ??
_cmsReadUInt16Array                                          (_cms)ReadUInt16Array                                        color management system (little cms) ??
_cmsReadUInt16Number                                         (_cms)ReadUInt16Number                                       color management system (little cms) ??
_cmsReadUInt32Number                                         (_cms)ReadUInt32Number                                       color management system (little cms) ??
_cmsReadUInt64Number                                         (_cms)ReadUInt64Number                                       color management system (little cms) ??
_cmsReadUInt8Number                                          (_cms)ReadUInt8Number                                        color management system (little cms) ??
_cmsReadXYZNumber                                            (_cms)ReadXYZNumber                                          color management system (little cms) ??
_cmsRealloc                                                  (_cms)Realloc                                                color management system (little cms) ??
_cmsReallocDefaultFn                                         (_cms)ReallocDefaultFn                                       color management system (little cms) ??
_cmsReasonableGridpointsByColorspace                         (_cms)ReasonableGridpointsByColorspace                       color management system (little cms) ??
_cmsRegisterFormattersPlugin                                 (_cms)RegisterFormattersPlugin                               color management system (little cms) ??
_cmsRegisterInterpPlugin                                     (_cms)RegisterInterpPlugin                                   color management system (little cms) ??
_cmsRegisterMemHandlerPlugin                                 (_cms)RegisterMemHandlerPlugin                               color management system (little cms) ??
_cmsRegisterMultiProcessElementPlugin                        (_cms)RegisterMultiProcessElementPlugin                      color management system (little cms) ??
_cmsRegisterMutexPlugin                                      (_cms)RegisterMutexPlugin                                    color management system (little cms) ??
_cmsRegisterOptimizationPlugin                               (_cms)RegisterOptimizationPlugin                             color management system (little cms) ??
_cmsRegisterParametricCurvesPlugin                           (_cms)RegisterParametricCurvesPlugin                         color management system (little cms) ??
_cmsRegisterRenderingIntentPlugin                            (_cms)RegisterRenderingIntentPlugin                          color management system (little cms) ??
_cmsRegisterTagPlugin                                        (_cms)RegisterTagPlugin                                      color management system (little cms) ??
_cmsRegisterTagTypePlugin                                    (_cms)RegisterTagTypePlugin                                  color management system (little cms) ??
_cmsRegisterTransformPlugin                                  (_cms)RegisterTransformPlugin                                color management system (little cms) ??
_cmsSearchTag                                                (_cms)SearchTag                                              color management system (little cms) ??
_cmsSetInterpolationRoutine                                  (_cms)SetInterpolationRoutine                                color management system (little cms) ??
_cmsSetTransformUserData                                     (_cms)SetTransformUserData                                   color management system (little cms) ??
_cmsStageAllocIdentityCLut                                   (_cms)StageAllocIdentityCLut                                 color management system (little cms) ??
_cmsStageAllocIdentityCurves                                 (_cms)StageAllocIdentityCurves                               color management system (little cms) ??
_cmsStageAllocLab2XYZ                                        (_cms)StageAllocLab2XYZ                                      color management system (little cms) ??
_cmsStageAllocLabPrelin                                      (_cms)StageAllocLabPrelin                                    color management system (little cms) ??
_cmsStageAllocLabV2ToV4                                      (_cms)StageAllocLabV2ToV4                                    color management system (little cms) ??
_cmsStageAllocLabV2ToV4curves                                (_cms)StageAllocLabV2ToV4curves                              color management system (little cms) ??
_cmsStageAllocLabV4ToV2                                      (_cms)StageAllocLabV4ToV2                                    color management system (little cms) ??
_cmsStageAllocNamedColor                                     (_cms)StageAllocNamedColor                                   color management system (little cms) ??
_cmsStageAllocPlaceholder                                    (_cms)StageAllocPlaceholder                                  color management system (little cms) ??
_cmsStageAllocXYZ2Lab                                        (_cms)StageAllocXYZ2Lab                                      color management system (little cms) ??
_cmsStageClipNegatives                                       (_cms)StageClipNegatives                                     color management system (little cms) ??
_cmsStageGetPtrToCurveSet                                    (_cms)StageGetPtrToCurveSet                                  color management system (little cms) ??
_cmsStageNormalizeFromLabFloat                               (_cms)StageNormalizeFromLabFloat                             color management system (little cms) ??
_cmsStageNormalizeFromXyzFloat                               (_cms)StageNormalizeFromXyzFloat                             color management system (little cms) ??
_cmsStageNormalizeToLabFloat                                 (_cms)StageNormalizeToLabFloat                               color management system (little cms) ??
_cmsStageNormalizeToXyzFloat                                 (_cms)StageNormalizeToXyzFloat                               color management system (little cms) ??
_cmsSubAlloc                                                 (_cms)SubAlloc                                               color management system (little cms) ??
_cmsSubAllocDestroy                                          (_cms)SubAllocDestroy                                        color management system (little cms) ??
_cmsSubAllocDup                                              (_cms)SubAllocDup                                            color management system (little cms) ??
_cmsTagSignature2String                                      (_cms)TagSignature2String                                    color management system (little cms) ??
_cmsTransform2toTransformAdaptor                             (_cms)Transform2toTransformAdaptor                           color management system (little cms) ??
_cmsUnlockMutex                                              (_cms)UnlockMutex                                            color management system (little cms) ??
_cmsVEC3cross                                                (_cms)VEC3cross                                              color management system (little cms) ??
_cmsVEC3distance                                             (_cms)VEC3distance                                           color management system (little cms) ??
_cmsVEC3dot                                                  (_cms)VEC3dot                                                color management system (little cms) ??
_cmsVEC3init                                                 (_cms)VEC3init                                               color management system (little cms) ??
_cmsVEC3length                                               (_cms)VEC3length                                             color management system (little cms) ??
_cmsVEC3minus                                                (_cms)VEC3minus                                              color management system (little cms) ??
_cmsWrite15Fixed16Number                                     (_cms)Write15Fixed16Number                                   color management system (little cms) ??
_cmsWriteAlignment                                           (_cms)WriteAlignment                                         color management system (little cms) ??
_cmsWriteFloat32Number                                       (_cms)WriteFloat32Number                                     color management system (little cms) ??
_cmsWriteHeader                                              (_cms)WriteHeader                                            color management system (little cms) ??
_cmsWriteProfileSequence                                     (_cms)WriteProfileSequence                                   color management system (little cms) ??
_cmsWriteTypeBase                                            (_cms)WriteTypeBase                                          color management system (little cms) ??
_cmsWriteUInt16Array                                         (_cms)WriteUInt16Array                                       color management system (little cms) ??
_cmsWriteUInt16Number                                        (_cms)WriteUInt16Number                                      color management system (little cms) ??
_cmsWriteUInt32Number                                        (_cms)WriteUInt32Number                                      color management system (little cms) ??
_cmsWriteUInt64Number                                        (_cms)WriteUInt64Number                                      color management system (little cms) ??
_cmsWriteUInt8Number                                         (_cms)WriteUInt8Number                                       color management system (little cms) ??
_cmsWriteXYZNumber                                           (_cms)WriteXYZNumber                                         color management system (little cms) ??
audIsSenCol                                                  (aud)IsSenCol                                                audit ??
audOptTab                                                    (aud)OptTab                                                  audit ??
audstwlk                                                     (aud)stwlk                                                   audit ??
bchswSampler                                                 bchswSampler                                                 ??
cmsAdaptToIlluminant                                         (cms)AdaptToIlluminant                                       color management system (little cms) ??
cmsAllocNamedColorList                                       (cms)AllocNamedColorList                                     color management system (little cms) ??
cmsAllocProfileSequenceDescription                           (cms)AllocProfileSequenceDescription                         color management system (little cms) ??
cmsAppendNamedColor                                          (cms)AppendNamedColor                                        color management system (little cms) ??
cmsBFDdeltaE                                                 (cms)BFDdeltaE                                               color management system (little cms) ??
cmsBuildGamma                                                (cms)BuildGamma                                              color management system (little cms) ??
cmsBuildParametricToneCurve                                  (cms)BuildParametricToneCurve                                color management system (little cms) ??
cmsBuildSegmentedToneCurve                                   (cms)BuildSegmentedToneCurve                                 color management system (little cms) ??
cmsBuildTabulatedToneCurve16                                 (cms)BuildTabulatedToneCurve16                               color management system (little cms) ??
cmsBuildTabulatedToneCurveFloat                              (cms)BuildTabulatedToneCurveFloat                            color management system (little cms) ??
cmsCIE2000DeltaE                                             (cms)CIE2000DeltaE                                           color management system (little cms) ??
cmsCIE94DeltaE                                               (cms)CIE94DeltaE                                             color management system (little cms) ??
cmsCMCdeltaE                                                 (cms)CMCdeltaE                                               color management system (little cms) ??
cmsChangeBuffersFormat                                       (cms)ChangeBuffersFormat                                     color management system (little cms) ??
cmsChannelsOf                                                (cms)ChannelsOf                                              color management system (little cms) ??
cmsCloseIOhandler                                            (cms)CloseIOhandler                                          color management system (little cms) ??
cmsCloseProfile                                              (cms)CloseProfile                                            color management system (little cms) ??
cmsCreateBCHSWabstractProfile                                (cms)CreateBCHSWabstractProfile                              color management system (little cms) ??
cmsCreateBCHSWabstractProfileTHR                             (cms)CreateBCHSWabstractProfileTHR                           color management system (little cms) ??
cmsCreateContext                                             (cms)CreateContext                                           color management system (little cms) ??
cmsCreateExtendedTransform                                   (cms)CreateExtendedTransform                                 color management system (little cms) ??
cmsCreateGrayProfile                                         (cms)CreateGrayProfile                                       color management system (little cms) ??
cmsCreateGrayProfileTHR                                      (cms)CreateGrayProfileTHR                                    color management system (little cms) ??
cmsCreateInkLimitingDeviceLink                               (cms)CreateInkLimitingDeviceLink                             color management system (little cms) ??
cmsCreateInkLimitingDeviceLinkTHR                            (cms)CreateInkLimitingDeviceLinkTHR                          color management system (little cms) ??
cmsCreateLab2Profile                                         (cms)CreateLab2Profile                                       color management system (little cms) ??
cmsCreateLab2ProfileTHR                                      (cms)CreateLab2ProfileTHR                                    color management system (little cms) ??
cmsCreateLab4Profile                                         (cms)CreateLab4Profile                                       color management system (little cms) ??
cmsCreateLab4ProfileTHR                                      (cms)CreateLab4ProfileTHR                                    color management system (little cms) ??
cmsCreateLinearizationDeviceLink                             (cms)CreateLinearizationDeviceLink                           color management system (little cms) ??
cmsCreateLinearizationDeviceLinkTHR                          (cms)CreateLinearizationDeviceLinkTHR                        color management system (little cms) ??
cmsCreateMultiprofileTransform                               (cms)CreateMultiprofileTransform                             color management system (little cms) ??
cmsCreateMultiprofileTransformTHR                            (cms)CreateMultiprofileTransformTHR                          color management system (little cms) ??
cmsCreateNULLProfile                                         (cms)CreateNULLProfile                                       color management system (little cms) ??
cmsCreateNULLProfileTHR                                      (cms)CreateNULLProfileTHR                                    color management system (little cms) ??
cmsCreateProfilePlaceholder                                  (cms)CreateProfilePlaceholder                                color management system (little cms) ??
cmsCreateProofingTransform                                   (cms)CreateProofingTransform                                 color management system (little cms) ??
cmsCreateProofingTransformTHR                                (cms)CreateProofingTransformTHR                              color management system (little cms) ??
cmsCreateRGBProfile                                          (cms)CreateRGBProfile                                        color management system (little cms) ??
cmsCreateRGBProfileTHR                                       (cms)CreateRGBProfileTHR                                     color management system (little cms) ??
cmsCreateTransform                                           (cms)CreateTransform                                         color management system (little cms) ??
cmsCreateTransformTHR                                        (cms)CreateTransformTHR                                      color management system (little cms) ??
cmsCreateXYZProfile                                          (cms)CreateXYZProfile                                        color management system (little cms) ??
cmsCreateXYZProfileTHR                                       (cms)CreateXYZProfileTHR                                     color management system (little cms) ??
cmsCreate_sRGBProfile                                        (cms)Create_sRGBProfile                                      color management system (little cms) ??
cmsCreate_sRGBProfileTHR                                     (cms)Create_sRGBProfileTHR                                   color management system (little cms) ??
cmsD50_XYZ                                                   (cms)D50_XYZ                                                 color management system (little cms) ??
cmsD50_xyY                                                   (cms)D50_xyY                                                 color management system (little cms) ??
cmsDeleteContext                                             (cms)DeleteContext                                           color management system (little cms) ??
cmsDeleteTransform                                           (cms)DeleteTransform                                         color management system (little cms) ??
cmsDeltaE                                                    (cms)DeltaE                                                  color management system (little cms) ??
cmsDesaturateLab                                             (cms)DesaturateLab                                           color management system (little cms) ??
cmsDetectBlackPoint                                          (cms)DetectBlackPoint                                        color management system (little cms) ??
cmsDetectDestinationBlackPoint                               (cms)DetectDestinationBlackPoint                             color management system (little cms) ??
cmsDetectTAC                                                 (cms)DetectTAC                                               color management system (little cms) ??
cmsDictAddEntry                                              (cms)DictAddEntry                                            color management system (little cms) ??
cmsDictAlloc                                                 (cms)DictAlloc                                               color management system (little cms) ??
cmsDictDup                                                   (cms)DictDup                                                 color management system (little cms) ??
cmsDictFree                                                  (cms)DictFree                                                color management system (little cms) ??
cmsDictGetEntryList                                          (cms)DictGetEntryList                                        color management system (little cms) ??
cmsDictNextEntry                                             (cms)DictNextEntry                                           color management system (little cms) ??
cmsDoTransform                                               (cms)DoTransform                                             color management system (little cms) ??
cmsDoTransformLineStride                                     (cms)DoTransformLineStride                                   color management system (little cms) ??
cmsDoTransformStride                                         (cms)DoTransformStride                                       color management system (little cms) ??
cmsDupContext                                                (cms)DupContext                                              color management system (little cms) ??
cmsDupNamedColorList                                         (cms)DupNamedColorList                                       color management system (little cms) ??
cmsDupProfileSequenceDescription                             (cms)DupProfileSequenceDescription                           color management system (little cms) ??
cmsDupToneCurve                                              (cms)DupToneCurve                                            color management system (little cms) ??
cmsEstimateGamma                                             (cms)EstimateGamma                                           color management system (little cms) ??
cmsEvalToneCurve16                                           (cms)EvalToneCurve16                                         color management system (little cms) ??
cmsEvalToneCurveFloat                                        (cms)EvalToneCurveFloat                                      color management system (little cms) ??
cmsFloat2LabEncoded                                          (cms)Float2LabEncoded                                        color management system (little cms) ??
cmsFloat2LabEncodedV2                                        (cms)Float2LabEncodedV2                                      color management system (little cms) ??
cmsFloat2XYZEncoded                                          (cms)Float2XYZEncoded                                        color management system (little cms) ??
cmsFormatterForColorspaceOfProfile                           (cms)FormatterForColorspaceOfProfile                         color management system (little cms) ??
cmsFormatterForPCSOfProfile                                  (cms)FormatterForPCSOfProfile                                color management system (little cms) ??
cmsFreeNamedColorList                                        (cms)FreeNamedColorList                                      color management system (little cms) ??
cmsFreeProfileSequenceDescription                            (cms)FreeProfileSequenceDescription                          color management system (little cms) ??
cmsFreeToneCurve                                             (cms)FreeToneCurve                                           color management system (little cms) ??
cmsFreeToneCurveTriple                                       (cms)FreeToneCurveTriple                                     color management system (little cms) ??
cmsGetAlarmCodes                                             (cms)GetAlarmCodes                                           color management system (little cms) ??
cmsGetAlarmCodesTHR                                          (cms)GetAlarmCodesTHR                                        color management system (little cms) ??
cmsGetColorSpace                                             (cms)GetColorSpace                                           color management system (little cms) ??
cmsGetContextUserData                                        (cms)GetContextUserData                                      color management system (little cms) ??
cmsGetDeviceClass                                            (cms)GetDeviceClass                                          color management system (little cms) ??
cmsGetEncodedCMMversion                                      (cms)GetEncodedCMMversion                                    color management system (little cms) ??
cmsGetEncodedICCversion                                      (cms)GetEncodedICCversion                                    color management system (little cms) ??
cmsGetHeaderAttributes                                       (cms)GetHeaderAttributes                                     color management system (little cms) ??
cmsGetHeaderCreationDateTime                                 (cms)GetHeaderCreationDateTime                               color management system (little cms) ??
cmsGetHeaderCreator                                          (cms)GetHeaderCreator                                        color management system (little cms) ??
cmsGetHeaderFlags                                            (cms)GetHeaderFlags                                          color management system (little cms) ??
cmsGetHeaderManufacturer                                     (cms)GetHeaderManufacturer                                   color management system (little cms) ??
cmsGetHeaderModel                                            (cms)GetHeaderModel                                          color management system (little cms) ??
cmsGetHeaderProfileID                                        (cms)GetHeaderProfileID                                      color management system (little cms) ??
cmsGetHeaderRenderingIntent                                  (cms)GetHeaderRenderingIntent                                color management system (little cms) ??
cmsGetNamedColorList                                         (cms)GetNamedColorList                                       color management system (little cms) ??
cmsGetPCS                                                    (cms)GetPCS                                                  color management system (little cms) ??
cmsGetPipelineContextID                                      (cms)GetPipelineContextID                                    color management system (little cms) ??
cmsGetProfileContextID                                       (cms)GetProfileContextID                                     color management system (little cms) ??
cmsGetProfileIOhandler                                       (cms)GetProfileIOhandler                                     color management system (little cms) ??
cmsGetProfileInfo                                            (cms)GetProfileInfo                                          color management system (little cms) ??
cmsGetProfileInfoASCII                                       (cms)GetProfileInfoASCII                                     color management system (little cms) ??
cmsGetProfileVersion                                         (cms)GetProfileVersion                                       color management system (little cms) ??
cmsGetSupportedIntents                                       (cms)GetSupportedIntents                                     color management system (little cms) ??
cmsGetSupportedIntentsTHR                                    (cms)GetSupportedIntentsTHR                                  color management system (little cms) ??
cmsGetTagCount                                               (cms)GetTagCount                                             color management system (little cms) ??
cmsGetTagSignature                                           (cms)GetTagSignature                                         color management system (little cms) ??
cmsGetToneCurveEstimatedTable                                (cms)GetToneCurveEstimatedTable                              color management system (little cms) ??
cmsGetToneCurveEstimatedTableEntries                         (cms)GetToneCurveEstimatedTableEntries                       color management system (little cms) ??
cmsGetToneCurveParametricType                                (cms)GetToneCurveParametricType                              color management system (little cms) ??
cmsGetTransformContextID                                     (cms)GetTransformContextID                                   color management system (little cms) ??
cmsGetTransformInputFormat                                   (cms)GetTransformInputFormat                                 color management system (little cms) ??
cmsGetTransformOutputFormat                                  (cms)GetTransformOutputFormat                                color management system (little cms) ??
cmsIsCLUT                                                    (cms)IsCLUT                                                  color management system (little cms) ??
cmsIsIntentSupported                                         (cms)IsIntentSupported                                       color management system (little cms) ??
cmsIsMatrixShaper                                            (cms)IsMatrixShaper                                          color management system (little cms) ??
cmsIsTag                                                     (cms)IsTag                                                   color management system (little cms) ??
cmsIsToneCurveDescending                                     (cms)IsToneCurveDescending                                   color management system (little cms) ??
cmsIsToneCurveLinear                                         (cms)IsToneCurveLinear                                       color management system (little cms) ??
cmsIsToneCurveMonotonic                                      (cms)IsToneCurveMonotonic                                    color management system (little cms) ??
cmsIsToneCurveMultisegment                                   (cms)IsToneCurveMultisegment                                 color management system (little cms) ??
cmsJoinToneCurve                                             (cms)JoinToneCurve                                           color management system (little cms) ??
cmsLCh2Lab                                                   (cms)LCh2Lab                                                 color management system (little cms) ??
cmsLab2LCh                                                   (cms)Lab2LCh                                                 color management system (little cms) ??
cmsLab2XYZ                                                   (cms)Lab2XYZ                                                 color management system (little cms) ??
cmsLabEncoded2Float                                          (cms)LabEncoded2Float                                        color management system (little cms) ??
cmsLabEncoded2FloatV2                                        (cms)LabEncoded2FloatV2                                      color management system (little cms) ??
cmsLinkTag                                                   (cms)LinkTag                                                 color management system (little cms) ??
cmsMLUalloc                                                  (cms)MLUalloc                                                color management system (little cms) ??
cmsMLUdup                                                    (cms)MLUdup                                                  color management system (little cms) ??
cmsMLUfree                                                   (cms)MLUfree                                                 color management system (little cms) ??
cmsMLUgetASCII                                               (cms)MLUgetASCII                                             color management system (little cms) ??
cmsMLUgetTranslation                                         (cms)MLUgetTranslation                                       color management system (little cms) ??
cmsMLUgetWide                                                (cms)MLUgetWide                                              color management system (little cms) ??
cmsMLUsetASCII                                               (cms)MLUsetASCII                                             color management system (little cms) ??
cmsMLUsetWide                                                (cms)MLUsetWide                                              color management system (little cms) ??
cmsMLUtranslationsCodes                                      (cms)MLUtranslationsCodes                                    color management system (little cms) ??
cmsMLUtranslationsCount                                      (cms)MLUtranslationsCount                                    color management system (little cms) ??
cmsNamedColorCount                                           (cms)NamedColorCount                                         color management system (little cms) ??
cmsNamedColorIndex                                           (cms)NamedColorIndex                                         color management system (little cms) ??
cmsNamedColorInfo                                            (cms)NamedColorInfo                                          color management system (little cms) ??
cmsOpenIOhandlerFromFile                                     (cms)OpenIOhandlerFromFile                                   color management system (little cms) ??
cmsOpenIOhandlerFromMem                                      (cms)OpenIOhandlerFromMem                                    color management system (little cms) ??
cmsOpenIOhandlerFromNULL                                     (cms)OpenIOhandlerFromNULL                                   color management system (little cms) ??
cmsOpenIOhandlerFromStream                                   (cms)OpenIOhandlerFromStream                                 color management system (little cms) ??
cmsOpenProfileFromFile                                       (cms)OpenProfileFromFile                                     color management system (little cms) ??
cmsOpenProfileFromFileTHR                                    (cms)OpenProfileFromFileTHR                                  color management system (little cms) ??
cmsOpenProfileFromIOhandler2THR                              (cms)OpenProfileFromIOhandler2THR                            color management system (little cms) ??
cmsOpenProfileFromIOhandlerTHR                               (cms)OpenProfileFromIOhandlerTHR                             color management system (little cms) ??
cmsOpenProfileFromMem                                        (cms)OpenProfileFromMem                                      color management system (little cms) ??
cmsOpenProfileFromMemTHR                                     (cms)OpenProfileFromMemTHR                                   color management system (little cms) ??
cmsOpenProfileFromStream                                     (cms)OpenProfileFromStream                                   color management system (little cms) ??
cmsOpenProfileFromStreamTHR                                  (cms)OpenProfileFromStreamTHR                                color management system (little cms) ??
cmsPipelineAlloc                                             (cms)PipelineAlloc                                           color management system (little cms) ??
cmsPipelineCat                                               (cms)PipelineCat                                             color management system (little cms) ??
cmsPipelineCheckAndRetreiveStages                            (cms)PipelineCheckAndRetreiveStages                          color management system (little cms) ??
cmsPipelineDup                                               (cms)PipelineDup                                             color management system (little cms) ??
cmsPipelineEval16                                            (cms)PipelineEval16                                          color management system (little cms) ??
cmsPipelineEvalFloat                                         (cms)PipelineEvalFloat                                       color management system (little cms) ??
cmsPipelineEvalReverseFloat                                  (cms)PipelineEvalReverseFloat                                color management system (little cms) ??
cmsPipelineFree                                              (cms)PipelineFree                                            color management system (little cms) ??
cmsPipelineGetPtrToFirstStage                                (cms)PipelineGetPtrToFirstStage                              color management system (little cms) ??
cmsPipelineGetPtrToLastStage                                 (cms)PipelineGetPtrToLastStage                               color management system (little cms) ??
cmsPipelineInputChannels                                     (cms)PipelineInputChannels                                   color management system (little cms) ??
cmsPipelineInsertStage                                       (cms)PipelineInsertStage                                     color management system (little cms) ??
cmsPipelineOutputChannels                                    (cms)PipelineOutputChannels                                  color management system (little cms) ??
cmsPipelineSetSaveAs8bitsFlag                                (cms)PipelineSetSaveAs8bitsFlag                              color management system (little cms) ??
cmsPipelineStageCount                                        (cms)PipelineStageCount                                      color management system (little cms) ??
cmsPipelineUnlinkStage                                       (cms)PipelineUnlinkStage                                     color management system (little cms) ??
cmsPlugin                                                    (cms)Plugin                                                  color management system (little cms) ??
cmsPluginTHR                                                 (cms)PluginTHR                                               color management system (little cms) ??
cmsReadRawTag                                                (cms)ReadRawTag                                              color management system (little cms) ??
cmsReadTag                                                   (cms)ReadTag                                                 color management system (little cms) ??
cmsReverseToneCurve                                          (cms)ReverseToneCurve                                        color management system (little cms) ??
cmsReverseToneCurveEx                                        (cms)ReverseToneCurveEx                                      color management system (little cms) ??
cmsSaveProfileToFile                                         (cms)SaveProfileToFile                                       color management system (little cms) ??
cmsSaveProfileToIOhandler                                    (cms)SaveProfileToIOhandler                                  color management system (little cms) ??
cmsSaveProfileToMem                                          (cms)SaveProfileToMem                                        color management system (little cms) ??
cmsSaveProfileToStream                                       (cms)SaveProfileToStream                                     color management system (little cms) ??
cmsSetAdaptationState                                        (cms)SetAdaptationState                                      color management system (little cms) ??
cmsSetAdaptationStateTHR                                     (cms)SetAdaptationStateTHR                                   color management system (little cms) ??
cmsSetAlarmCodes                                             (cms)SetAlarmCodes                                           color management system (little cms) ??
cmsSetAlarmCodesTHR                                          (cms)SetAlarmCodesTHR                                        color management system (little cms) ??
cmsSetColorSpace                                             (cms)SetColorSpace                                           color management system (little cms) ??
cmsSetDeviceClass                                            (cms)SetDeviceClass                                          color management system (little cms) ??
cmsSetEncodedICCversion                                      (cms)SetEncodedICCversion                                    color management system (little cms) ??
cmsSetHeaderAttributes                                       (cms)SetHeaderAttributes                                     color management system (little cms) ??
cmsSetHeaderFlags                                            (cms)SetHeaderFlags                                          color management system (little cms) ??
cmsSetHeaderManufacturer                                     (cms)SetHeaderManufacturer                                   color management system (little cms) ??
cmsSetHeaderModel                                            (cms)SetHeaderModel                                          color management system (little cms) ??
cmsSetHeaderProfileID                                        (cms)SetHeaderProfileID                                      color management system (little cms) ??
cmsSetHeaderRenderingIntent                                  (cms)SetHeaderRenderingIntent                                color management system (little cms) ??
cmsSetLogErrorHandler                                        (cms)SetLogErrorHandler                                      color management system (little cms) ??
cmsSetLogErrorHandlerTHR                                     (cms)SetLogErrorHandlerTHR                                   color management system (little cms) ??
cmsSetPCS                                                    (cms)SetPCS                                                  color management system (little cms) ??
cmsSetProfileVersion                                         (cms)SetProfileVersion                                       color management system (little cms) ??
cmsSignalError                                               (cms)SignalError                                             color management system (little cms) ??
cmsSliceSpace16                                              (cms)SliceSpace16                                            color management system (little cms) ??
cmsSliceSpaceFloat                                           (cms)SliceSpaceFloat                                         color management system (little cms) ??
cmsSmoothToneCurve                                           (cms)SmoothToneCurve                                         color management system (little cms) ??
cmsStageAllocCLut16bit                                       (cms)StageAllocCLut16bit                                     color management system (little cms) ??
cmsStageAllocCLut16bitGranular                               (cms)StageAllocCLut16bitGranular                             color management system (little cms) ??
cmsStageAllocCLutFloat                                       (cms)StageAllocCLutFloat                                     color management system (little cms) ??
cmsStageAllocCLutFloatGranular                               (cms)StageAllocCLutFloatGranular                             color management system (little cms) ??
cmsStageAllocIdentity                                        (cms)StageAllocIdentity                                      color management system (little cms) ??
cmsStageAllocMatrix                                          (cms)StageAllocMatrix                                        color management system (little cms) ??
cmsStageAllocToneCurves                                      (cms)StageAllocToneCurves                                    color management system (little cms) ??
cmsStageData                                                 (cms)StageData                                               color management system (little cms) ??
cmsStageDup                                                  (cms)StageDup                                                color management system (little cms) ??
cmsStageFree                                                 (cms)StageFree                                               color management system (little cms) ??
cmsStageInputChannels                                        (cms)StageInputChannels                                      color management system (little cms) ??
cmsStageNext                                                 (cms)StageNext                                               color management system (little cms) ??
cmsStageOutputChannels                                       (cms)StageOutputChannels                                     color management system (little cms) ??
cmsStageSampleCLut16bit                                      (cms)StageSampleCLut16bit                                    color management system (little cms) ??
cmsStageSampleCLutFloat                                      (cms)StageSampleCLutFloat                                    color management system (little cms) ??
cmsStageType                                                 (cms)StageType                                               color management system (little cms) ??
cmsTagLinkedTo                                               (cms)TagLinkedTo                                             color management system (little cms) ??
cmsTempFromWhitePoint                                        (cms)TempFromWhitePoint                                      color management system (little cms) ??
cmsTransform2DeviceLink                                      (cms)Transform2DeviceLink                                    color management system (little cms) ??
cmsUnregisterPlugins                                         (cms)UnregisterPlugins                                       color management system (little cms) ??
cmsUnregisterPluginsTHR                                      (cms)UnregisterPluginsTHR                                    color management system (little cms) ??
cmsWhitePointFromTemp                                        (cms)WhitePointFromTemp                                      color management system (little cms) ??
cmsWriteRawTag                                               (cms)WriteRawTag                                             color management system (little cms) ??
cmsWriteTag                                                  (cms)WriteTag                                                color management system (little cms) ??
cmsXYZ2Lab                                                   (cms)XYZ2Lab                                                 color management system (little cms) ??
cmsXYZ2xyY                                                   (cms)XYZ2xyY                                                 color management system (little cms) ??
cmsXYZEncoded2Float                                          (cms)XYZEncoded2Float                                        color management system (little cms) ??
cmsfilelength                                                (cms)filelength                                              color management system (little cms) ??
cmsstrcasecmp                                                (cms)strcasecmp                                              color management system (little cms) ??
cmsxyY2XYZ                                                   (cms)xyY2XYZ                                                 color management system (little cms) ??
copy16                                                       copy16                                                       ??
copy32                                                       copy32                                                       ??
copy64                                                       copy64                                                       ??
copy8                                                        copy8                                                        ??
copy_and_swap_left                                           copy_and_swap_left                                           ??
copy_and_swap_right                                          copy_and_swap_right                                          ??
dbnest_ns_spawn_local                                        dbnest_ns_spawn_local                                        ??
defMtxCreate                                                 defMtxCreate                                                 ??
defMtxDestroy                                                defMtxDestroy                                                ??
defMtxLock                                                   defMtxLock                                                   ??
defMtxUnlock                                                 defMtxUnlock                                                 ??
errorHandler                                                 (err)orHandler                                               error recovery ??
from16to8                                                    from16to8                                                    ??
from16toDBL                                                  from16toDBL                                                  ??
from16toFLT                                                  from16toFLT                                                  ??
from16toHLF                                                  from16toHLF                                                  ??
from8to16                                                    from8to16                                                    ??
from8toDBL                                                   from8toDBL                                                   ??
from8toFLT                                                   from8toFLT                                                   ??
from8toHLF                                                   from8toHLF                                                   ??
fromDBLto16                                                  fromDBLto16                                                  ??
fromDBLto8                                                   fromDBLto8                                                   ??
fromDBLtoFLT                                                 fromDBLtoFLT                                                 ??
fromDBLtoHLF                                                 fromDBLtoHLF                                                 ??
fromFLTto16                                                  fromFLTto16                                                  ??
fromFLTto8                                                   fromFLTto8                                                   ??
fromFLTtoDBL                                                 fromFLTtoDBL                                                 ??
fromFLTtoHLF                                                 fromFLTtoHLF                                                 ??
fromHLFto16                                                  fromHLFto16                                                  ??
fromHLFto8                                                   fromHLFto8                                                   ??
fromHLFtoDBL                                                 fromHLFtoDBL                                                 ??
fromHLFtoFLT                                                 fromHLFtoFLT                                                 ??
getILData                                                    getILData                                                    ??
getaddrinfo                                                  getaddrinfo                                                  ??
is_ptr_aligned                                               is_ptr_aligned                                               ??
jonbit8_copy_swap_memory0                                    (jon)bit8_copy_swap_memory0                                  java ??
jonbit8_copy_swap_memory0__cst__                             (jon)bit8_copy_swap_memory0__cst__                           java ??
jonbit9_copy_swap_memory0                                    (jon)bit9_copy_swap_memory0                                  java ??
jonbit_copy_swap_memory0                                     (jon)bit_copy_swap_memory0                                   java ??
jonfdi8_seek0                                                (jon)fdi8_seek0                                              java ??
jonfdi8_seek0__cst__                                         (jon)fdi8_seek0__cst__                                       java ??
jonfdi9_seek0                                                (jon)fdi9_seek0                                              java ??
jonfdi_seek0                                                 (jon)fdi_seek0                                               java ??
jsiGetAQScheduledJobs                                        (js)iGetAQScheduledJobs                                      job scheduing ??
jsiGetAQScheduledJobs_internal                               (js)iGetAQScheduledJobs_internal                             job scheduing ??
jsiGetAQScheduledJobs_test                                   (js)iGetAQScheduledJobs_test                                 job scheduing ??
jskqDecreasePDB_AQJobs                                       (js)kqDecreasePDB_AQJobs                                     job scheduing ??
jskqIncreasePDB_AQJobs                                       (js)kqIncreasePDB_AQJobs                                     job scheduing ??
jzn0DomDeleteFieldByName                                     (jzn)0DomDeleteFieldByName                                   json ??
jzn0DomFreeNode                                              (jzn)0DomFreeNode                                            json ??
jzn0DomHashGetName                                           (jzn)0DomHashGetName                                         json ??
jzn0DomLoadStream                                            (jzn)0DomLoadStream                                          json ??
jzn0DomMakeScalar                                            (jzn)0DomMakeScalar                                          json ??
jzn0DomNewScalarVal                                          (jzn)0DomNewScalarVal                                        json ??
jzn0DomPutNameShareWithOSONFieldNameBuf                      (jzn)0DomPutNameShareWithOSONFieldNameBuf                    json ??
jzn0DomUnlinkFieldByName                                     (jzn)0DomUnlinkFieldByName                                   json ??
jznDomEmitFields                                             (jzn)DomEmitFields                                           json ??
jznDomEmitSortedFields                                       (jzn)DomEmitSortedFields                                     json ??
jznDomEquals_h                                               (jzn)DomEquals_h                                             json ??
jznDomNodeGetDescendantNodes_h                               (jzn)DomNodeGetDescendantNodes_h                             json ??
jznDomWriterPushEvent                                        (jzn)DomWriterPushEvent                                      json ??
jznEngGetLiteralVal                                          (jzn)EngGetLiteralVal                                        json ??
jznEngNormEvents                                             (jzn)EngNormEvents                                           json ??
jznIMCDecodePathVal                                          (jzn)IMCDecodePathVal                                        json ??
jznIMCJFillSetOSONPathVal                                    (jzn)IMCJFillSetOSONPathVal                                  json ??
jznIndexGetErrcode                                           (jzn)IndexGetErrcode                                         json ??
jznIndexGetFlags                                             (jzn)IndexGetFlags                                           json ??
jznIndexGetNumOfNumberPathVals                               (jzn)IndexGetNumOfNumberPathVals                             json ??
jznIndexReadScalar                                           (jzn)IndexReadScalar                                         json ??
jznIndexSetDocument                                          (jzn)IndexSetDocument                                        json ??
jznIndexSetFlags                                             (jzn)IndexSetFlags                                           json ??
jznOctDiagPrintOSONTree                                      (jzn)OctDiagPrintOSONTree                                    json ??
jznOctGetArrayValueBatch                                     (jzn)OctGetArrayValueBatch                                   json ??
jznOctGetScalarValueC_WithNdPtr                              (jzn)OctGetScalarValueC_WithNdPtr                            json ??
jznOctUpd_InPlaceUpdLeafScalVal                              (jzn)OctUpd_InPlaceUpdLeafScalVal                            json ??
jznParserNextEJsonEvent                                      (jzn)ParserNextEJsonEvent                                    json ??
jznPatchDoCopy                                               (jzn)PatchDoCopy                                             json ??
jznXmlSetMode                                                (jzn)XmlSetMode                                              json ??
jzn_compare_str_pathvals                                     (jzn)_compare_str_pathvals                                   json ??
jznbEventWriterPushEvent                                     (jzn)bEventWriterPushEvent                                   json ??
jznoctDeleteFieldByName                                      (jzn)octDeleteFieldByName                                    json ??
jznoctDomFreeNode                                            (jzn)octDomFreeNode                                          json ??
jznoctEncodeOraNumLen                                        (jzn)octEncodeOraNumLen                                      json ??
jznoctIsOSONDomDoc                                           (jzn)octIsOSONDomDoc                                         json ??
jznoctLoadInMemDomFromInputOSON_WF                           (jzn)octLoadInMemDomFromInputOSON_WF                         json ??
jznoctNewScalarValStub                                       (jzn)octNewScalarValStub                                     json ??
jznoctRenameFieldStub2                                       (jzn)octRenameFieldStub2                                     json ??
jznoctUnlinkFieldByNameStub                                  (jzn)octUnlinkFieldByNameStub                                json ??
jznoctVerifyFieldNameDict                                    (jzn)octVerifyFieldNameDict                                  json ??
jznoct_DomToOSON                                             (jzn)oct_DomToOSON                                           json ??
jznoct_DomToOSONIter                                         (jzn)oct_DomToOSONIter                                       json ??
jznoct_DomToOSONIterEnd                                      (jzn)oct_DomToOSONIterEnd                                    json ??
jznoct_DomToOSONIterPrep                                     (jzn)oct_DomToOSONIterPrep                                   json ??
jznoct_dom_visit_h                                           (jzn)oct_dom_visit_h                                         json ??
jznoct_sv_dump                                               (jzn)oct_sv_dump                                             json ??
jznpUnparseCmpOp                                             (jzn)pUnparseCmpOp                                           json ??
jznpUnparseExpr                                              (jzn)pUnparseExpr                                            json ??
jznpUnparsePathIntoBuf                                       (jzn)pUnparsePathIntoBuf                                     json ??
jznpUnparseStep                                              (jzn)pUnparseStep                                            json ??
jznuDurationToString                                         (jzn)uDurationToString                                       json ??
jznuFileStreamOpen                                           (jzn)uFileStreamOpen                                         json ??
jznuFormatFloat                                              (jzn)uFormatFloat                                            json ??
jznuGetEventRecordVA                                         (jzn)uGetEventRecordVA                                       json ??
jznuMemoryStreamOpen                                         (jzn)uMemoryStreamOpen                                       json ??
jznuPrintWasReplaced                                         (jzn)uPrintWasReplaced                                       json ??
jznuPrintWriterPushEvent                                     (jzn)uPrintWriterPushEvent                                   json ??
jznuRepairString                                             (jzn)uRepairString                                           json ??
jznuToAnyType                                                (jzn)uToAnyType                                              json ??
jznu_filclose                                                (jzn)u_filclose                                              json ??
jznu_filopen                                                 (jzn)u_filopen                                               json ??
jznu_filread                                                 (jzn)u_filread                                               json ??
jznu_filwrite                                                (jzn)u_filwrite                                              json ??
kapiSetInterruptMode                                         (ka)piSetInterruptMode                                       kernel access ??
kdmado_process_aimlevel                                      (kdmado)_process_aimlevel                                    kernel data in-memory data layer ADO ??
kestsaIsAPAPlanDifferent                                     (kestsa)IsAPAPlanDifferent                                   kernel event SQL manageability tokenize (?) fix regression/parallel execution ??
kfdvalHdrPfmt                                                (kfdva)lHdrPfmt                                              kernel automatic storage management disk virtual ATB ??
kffFdFmtMapRange                                             (kff)FdFmtMapRange                                           kernel automatic storage management KFF ??
kffPreFormatRange                                            (kff)PreFormatRange                                          kernel automatic storage management KFF ??
kfrcDirGrowPriv                                              (kfrc)DirGrowPriv                                            kernel automatic storage management recovery COD ??
kgopc_transform_nativeToSwift                                (kg)opc_transform_nativeToSwift                              kernel generic ??
kgwscl_transform_nativeToSwift                               (kg)wscl_transform_nativeToSwift                             kernel generic ??
kjbl_clear_lsr_pdb                                           (kjbl)_clear_lsr_pdb                                         kernel lock management global cache service lock table ??
kjgcr_GetTopCPU                                              (kj)gcr_GetTopCPU                                            kernel lock management ??
kjgcr_RunSyncTask                                            (kj)gcr_RunSyncTask                                          kernel lock management ??
kjgcr_SlaveReqGetSlot                                        (kj)gcr_SlaveReqGetSlot                                      kernel lock management ??
kjscapk_check_access_skew                                    (kjsc)apk_check_access_skew                                  kernel lock management RAC global stats ??
kjzn_mark_hang_pend_res                                      (kjzn)_mark_hang_pend_res                                    kernel lock management DIAG node layer ??
kjzndetect                                                   (kjzn)detect                                                 kernel lock management DIAG node layer ??
kkeIsEmptyEqJoinCol                                          (kke)IsEmptyEqJoinCol                                        kernel compile cost engine ??
kkeccf                                                       (kke)ccf                                                     kernel compile cost engine ??
kkqtutlFindWifCB                                             (kkqt)utlFindWifCB                                           kernel compile query  table ??
kml_rgtr_remap_endp                                          (kml)_rgtr_remap_endp                                        kernel multi threaded/mman listener registration (lreg) ??
kpdbClearGenClnQuarantine                                    (kpdb)ClearGenClnQuarantine                                  kernel programmatic interface pluggable database ??
kpdbIsGenClnQuarantined                                      (kpdb)IsGenClnQuarantined                                    kernel programmatic interface pluggable database ??
kpdbSetGenClnQuarantine                                      (kpdb)SetGenClnQuarantine                                    kernel programmatic interface pluggable database ??
kpdbfdDeleteEmptySessions                                    (kpdb)fdDeleteEmptySessions                                  kernel programmatic interface pluggable database ??
kpdbfdIsOrphanCloneCbk                                       (kpdb)fdIsOrphanCloneCbk                                     kernel programmatic interface pluggable database ??
kpdbfdRemovePDBAppStatus                                     (kpdb)fdRemovePDBAppStatus                                   kernel programmatic interface pluggable database ??
kpdbfdRemovePDBAppStatusCbk                                  (kpdb)fdRemovePDBAppStatusCbk                                kernel programmatic interface pluggable database ??
kpoaTACFailoverType                                          (kpo)aTACFailoverType                                        kernel programmatic interface oracle ??
kpondRmtCqnPst                                               (kpond)RmtCqnPst                                             kernel programmatic interface oracle notification advanced queuing  ??
kpondtoutnfy                                                 (kpond)toutnfy                                               kernel programmatic interface oracle notification advanced queuing  ??
kpunServerVersion                                            (kpun)ServerVersion                                          kernel programmatic interface user streams advanced queuing  ??
kpunValidateReg                                              (kpun)ValidateReg                                            kernel programmatic interface user streams advanced queuing  ??
kpunlConsConnStr3                                            (kpun)lConsConnStr3                                          kernel programmatic interface user streams advanced queuing  ??
kqrClearUOL                                                  (kqr)ClearUOL                                                kernel query dictionary/row cache ??
kqrReturnFirstEnqueue                                        (kqr)ReturnFirstEnqueue                                      kernel query dictionary/row cache ??
kqrSetUOL                                                    (kqr)SetUOL                                                  kernel query dictionary/row cache ??
krbiWalletOkForTde                                           (krbi)WalletOkForTde                                         kernel redo backup/restore dbms_backup_restore package ??
ksdhng_dump_cachecel                                         (ksdhng)_dump_cachecel                                       kernel service (VOS) debug internal errors hang analyze ??
ksdhng_dump_sess_blocker_chains                              (ksdhng)_dump_sess_blocker_chains                            kernel service (VOS) debug internal errors hang analyze ??
ksdhng_dump_sess_final_blocker                               (ksdhng)_dump_sess_final_blocker                             kernel service (VOS) debug internal errors hang analyze ??
ksirtfini                                                    (ksi)rtfini                                                  kernel service (VOS) instance locking ??
kskrmiipub                                                   (ksk)rmiipub                                                 kernel service (VOS) resource manager ??
kskrmpdbcpucntmultmod                                        (ksk)rmpdbcpucntmultmod                                      kernel service (VOS) resource manager ??
ksmrf_get_process_maximum                                    (ksmrf)_get_process_maximum                                  kernel service (VOS) memory real free heap ??
kspIgnoreParamError                                          (ksp)IgnoreParamError                                        kernel service (VOS) parameter ??
kspisspe_mcb                                                 (ksp)isspe_mcb                                               kernel service (VOS) parameter ??
kwqbcInitRec11GBuffQ                                         (kwq)bcInitRec11GBuffQ                                       kernel advanced queuing  ??
kwqbconfyCbk                                                 (kwq)bconfyCbk                                               kernel advanced queuing  ??
kxfxsHandleSchdEvt2                                          (kxfx)sHandleSchdEvt2                                        kernel execution parallel query execution ??
kzckmWalletInArchive                                         (kzck)mWalletInArchive                                       kernel security Code-Based Access Control encryption support ??
kzckmrOpenRootOnPlug                                         (kzck)mrOpenRootOnPlug                                       kernel security Code-Based Access Control encryption support ??
kzckmrXmlVldTDEKeys                                          (kzck)mrXmlVldTDEKeys                                        kernel security Code-Based Access Control encryption support ??
kzckmrXmlVldTDEKeysFile                                      (kzck)mrXmlVldTDEKeysFile                                    kernel security Code-Based Access Control encryption support ??
kzckmrXmlVldTDEMetaHSM                                       (kzck)mrXmlVldTDEMetaHSM                                     kernel security Code-Based Access Control encryption support ??
kzekm_enqueue_id_ks_ctx_mem                                  (kz)ekm_enqueue_id_ks_ctx_mem                                kernel security ??
mdgrXmlErrorHandler                                          (mdgr)XmlErrorHandler                                        spatial spatial georaster ??
nlad_get_exp_proxies                                         (nl)ad_get_exp_proxies                                       network library ??
nttrldpp                                                     (ntt)rldpp                                                   network transport tcp/ip ??
qerltXTreg                                                   (qerlt)XTreg                                                 query execute rowsource load table ??
qerxtCleanup                                                 (qerxt)Cleanup                                               query execute rowsource external table ??
qerxtPostAllocate                                            (qerxt)PostAllocate                                          query execute rowsource external table ??
qjsnHasIsJsonCons_tabno_colno_h                              (qjsn)HasIsJsonCons_tabno_colno_h                            query json ??
qjsnProcDg                                                   (qjsn)ProcDg                                                 query json ??
qjsnXformSetOSON_Validate                                    (qjsn)XformSetOSON_Validate                                  query json ??
qks3tCheckIDLElem                                            (qks3t)CheckIDLElem                                          query kernel sql temp table transformation ??
qks3tCheckIDLList                                            (qks3t)CheckIDLList                                          query kernel sql temp table transformation ??
qosdMonNonCGCol                                              (qosd)MonNonCGCol                                            query optimizer statistics sql plan directive ??
releaseILData                                                releaseILData                                                ??
sjonfile_jonfdi_seek0                                        sjonfile_jonfdi_seek0                                        ??
skgmrf_get_max_page_count                                    (skgmrf)_get_max_page_count                                  operating system dependent kernel generic memory (os dependent) real free heap ?
                                                                                                                          ?

sksint_getaddrinfo_invoke                                    (sk)sint_getaddrinfo_invoke                                  operating system dependent kernel ??
xsiosecDAccess                                               (xs)iosecDAccess                                             olap analytic workspace ??
%d bloggers like this: