Jack,
Surprisingly, vmstat provides some idea of OS Waits - look under the 'procs
- r b w' columns (running, blocked, swapped).
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
Want to know about a carpenter who built a bridge with two sticks and three
nails? Write me for
kthr memory page faultscpu
- --- ---
r b avm fre re pi po fr sr cy in sy cs us sy id wa
0 4 754461 3196 0 15 12 299 242 0 596 448 294 53 17 99 32
0 2 754461 3195 0 0
and statements above are entirely my own and not those of my
employer or clients **
-Original Message-
From: Post, Ethan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 11:18 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: IO wait
kthr memory page
Jack,
TOP adds %wio and %idle together.
Use 'sar -u' instead.
Jared
Jack Silvey [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/23/2002 08:58 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:IO
and not those of my
employer or clients **
-Original Message-
From: Post, Ethan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 11:18 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: IO wait
kthr memory page faultscpu
interestingly... the b column of *my* AIX also shows 2 continiously
!
kthr memory page faultscpu
- --- ---
r b avm fre re pi po fr sr cy in sy cs us sy id wa
0 2 200034 3088 0
On 2002.07.25 00:28 Rahul wrote:
interestingly... the b column of *my* AIX also shows 2
continiously
!
kthr memory page faultscpu
- --- ---
r b avm fre re pi po fr sr cy in
Have you considered trying StorageXpert from Quest?
- Kirti
-Original Message-
Sent: Tuesday, July 23, 2002 10:58 AM
To: Multiple recipients of list ORACLE-L
All,
We are tuning a new vital process on our data
warehouse, and it is IO intensive - lots of parallel
direct reads and
Jack,
You can run 'iostat -x 5 5' to see which disk are being used.
In this example, the arguments state 5 sec increments, 5 times. This
output may show a need to spread your data amongst your disk differently.
-reggie
-Original Message-
From: Jack Silvey [mailto:[EMAIL PROTECTED]]
Jack - Is your load process CPU-bound (high CPU utilization), or I/O-bound
(high I/O statistics)? My guess is that from waits you want to confirm that
I/O is your high wait statistic, to rule out any other problems that may be
slowing down your load time. Then you may want to make a list of ideas
Hi Jack,
questions:
1) is top a valid measure of IO wait?
In my opinion sar is a better tool to look at IO waits. sar -d and sar
-b will give you information on how the disk activity and I/O is.
2) Is a high io wait an issue to be concerned about?
Here is a nice note from Dave Miller
Top is a I/O good indicator, but too broad. You need to start with the SQL, both
logical and physical (sequential and scattered reads).
Always use histograms, this can do great things with minimal effort. With OLTP, there
is parsing cost component you need to consider. With DW, this is a
12 matches
Mail list logo
