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@xxxxxxxxx> 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
