RE: Performance issue can't identify

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Tue, 1 Mar 2005 14:20:15 -0700
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B439380@fiji.arraybp.com>

What are your specific Oracle performance issues? A snapshot of vmstat = is not really telling us anything.

Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Connie Milliken Sent: Tuesday, March 01, 2005 12:41 PM
To: oracle-l_at_freelists.org
Subject: Performance issue can't identify

Although I fear repercussions from Mladen :), I must ask for help = because I=20
am at my wit's end with this and really need some help......

I inherited a SunOS 5.8 Solaris 64-bit that has 3 Oracle 9.2.0.5 = databases=20
running on it with a total of 1700MB being used for SGAs. The box has = 4GB=20
RAM memory. Without any OS configuration changes being made (other = than=20
kernel parms), the databases were originally installed on the server as = it=20
came "out of the box". (Even the simplest things, such as copying = large=20
files can be slow so I am not convinced the problem is necessarily = Oracle). =20
However, does anyone see anything here that I don't see either related = to=20
Oracle or Unix or can recommend anything else to look into? With very=20 little running on any of the databases, this is what it looks like:

oracle:/etc > vmstat 5 4
procs memory page disk faults = cpu
r b w swap free re mf pi po fr de sr s0 s1 s2 s3 in sy cs us = sy=20
id
0 0 3 4071688 356568 3 399 335 44 45 0 1 2 0 7 8 227 25 276 6 = 7=20
87
0 0 4 5319016 1707200 0 2 9 0 0 0 0 2 0 2 2 174 269 151 0 = 1=20
99
0 0 4 5319008 1707200 0 0 0 0 0 0 0 17 0 2 2 273 276 181 0 = 1=20
99
0 0 4 5319008 1707200 0 0 0 0 0 0 0 11 0 2 2 233 283 171 0 = 1=20
99

# swap -l

swapfile             dev   swaplo  blocks     free
/dev/dsk/c0t0d0s1   32,1      16   8395184   8058320

Oracle tunables set shmsys:shminfo_shmmax=3D4294967295 set shmsys:shminfo_shmmin=3D1 set shmsys:shminfo_shmmni=3D100 set shmsys:shminfo_shmseg=3D32 set semsys:seminfo_semmni=3D300 set semsys:seminfo_semmsl=3D4096 set semsys:seminfo_semmns=3D4096 set semsys:seminfo_semopm=3D100 set semsys:seminfo_semvmx=3D32767
end Oracle tunables

FREE pop-up blocking with the new MSN Toolbar - get it now!=20 http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender  of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 01 2005 - 16:25:40 CST