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

From: ColoC <colocoloc_at_yahoo.com>
Date: 10 Sep 2003 10:21:41 -0700
Message-ID: <96fc2618.0309100921.2057cc48@posting.google.com>

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 Received on Wed Sep 10 2003 - 12:21:41 CDT