Re: scan and sort in parallel query - no sga cache

From: Steve Adams <steveadams_at_acslink.net.au>
Date: 1998/02/03
Message-ID: <34d6933a.606194880@newsserver.trl.oz.au>#1/1

Hi Chris,

This applies to all parallel scans from version 7.1.5 on, and to sorts from 7.2 onwards depending on the sort_direct_writes configuration. It has nothing to do with the size of the query.

Regards,
Steve Adams
steveadams_at_acslink.net.au

---

On Sun, 01 Feb 1998 21:54:42 -0500, Chris Kordish <kordish_at_mediaone.net> wrote:

>hi there,
> what kinds of parallel queries bypass the SGA - i was told that in oracle 7
>many of the parallel query processes ( SCAN and SORT ) that get started do not
>necessarily cache their data in the SGA ( especially large queries )
>
>this is for a DW workload - so polluting the SGA with large table scans is a
>good idea
>
>thx for any help/explanation
>chris
>
Received on Tue Feb 03 1998 - 00:00:00 CST