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 Received on Thu Jul 20 2000 - 06:28:04 CDT