There are Toad options (do search on parallel) to control this very thing - been in the product like 5+ years - but you need to set the option to disable this scenario.
That’s the one - in the case that you see data in a grid on a parallel object - that’s our code and on us to control - and releases the locks. But if you do so in the editor, for example
Select /*+ parallel */ * from big_table …
Then it’s your code and not ours - so onus is on user to understand and deal with properly
That’s the one - in the case that you see data in a grid on a parallel
object - that’s our code and on us to control - and releases the locks. But
if you do so in the editor, for example
Select /*+ parallel */ * from big_table .....
Then it's your code and not ours - so onus is on user to understand and deal
with properly :)