Re: ORA-4031 "shared pool","unknown object","sga heap(6,1)","KTI SGA freea"

From: Gaja Krishna Vaidyanatha <>
Date: Sat, 22 Mar 2014 02:35:05 -0700 (PDT)
Message-ID: <>

Hi Greg,

For the specific issue that you have written about, Mark as guided you in the right direction. Nevertheless, I am wondering whether you are experiencing ORA-4031s for specific operations or is it random. 

We battled with an issue specific to DDL operations especially on INTERVAL-PARTITIONED tables. If you are getting ORA-4031s for that, you should probably look into:

-- Bug#16864042 -- Unnecessary library cache operations on for DDLs on Exadata

Even though the text says Exadata, it is Generic and applicable across all platforms. We have run into this issue even on non-Exadata databases. We had to deal with this and a slew of issues with the shared pool on with excessive consumption on KQRLPO/KQRXPO/KGLH0/SQLA/PRTMV. Even after patching with #13814739 we had no choice but to go to as the issue was not resolved in Our biggest problem was that regardless of how much free memory there was in the shared pool (in total), there was significant cluttering and zero-aging of DDLs in the first "sub-pool". When the first sub-pool ran out of free memory, the ORA-4031s started to pop up at an incredible frequency. Hope this helps.



Gaja Krishna Vaidyanatha,

CEO & Founder, DBPerfMan LLC

Phone - +1 (650) 743-6060
LinkedIn -

Co-author: Oracle Insights:Tales of the Oak Table -
Primary Author: Oracle Performance Tuning 101 -
Enabling Exadata, Big Data and Cloud Deployment & Management for Oracle

 From: "Powell, Mark" <>
To: "" <> 
Sent: Tuesday, March 18, 2014 3:56 AM
Subject: RE: ORA-4031 "shared pool","unknown object","sga heap(6,1)","KTI SGA freea"

Have you looked at ORA-600 [kti_freeing_non_freeable] And ORA-4031 On Shared Pool (Doc ID 1457819.1) ?

-----Original Message-----
From: [] On Behalf Of GG
Sent: Monday, March 17, 2014 2:46 PM
Subject: ORA-4031 "shared pool","unknown object","sga heap(6,1)","KTI SGA freea"

  Anyone has an idea what is the 'KTI SGA freea' allocation all about ?
We've experienced ora-4031 related to this on with latest PSU applied .
So far, no idea . KGLH0 allocations sizes as well as SQLA was not an issue this time :).



Received on Sat Mar 22 2014 - 10:35:05 CET

Original text of this message