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