Freeable memory Chunks

From: Dave Leach <Dave.Leach_at_claybrook.co.uk>
Date: Wed, 22 Aug 2001 06:54:26 -0700
Message-ID: <F001.00373C44.20010822061121@fatcity.com>

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: Dave.Leach_at_claybrook.co.uk

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: ListGuru_at_fatcity.com (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). Received on Wed Aug 22 2001 - 08:54:26 CDT