FreeLists / oracle-l / RE: Performance issue can't identify

["Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Connie Milliken
Sent: Tuesday, March 01, 2005 12:41 PM
To: oracle-l@xxxxxxxxxxxxx
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