RE: V$SQL_SAHRED_MEMORY, CHUNK_PTR & KSMCHPTR

Hi Rahul,

I submitted a bug against 8.0.5 about this on 14-JAN-1999. I don't know the bug number, and I'm not sure of the status, but Support should be able to help you with that. The problem is that X$KSMSP is constructed dynamically in the PGA when queried
but the pointer offsets are not corrected.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rahul Sent: Thursday, 20 July 2000 22:37
To: Multiple recipients of list ORACLE-L 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 Rahul

--
Author: Rahul
  INET: rahul_at_ratelindo.co.id

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).