Toad World® Forums

Parallel Execution

All

I just finished reading a post titled “Pitfalls of Using Parallel Execution
with SQL Developer” which can be found here:-

http://structureddata.org/2012/02/29/pitfalls-of-using-parallel-execution-wi
th-sql-developer/

I’m not trying to start a “bash SQL Developer” thread here. What I’m
interested in knowing is whether TOAD is susceptible to this same issue as
well?

Regards,

Mike McAllister
Principal Systems Engineer
Decypher
DSN: 487-3751
Commercial: (210) 652-3751
Cell: (512) 423-7447
Email: michael.mcallister.2.ctr.au@us.af.mil

smime.p7s (5.14 KB)
smime.p7s (5.59 KB)

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.

The only item I found searching on “parallel” was:-

Schema Browser -> Data Tab -> Use NOPARALLEL Hint

Does this affect queries done in editor windows as well?

Regards,

Mike McAllister
Principal Systems Engineer
Decypher
DSN: 487-3751
Commercial: (210) 652-3751
Cell: (512) 423-7447
Email: michael.mcallister.2.ctr.au@us.af.mil
smime.p7s (5.59 KB)

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 :slight_smile:

That option affects SB data grids only.

  • John

On Feb 29, 2012, at 6:02 PM, “Bert Scalzo” wrote:

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 exactly what I said – Schema Browser is our code and option
handles that – editor is their code and their responsibility

Bert

Thanks for the clarification, I appreciate it :slight_smile:

Regards,

Mike McAllister
Principal Systems Engineer
Decypher
DSN: 487-3751
Commercial: (210) 652-3751
Cell: (512) 423-7447
Email: michael.mcallister.2.ctr.au@us.af.mil
smime.p7s (5.59 KB)