Re: memory problem - oracle 10203 on HPUX
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-lReceived on Mon Jan 21 2008 - 21:56:10 CST