sga attach linux hugemem /proc/#/maps
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: "'Oracle-L'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Sep 2008 11:12:17 -0400
cat /etc/redhat-release
Red Hat Enterprise Linux ES release 4 (Nahant Update 4)
Uname -a
Linux xxxxxxx01 2.6.9-67.0.7.ELhugemem #1 SMP Wed Feb 27 04:59:22 EST 2008
i686 athlon i386 GNU/Linux
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Sep 25 10:59:54 2008
Due to a corporate reorg I'm helping out a group that used to have 3 dba's
and is now down to one. No documentation/build books to check out. The
developers have asked me to look at a problem. I've thinked they've side
tracked me because I don't have access to their metalink CSI# yet and
haven't been able to check out their tar. They've asked me to verify the SGA
is attached properly because they set up hugemem.
I've been following note #211424.1 and it looks like it's o.k.
That note led me to note #270382.1
This article will assist you on verify the current SGA attach address
b. If an instance is running, check it's attach address:
i. Get the pid of its PMON process. For example:
$ ps -ef | grep ora_pmon_EMR920W3
emrdbms 20355 1 0 01:28 ? 00:00:00 ora_pmon_EMR920W3
ii. Now check the map address of the SysV shared memory segment using
the pid of the PMON process found above:
$ grep deleted /proc/20355/maps
50000000-50400000 rw-s 00000000 00:04 156663874 /SYSV00000000
(deleted)
(...)
Again, the first number (50000000) shows the hex address where
the SGA will be attached.
I get multiple entries. I've checked other databases on other servers
running both the same redhat version and I only get one entry. This database
does have multiple _pool_size parameter set and I just now noticed that they
must have alter system privs and are changing things on the fly. This has
now officially moved to not my responsibility but anyways can anyone explain
why there are multiple entries in /proc/#/maps. The server was rebooted
yesterday.
grep delete /proc/6371/maps
12000000-1f200000 rw-s 00000000 00:06 622597 /SYSV8695b0a8 (deleted)
20000000-21000000 rw-s 00000000 00:06 65536 /SYSV00000000 (deleted)
21000000-8e000000 rw-s 00000000 00:06 196609 /SYSV00000000 (deleted)
8e000000-c5000000 rw-s 00000000 00:06 327682 /SYSV00000000 (deleted)
c5000000-e0000000 rw-s 00000000 00:06 458755 /SYSV00000000 (deleted)
e0000000-ee000000 rw-s 00000000 00:06 589828 /SYSV00000000 (deleted)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
