Hi all, When querying the view X$KSMSP can anyone tell me whether memory chunks with a value in KSMCHCLS of 'freeabl' can be used immediately. We currently have an application running against our database which is causing the ORA-4031 error. The app does not make use of shared sql and after flushing the shared pool within a few minutes the shared pool summary looks like this: CONTENTS CHUNKS RECREATABLE FREEABLE TOTAL ---------------- --------- ----------- --------- --------- KGFF heap 9 1336 4564 5900 KGK contexts 2 2376 2376 KGK heap 3 16996 560 17556 KGL handles 11305 2050328 2050328 KQLS heap 80 35360 45368 80728 LISTEN ADDRESS 2 1188 1188 PLS cca hp desc 1 164 164 PLS non-lib hp 1 2096 2096 character set m 6 31196 31196 dictionary cach 87 127776 127776 fixed allocatio 20 640 640 free memory 5126 1736532 joxs heap 1 92 92 kzull 28 1456 1456 library cache 11695 1131164 4434300 5565464 listener addres 1 16 16 permanent memor 8 5829368 row cache lru 23 1012 1012 session param v 26 93288 93288 sql area 20517 842020 11812896 12654916 table columns 18 15736 15736 In a few minutes the sql area has risen from 200 chunks to 20517. It appears that approx 12Mb of chunks associated to slq area are freeable, so are these chunks usable in which case the error must be caused by the size of the available chunks? Many thanks for any replies, Dave Leach ********************************************************************** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ********************************************************************** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
