Quick note to self, and many thanks to Tanel Poder for sharing this with me.

I always wanted to know what an Oracle kernel function roughly implies. The Oracle 8i Internals for waits, latches, locks and memory book has a beautiful chart listing all the kernel layers with their "initials" but now I've got something much better!

Check out the following Metalink note "ORA-600 Lookup Error Categories [ID 175982.1] ", especially the "Internal Errors Categorised by mnemonic" part. It has a lot of detail such as the error mnemonic(s), functionality and description.

For instance, in a previous post I had a problem with an ORA-07445 in kkpapItGetAll() plus an offset. Using the Metalink note, that translates into the following information:

Wow, had I known that earlier! The core dump happens when accessing a partitioned table with a multi column in list query if memory serves me right.

Hope that helps!