Message-Id: <10564.112519@fatcity.com> From: Rahul Date: Thu, 20 Jul 2000 18:28:04 +0700 Subject: V$SQL_SAHRED_MEMORY, CHUNK_PTR & KSMCHPTR x$ksmsp has a row for each chunk of memory v$sql_shared_memory has a column CHUNK_PTR but when i try this.. i get 0 (zero) select count(*) from V_$SQL_SHARED_MEMORY A,x$ksmsp b where a.chunk_ptr = b.KSMCHPTR; 1) why no chunk in v$sql_shared_memory matches the KSMCHPTR ?? 2) first time i ran the sql it gave me ora 4030 out of process memory when trying to allocate 52 bytes(cursor works he,x$ksmsp).. any idea ? TIA