parallel_force_local and parallel query
From: Cee Pee <carlospena999_at_gmail.com>
Date: Mon, 24 Feb 2020 14:38:50 -0600
Message-ID: <CAPTPB12P_DnxbiRM0xZUk6Xd0wmrcQAbvfCz_C7PEA0woKUKbQ_at_mail.gmail.com>
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.
Date: Mon, 24 Feb 2020 14:38:50 -0600
Message-ID: <CAPTPB12P_DnxbiRM0xZUk6Xd0wmrcQAbvfCz_C7PEA0woKUKbQ_at_mail.gmail.com>
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-lReceived on Mon Feb 24 2020 - 21:38:50 CET