PROTECTED]
Subject: Query Tuning Question
Hi fellow DBAs,
This is kind of the follow-up of my last E-mail on wait event.
I have a query that is taking hours to complete and the plan looks ok. While one of
the tables is huge (267mil rows) it is being accessed using one of its indexes.
I recorded
[EMAIL PROTECTED]
Date: 2003/06/12 Thu PM 03:54:59 EDT
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Subject: Query Tuning Question
Hi fellow DBAs,
This is kind of the follow-up of my last E-mail on
wait event.
I have a query that is taking hours to complete
Title: RE: Query Tuning Question - new discovery
A Ha ...
it is refers to _B_TREE_BITMAP_PLANS variable ... it is true by default and what you see is the side effect. If you are not using BMI, set it to false.
http://tinyurl.com/e8ws for more info
Raj
Hi
fellow DBAs,
This
is kind of the follow-up of my last E-mail on wait event.
I have
a query that is taking hours to complete and the plan looks ok. While one of the
tables is huge (267mil rows) it is being accessed using one of its
indexes.
I
recorded some stats from v$session_wait
PROTECTED]
Date: 2003/06/12 Thu PM 03:54:59 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Query Tuning Question
Hi fellow DBAs,
This is kind of the follow-up of my last E-mail on wait event.
I have a query that is taking hours to complete and the plan looks ok. While
What could be the cause of this wait?
At the risk of asking the bleeding obvious, have you tried doing a 10046
trace on the query?
Gudmundur
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gudmundur Bjarni Josepsson
INET: [EMAIL PROTECTED]
Fat City Network Services