Performance issue can't identify
- From: "Connie Milliken" <cemail_219@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 01 Mar 2005 14:41:14 -0500
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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
