x$kglob -- keeping objects

From: Diego Cutrone <dcutrone_at_afip.gov.ar>
Date: Wed, 03 Oct 2001 10:44:55 -0700
Message-ID: <F001.003A0DF3.20011003110039@fatcity.com>

Hi list.My intention is to keep cursors as they are beingused, according to the SHARABLE_MEM they use, theLOADS and PARSE_COUNT.So I checked x$kglob and v$sqlarea too (just to see ifthe information there matched the first one)And my problem is that V$SQLAREA.SHARABLE_MEM (202400bytes) does not EXACTLY matchkglobhs0+kglobhs1+kglobhs2+kglobhs3+kglobhs4+kglobhs5+kglobhs6.(200000)does anyone know why? headers perhaps?

TIA
Diego Received on Wed Oct 03 2001 - 12:44:55 CDT