RE: Performance issue can't identify
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <cemail_219@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 1 Mar 2005 14:20:15 -0700
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/
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
