Message-Id: <10564.112601@fatcity.com> From: "Steve Adams" Date: Fri, 21 Jul 2000 10:42:07 +1000 Subject: 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@fatcity.com [mailto:root@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@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@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).