Performance issue can't identify

From: Connie Milliken <cemail_219_at_hotmail.com>
Date: Tue, 01 Mar 2005 14:41:14 -0500
Message-ID: <BAY2-F4145D104304F7C1BB299C9A5590@phx.gbl>

Although I fear repercussions from Mladen :), I must ask for help because I 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 running on it with a total of 1700MB being used for SGAs. The box has 4GB RAM memory. Without any OS configuration changes being made (other than kernel parms), the databases were originally installed on the server as it came “out of the box”. (Even the simplest things, such as copying large files can be slow so I am not convinced the problem is necessarily Oracle). However, does anyone see anything here that I don’t see either related to Oracle or Unix or can recommend anything else to look into? With very 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 id
0 0 3 4071688 356568 3 399 335 44 45 0 1 2 0 7 8 227 25 276 6 7 87
0 0 4 5319016 1707200 0 2 9 0 0 0 0 2 0 2 2 174 269 151 0 1 99
0 0 4 5319008 1707200 0 0 0 0 0 0 0 17 0 2 2 273 276 181 0 1 99
0 0 4 5319008 1707200 0 0 0 0 0 0 0 11 0 2 2 233 283 171 0 1 99

# swap -l

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

Oracle tunables set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=32 set semsys:seminfo_semmni=300 set semsys:seminfo_semmsl=4096 set semsys:seminfo_semmns=4096 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767
end Oracle tunables

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

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

Received on Tue Mar 01 2005 - 16:18:19 CST