Oracle Kernel: Function kglic & Library Cache Latch

Oracle Kernel: Function kglic & Library Cache Latch if you have encountered such problems, you can refer to this article.

The following is a brief description of the functions of the KGLIC function:

The Code is as follows:

Copy code

1. kglic means Kernel Generic Library cache Iterate Chain (AFAIK), it's the function which is executed when you access most X $ KGL tables. 2. kglic is the code which goes through the library cache and row cache to answer queries on various dictionary fixed views and tables. this is the function which returns data for the fixed views and tables that scan the SQL area. therefore, it was highly possible that such queries cocould also be coming from monitoring tools used by DBAs and they are not restricted to the two views specifically mentioned in the bug by Joan. any monitoring job which looks at v $ open_cursor wocould also use the kglic iterator.

The related BUG still exists in 10 Gb. Finally, it is confirmed that the customer has frequent queries to access the v $ SQL view, resulting in severe library cache competition.

The affected versions of the following bugs are 10.2.0.4, 10.2.0.5, and 11.2.0.2:

The Code is as follows:	Copy code
Bug 9287616-Accessing [G] V $ SQL or [G] V $ SQLTEXT_WITH_NEWLINES may be slow/takes a long time/latch contention (Doc ID 9287616.8)