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