RE: Direct SGA access problem because of structs' changing start address

From: Sigrid Keydana <keydana_at_gmx.de>
Date: Thu, 9 Jan 2014 18:26:16 +0100 (CET)
Message-ID: <trinity-cd05a0ec-e953-4120-91e2-51586fb7b4ab-1389288375975_at_3capp-gmx-bs31>

Hi Jonathan, hi all,
 
thanks a lot for the explanations!
 
Actually, the kind of information I was thinking to extract was something like Tanel does in his ksmsp.sql (http://blog.tanelpoder.com/files/scripts/ksmsp.sql - I was trying to cite something from Metalink here, but didn’t find anything so nice, so I hope it’s ok with him I cite his script here ;-)),  - aggregating memory usage, e.g.,  by subheap, comment type, class…

 
 
   SUBPOOL SGA_HEAP    STATUS   CHUNKCOMMENT     SIZE    COUNT(*)      SUM(BYTES)   MINBYTES   MAXBYTES   AVGBYTES


---------- ---------------------------------------------------- -------- ---------------- ----- ---------- ---------- ---------- ---------- ----------

  1 sga heap(1,0)      freeabl    SQLA^              4-5K        5604            22954016       4096        4128       4096
  1 sga heap(1,0)      freeabl    SQLP^              4-5K          78              326144           4096        4224       4181
  1 sga heap(1,0)      recr       SQLA^              4-5K        1080             4423680       4096        4096       4096
  1 sga heap(1,0)      recr       SQLK^              4-5K           5               20480             4096        4096       4096
  1 sga heap(1,0)      recr       SQLP^              4-5K          26              106496           4096        4096       4096

 
 
…  but for that , then , I do not want to read the actual chunks from the shared pool, which I should be able to successfully access from the ksmchptr, but the content from x$ksmsp itself, and that will not work as I do not have a session – correct? So I should think about something different which might be useful to do, direct-SGA-access-wise…  
As for Oracle Core, it’s a fantastic book and I think I have read the shared pool part 2 times already, but still, the topic is not easy to grasp and I will surely read it again several times still J  
Thanks again
Sigrid
 
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 09 2014 - 18:26:16 CET