Kirti,
I've been searching on the IBM site for aiostat without much luck. What kind
of information does it give you? (if I'm going to convince my SA to call IBM
about this I'll need a very good argument. I'm still working on getting the
rights to use sar).
Henry
-Original Message-
Kirti
Henry,
I got aiostat from IBM Support when I bugged them about how to monitor AIO. Not sure
if aiostat is readily available as a download from their Web site or in/for the newer
versions of AIX.
It works similar to vmstat and iostat, showing number of pending AIO requests at the
time of
Kirti,
Just took another look at our kproc processes. What is weird is that we have
26 of them, 9 are owned by oracle the rest are root (huh?). All of them
started at system boot. Also, almost all of the CPU is used by the top four
(current %CPU and total over the life of the process) with the
Title: Hanging query puzzle
We have a query from a 3rd-party tool that seems to either run very quick or crawls to a complete stop.
We can find no patterns to this behavior. The hang can be experienced even when there are no other
processes active in the database. Checking waits, we see
What version
are you running - I have a similar problem on 9.2.0.2 on Solaris 9 that I've had
an open tar on since November - Support has finally called up and said other
people are having the same kind of problem - especially in regards to parallel
processes. I am supposedly getting a test
Sorry, running 8.1.7.2 on AIX
4.3.3.
-Original
Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05,
2003 2:09 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: Hanging query puzzleWhat version
are you running - I have a similar problem on 9.2.0.2
What is the value for WAIT_TIME ? This may not be an IO problem
if 'WAIT_TIME' is not 0. A session is waiting only when 'WAIT_TIME' is 0. I
would suggest running some utility like tusc (HP), truss (Sun), strace (Linux)
and check it from the OS side. Since this is a third party tool, it
Title: RE: Hanging query puzzle
Still sitting there, while we try to figure out exactly why it's waiting.
SID Username EVENT WAIT_TIME STATE SECONDS_IN_WAIT
- -- -- --- ---
1 pmon
Koovakattu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 2:58 PM
To: [EMAIL PROTECTED]
Cc: Thomas Jeff
Subject: Re: Hanging query puzzle
What is the value for WAIT_TIME ? This may not be an IO problem
if 'WAIT_TIME' is not 0. A session is waiting only when 'WAIT_TIME
Just a warning for the future - this is no longer true
on all versions of Oracle 9 because the wait_time
column is a copy of the underlying x$ timing
column rounded from microseconds to hundredths.
Hence the wait_time can show a zero when the
actual time is non-zero.
You should depend only on
It looks like your process really is stuck
in a way that has nothing to do with the
Oracle code directly.
You might look at the CPU usage of your
session and its shadow using an O/S
utility, but I suspect it would show
zero CPU. Perhaps truss (or the AIX
equivalent) might show your process
Thanks. Didn't know that. See you in Dallas next Sunday ;)
Regards,
Denny
Quoting Jonathan Lewis [EMAIL PROTECTED]:
Just a warning for the future - this is no longer true
on all versions of Oracle 9 because the wait_time
column is a copy of the underlying x$ timing
column rounded from
Title: RE: Hanging query puzzle
Jonathan, Charlie, Denny: Thanks for the replies. Our SA's claim that there's
nothing wrong with the EMC SAN/disk. Finally, made them give me errpt access (they
had shut off execute privs from all but them) and got a lot of output like below.
The SAs
Jeff,
If you see the SEQ# field in the v$session_wait view not incrementing, then something
else, other than Oracle, is causing a hang up...
On AIX, if you have AIO enabled, try running 'aiostat'. It will show if there are any
pending AIO requests. The difficult part would be to relate those
14 matches
Mail list logo
