For example I query a table with 1000000 rows (seen by my user) with parallel degree 4, in my SQL*PLUS session I run a select * from table

my session will fetch the correct results but the other 3 PQ slave process wont because the policy only applies in my SQL*PLUS session not the slave session, i.e Oracle doesnt know that those three slave sessions are spawned by my user, it will treat as any other user and start fecthing wrong results