|
[oracle-l]
||
[Date Prev]
[07-2007 Date Index]
[Date Next]
||
[Thread Prev]
[07-2007 Thread Index]
[Thread Next]
[Fwd: more on 'high cpu...']
- From: Joe Armstrong-Champ <joseph.armstrong-champ@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 02 Jul 2007 12:27:03 -0400
Let me rephrase. I know that distincts can cause a lot of sorting which
in turn can cause high cpu. I guess I'm wondering if there is any work
around for this? I'm searching for problems on distincts on metalink but
other than old bugs I'm not coming up with much.
-------- Original Message --------
Subject: more on 'high cpu...'
Date: Mon, 02 Jul 2007 11:34:33 -0400
From: Joe Armstrong-Champ <joseph.armstrong-champ@xxxxxxxxx>
Organization: Tufts University
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
I'm still doing the traces but in the meantime I thought I'd ask a
follow up question. The query is selecting from a view. The view returns
hundreds of rows relatively quickly. The query itself is selecting
DISTINCT rows from the view. When I take out the distinct it returns
almost instantaneously. With the distinct in it takes 40 - 50 secs. Does
this ring a bell with anyone?
--
http://www.freelists.org/webpage/oracle-l
|
