Re: parallel_force_local and parallel query

I see, because it uses parallelism it bypasses the SGA and data blocks go to PGA. In case of DML, I would think that the data will have to go to SGA because of the rollback information.

On Mon, Feb 24, 2020 at 4:30 PM Ghassan Salem <salem.ghassan_at_gmail.com> wrote:

> The setting is per session, or system wide, not per object.
> If there were no dml on the table, the scan on the first node will not put
> anything in the sga, so there's nothing to transfer to the second node,
> unless you are using in memory parallel query.
> Regards
>
> On Mon, Feb 24, 2020, 21:40 Cee Pee <carlospena999_at_gmail.com> wrote:
>
>>
>> Hopefully not a dumb question, By setting parallel force local to TRUE
>> all the queries for a particular table and other objects happen in the
>> local instance only. What happens if a different query is issued from a
>> different node for the same table or object. Does the data get transferred
>> over the interconnect, if data is still cached in the first node. Assume
>> SELECTs only in both nodes.
>>
>> Thanks
>> CP
>>
>

--
http://www.freelists.org/webpage/oracle-l