RE: Performance issue can't identify

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Tue, 1 Mar 2005 14:01:48 -0800
Message-ID: <960A9B249C99994AA3C7FCA016A0DA89CB79F2@ussccem08.corp.hds.com>

Connie,

> 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:

>From the vmstat output below, it seems that at least 3 to 4 processes are in
the 'w' column, which is basically 'runnable but swapped' state. You could cross-verify this using the 'sar -q' command....

If this is the case, then you should reduce the memory requirements - both in the SGA as well as Sort_area_size etc that relates to individual processes as well as "pga_" parameters if you are using them (since you mention 9.2.x).

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

Hth,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 01 2005 - 17:05:04 CST