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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Q: Oracle sqlplus way to capture all duplications and removal.

Re: Q: Oracle sqlplus way to capture all duplications and removal.

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Wed, 10 Sep 2003 16:47:18 -0700
Message-ID: <1063237622.483544@yasure>


ColoC wrote:

>vslabs_at_onwe.co.za (Billy Verreynne) wrote in message news:<1a75df45.0309082136.1934a3f8_at_posting.google.com>...
>
>
>>colocoloc_at_yahoo.com (ColoC) wrote i
>>
>>
>>
>>>That's politics -- maybe they are looking for some reasons to dismiss
>>>me. Who knows?
>>>
>>>
>>You should think positive. Maybe they are thinking or replacing the
>>DBA and eyeing you as a candidate. ;-)
>>
>>BTW, parallel query option is called 'PARALLEL EXECUTION' in v$option.
>>
>>
>
>Hi, thanks.
>
>As I wrote in another earlier post to this thread, I had some minutes
>before I leave. I know that we are on a 4 CPU UNIX box, I did the
>following:
>
>##################################
>
>
>>set time on
>>select count(*)
>>from tab_1
>>where one_line_condition_on_a_well_indexed_field;
>>
>>
>
>FIELD_NAME
>------------
>xxxxxx
>
>Elapsed: 00:00:22.02
>
>
>
>>select /*+ FULL(tab_1) PARALLEL(tab_1,4) */
>>count(*) from tab_1
>>where one_line_condition_on_a_well_indexed_field;
>>
>>
>
>FIELD_NAME
>------------
>xxxxxx
>
>Elapsed: 00:01:12.67
>
>##################################
>
>Should this mean that I am wrong in using the parallel query or should
>this mean that it is not well configured to be using it? Thanks.
>
>ColoC
>
>

Its not that simple. You need to test it. Sometimes it makes things slower. Not often but it can happen.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Sep 10 2003 - 18:47:18 CDT

Original text of this message

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