-Original Message-
Sent: Tuesday, July 24, 2001 1:22 PM
To: Multiple recipients of list ORACLE-L
Gene:
It all depends on a couple of factors: (1) what are the average
wait times for each of the wait events, (2) which one(s) have
the highest wait times. I would ignore any waits less
Hi all:
I am trying to tune some queries. I ran them all in
one stream (in sequence) and then ran them in several
(up to 64) parallel streams. I got a snapshot of
the system for each run. I see some of the waits went
up significantly when I switched from 2 parallel
streams to 64: buffer busy
To: Multiple recipients of list ORACLE-L
Subject: what do I tune?
Hi all:
I am trying to tune some queries. I ran them all in
one stream (in sequence) and then ran them in several
(up to 64) parallel streams. I got a snapshot of
the system for each run. I see some of the waits went
up
Gene:
It all depends on a couple of factors: (1) what are the average
wait times for each of the wait events, (2) which one(s) have
the highest wait times. I would ignore any waits less than 1
centisecond for the most part.
Buffer Busy Waits occur when a session is waiting for a buffer
to
Hi,
itrprof SQL Analyzer can do what you asked.
itrprof: http://www.unal-bilisim.com/products/itrprof/itrprof.html
24/7/01 06:56:29, Gene Gurevich [EMAIL PROTECTED] wrote:
Hi all:
I am trying to tune some queries. I ran them all in
one stream (in sequence) and then ran them in several
(up to