Re: memory problem - oracle 10203 on HPUX

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Tue, 22 Jan 2008 10:56:10 +0700
Message-ID: <3edcb66e0801211956l359e28faq82b45ef0dc4a14ec@mail.gmail.com>


hi,

according to pmap (pmap for hpux.... is it precission tool??) it seem that for one server process, it only takes 4MB.... am I correct?

$ ps -ef | grep LOCAL=NO
............

oracle   11307     1  2 10:50:29 ?           00:00 oracleOPEAICX1 (LOCAL=NO)
oracle   11525     1  0 10:50:37 ?           00:00 oracleOPEAICX1 (LOCAL=NO)
oracle    6787     1  0 10:47:43 ?           00:00 oracleOPEAICX1 (LOCAL=NO)

$ ./pmap-0-0-hpux-parisc 11307
00000000      4K read/exec       shrd            [null]
c008f000      4K read            shrd            /var/spool/pwgr/status
00000000 114688K read/exec       exec shrd       [text]
ffff0000     32K read/write                      [user]
00000000   4096K read/write                      [data]
00000000   1024K read/write                      [mmap-file]
40000000   1024K read/write                      [mmap-file]
80000000    640K read/write                      [mmap-file]
c0000000      8K read/write/exec                 [mmap-file]
00000000      4K read/write      shlib           /usr/lib/pa20_64/libnss_files.1
40000000      4K read/write      shlib           /usr/lib/pa20_64/libnss_nis.1
80000000    512K read/write                      [mmap-file]
c0000000     16K read/write/exec                 [mmap-file]
00000000     16K read/write/exec                 [mmap-file]
40000000      8K read/write/exec                 [mmap-file]
80000000     12K read/write      shlib
/opt/star-ncf-prod/ep_patch/usr/lib/pa20_64/libxti.2
c0000000      8K read/write/exec                 [mmap-file]
ffff1000     60K read/write      shlib           /usr/lib/pa20_64/libc.2
00000000     52K read/write                      [mmap-file]
40000000     12K read/write      shlib           /usr/lib/pa20_64/libm.2
7fff5000     44K read/write      shlib           /usr/lib/pa20_64/libnsl.1
80000000     28K read/write                      [mmap-file]
c0000000      8K read/write/exec                 [mmap-file]
00000000      4K read/write      shlib           /usr/lib/pa20_64/libdl.1
3ffff000      4K read/write      shlib           /usr/lib/pa20_64/libnss_dns.1
40000000      4K read/write                      [mmap-file]
7fffd000     12K read/write      shlib           /usr/lib/pa20_64/libpthread.1
80000000      8K read/write                      [mmap-file]
c0000000      4K read/write      shlib           /usr/lib/pa20_64/librt.2
00000000      8K read/write/exec                 [mmap-file]
3ff9f000    388K read/write      shlib           /usr/lib/pa20_64/libcl.2
40000000     52K read/write                      [mmap-file]
7ffc1000    252K read/write      shlib
/apps/oracle/product/10.2/lib/libnnz10.sl
80000000      8K read/write                      [mmap-file]
c0000000    780K read/write      shlib
/apps/oracle/product/10.2/lib/libjox10.sl
00000000      4K read/write      shlib
/apps/oracle/product/10.2/lib/libdbcfg10.sl
40000000      8K read/write/exec                 [mmap-file]
80000000      4K read/write      shlib
/apps/oracle/product/10.2/lib/libclsra10.sl
c0000000      4K read/write      shlib
/apps/oracle/product/10.2/lib/libocrutl10.sl
00000000      8K read/write      shlib
/apps/oracle/product/10.2/lib/libocrb10.sl
40000000      8K read/write      shlib
/apps/oracle/product/10.2/lib/libocr10.sl
80000000      8K read/write/exec                 [mmap-file]
c0000000      4K read/write      shlib
/apps/oracle/product/10.2/lib/libskgxn2.sl
00000000     24K read/write      shlib
/apps/oracle/product/10.2/lib/libhasgen10.sl
40000000      8K read/write/exec                 [mmap-file]
7fffb000     20K read/write      shlib           /usr/lib/pa20_64/dld.sl
80000000      4K read/write      shlib           [mmap-file]
bfff0000    576K read/write                      [stack]
00000000    256K exec            exec shrd shlib /usr/lib/pa20_64/dld.sl
000ad000     12K read/exec       exec shrd shlib /usr/lib/pa20_64/libdl.1
000bc000      8K read/exec       exec shrd shlib /apps/oracle/product/10.2/lib/l
0010c000     20K read/exec       exec shrd shlib /usr/lib/pa20_64/librt.2
00114000     24K read/exec       exec shrd shlib /usr/lib/pa20_64/libnss_dns.1
00120000    100K read/exec       exec shrd shlib /usr/lib/pa20_64/libpthread.1
001f4000     28K read/exec       exec shrd shlib /usr/lib/pa20_64/libnss_nis.1
00200000   1200K read/exec       exec shrd shlib /usr/lib/pa20_64/libcl.2
0032c000     36K read/exec       exec shrd shlib /usr/lib/pa20_64/libnss_files.1
00340000    520K read/exec       exec shrd shlib /usr/lib/pa20_64/libnsl.1
003c4000     40K read/exec       exec shrd shlib /apps/oracle/product/10.2/lib/l
003d0000    152K read/exec       exec shrd shlib /usr/lib/pa20_64/libm.2
00610000     92K read/exec       exec shrd shlib /opt/star-ncf-prod/ep_patch/usr
00640000    716K read/exec       exec shrd shlib /apps/oracle/product/10.2/lib/l
006f4000     36K read/exec       exec shrd shlib /apps/oracle/product/10.2/lib/l
00700000   1144K read/exec       exec shrd shlib /usr/lib/pa20_64/libc.2
00820000     76K read/exec       exec shrd shlib /apps/oracle/product/10.2/lib/l
00840000    436K read/exec       exec shrd shlib /apps/oracle/product/10.2/lib/l
00b40000    304K read/exec       exec shrd shlib /apps/oracle/product/10.2/lib/l
00c00000   2252K read/exec       exec shrd shlib /apps/oracle/product/10.2/lib/l
04400000   9428K read/exec       exec shrd shlib /apps/oracle/product/10.2/lib/l
40000000 13647900K read/write/exec shrd            [shared]

