We are using version 19.1.0 of Oracle Exadata. We are seeing, queries failing intermittently(failed twice till now) with below error. Then looking into DBA_HISt_SGASTAt, we see the shared pool componenet "init_heap_kfsg" is consuming significant space i.e. currently consuming ~30GB. We have sga_target set as ~45GB, sga_max_size - 50GB and shared_pool_size set as 8GB. But when the query failed with Ora- 04031 , the "init_heap_kfsg" component has not gone beyond ~30GB.
So wondering , if its related to below bug( DOC id- 2151847.1), but again the bug says its fixed on 12.2, so with that perspective we should not hit that bug on current version i.e. 19.1. So anybody has hit similar issue and any possible fix for same ?
ORA-04031: unable to allocate 56 bytes of shared memory ("shared pool","unknown object","KKSSP^654","kglseshtSegs")
Oracle Doc:-
ORA-04031: ("shared Pool".."KKSSP^nnnn","kglseshtSegs") (Doc ID 2151847.1)