Memory Leak During Parsing
Memory leak during parsing in Oracle 12c Continue Reading
slow parsing
Large TCHK Allocations in Shared Pool
Large TCHK allocations in shared pool caused by create table as select Continue Reading
Large Memory Allocations due to Query Parsing
Troubleshooting high PGA memory allocations which escalated in ORA-04036 error. High memory consuption was related to a parsing problem. Continue Reading
Excessive query parsing time with extended statistics and long in-lists
Excessive query parsing time with extended events and long in lists were observed on a 12c database. As a workaround set the undocumented parameter _optimizer_extended_stats_usage_control to 224. Continue Reading