regards
ujang

On Jan 21, 2008 4:01 PM, Ujang Jaenudin <ujang.jaenudin_at_gmail.com> wrote:
> hi,
>
> I got the memory report from glance and grid control host performance report.
> from those tools indicate the same number.
>
> looking fsflush for hp-ux.....
>
> regards
> ujang
>
>
> On Jan 21, 2008 2:17 PM, vnr1995 <vnr1995_at_gmail.com> wrote:
> > If this is a fresh installation, and if you have faced this problem
> > right away after being brought into production, I have few questions:
> >
> > How did you know that the OS is using 80 to 90 percent of the memory
> > is being used? Many commands dealing memory management are misleading:
> > for instance, prstat on solaris is downright misleading; tuning based
> > on prstat is downright suicidal. I don't know about hpux; on solaris,
> > one can get memory usage by interacting with kernel debugger, smth
> > like
> > echo "::memstat" | mdb -k
> >
> > There is another thing you need to look at: how frequently fsflush
> > daemon is being run? There is a kernel parameter (in solaris) that
> > dictates this frequency: autoup. Given you got 38 GB memory, try to
> > run the fsflush daemon less often, so that the paging activity gets
> > reduced.
> >
> >
> >
> >
> >
> >
> > On Jan 19, 2008 7:36 PM, Ujang Jaenudin <ujang.jaenudin_at_gmail.com> wrote:
> > > folks,
> > >
> > > I have a machine (RAC configuration) 10.2.0.4 on HPUX - PARISC.
> > > in a node I have 38GB physical memory, 8 processors.
> > > the machine could not run with asynchronous IO, so I set io slave to
> > > 8, and dbwr to 1.
> >
>
>
>
>
> --
> regards
> ujang
>
> "I believe that exchange rate volatility is a major threat to
> prosperity in the world today"
> Dr. Robert A. Mundell, Nobel Laureate 1999
>

-- 
regards
ujang

"I believe that exchange rate volatility is a major threat to
prosperity in the world today"
Dr. Robert A. Mundell, Nobel Laureate 1999
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 21 2008 - 21:56:10 CST

Original text of this message