Re: parallel_force_local and parallel query

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