Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> [Fwd: more on 'high cpu...']

[Fwd: more on 'high cpu...']

From: Joe Armstrong-Champ <joseph.armstrong-champ_at_tufts.edu>
Date: Mon, 02 Jul 2007 12:27:03 -0400
Message-ID: <46892757.6070101@tufts.edu>


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.

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 Received on Mon Jul 02 2007 - 11:27:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US