RE: oracle handing memory allocation different between 11g and 12c?

From: Stefan Koehler <contact_at_soocs.de>
Date: Tue, 16 Feb 2016 21:14:58 +0100 (CET)
Message-ID: <613498862.29552.1455653698464.JavaMail.open-xchange_at_app03.ox.hosteurope.de>



Hi Matt,
for sure - here we go. This is my Oracle RDBMS lab.  

root_at_SOL:~# pkg info kernel

          Name: system/kernel
       Summary: Core Kernel
   Description: Core operating system kernel, device drivers and other modules.
      Category: System/Core
         State: Installed
     Publisher: solaris
       Version: 0.5.11
 Build Release: 5.11
        Branch: 0.175.2.0.0.42.2
Packaging Date: June 24, 2014 06:55:42 PM 
          Size: 33.62 MB
          FMRI: pkg://solaris/system/kernel_at_0.5.11,5.11-0.175.2.0.0.42.2:20140624T185542Z


However please DTrace the corresponding SHM function calls for OSM in your env.

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK

> Matt Adams <MAdams_at_TroverSolutions.com> hat am 16. Februar 2016 um 19:37 geschrieben:
>
> Stefan,
> Can you tell me which version and release of Solaris you are using?
>
> Matt
>
> -----Original Message-----
> From: Stefan Koehler [mailto:contact_at_soocs.de]
> Sent: Tuesday, February 16, 2016 12:07 PM
> To: Matt Adams
> Cc: oracle-l_at_freelists.org
> Subject: RE: oracle handing memory allocation different between 11g and 12c?
>
> Hi Matt,
> not quite sure what's wrong in your env. OSM and 12.1.0.2 works like a charm here :)
>
> root_at_SOL:~# pmap -xs 1827
> 1827: ora_smon_S12DB
> Address Kbytes RSS Anon Locked Pgsz Mode Mapped File
> …
> 0000000060000000 4096 4096 - 4096 2M rwxs- [ osm shmid=0x5000009 ]
> 0000000080000000 98304 98304 - 98304 - r-xs- [ osm shmid=0x500000a ]
> 00000000C0000000 3981312 3981312 - 3981312 2M rwxs- [ osm shmid=0x500000b ]
> 00000001C0000000 14336 14336 - 14336 2M rwxs- [ osm shmid=0x500000c ]
> …
>
> Please DTrace the corresponding syscalls to get a better insight in your case.
>
> root_at_SOL:~# dtrace -l
> ID PROVIDER MODULE FUNCTION NAME
> …
> 256 syscall memcntl entry
> 257 syscall memcntl return
> 20833 fbt genunix memcntl entry
> 20834 fbt genunix memcntl return
> 78362 fbt shmsys shmget_osm entry
> 78363 fbt shmsys shmget_osm return
> 78364 fbt shmsys shmget entry
> 78365 fbt shmsys shmget return
> …
>
> Best Regards
> Stefan Koehler
>
> Freelance Oracle performance consultant and researcher
> Homepage: http://www.soocs.de
> Twitter: _at_OracleSK

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 16 2016 - 21:14:58 CET

Original text of this message