RE: RE: Parallel Execution

That's exactly what I said - Schema Browser is our code and option handles that - editor is their code and their responsibility

From: [email protected] [mailto:[email protected]] On Behalf Of John Dorlon
Sent: Wednesday, February 29, 2012 7:49 PM
To: <[email protected]>
Subject: Re: [toad] RE: Parallel Execution


That option affects SB data grids only.

- John

On Feb 29, 2012, at 6:02 PM, "Bert Scalzo" <[email protected]<mailto:[email protected]>> 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 :)

-----Original Message-----
From: [email protected]<mailto:toad%40yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.com>] On Behalf Of MCALLISTER, MICHAEL CTR AU Contractor AETC AETC/A3IS
Sent: Wednesday, February 29, 2012 5:56 PM
To: [email protected]<mailto:toad%40yahoogroups.com>
Subject: [toad] RE: Parallel Execution

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: [email protected]<mailto:michael.mcallister.2.ctr.au%40us.af.mil>

-----Original Message-----
From: [email protected]<mailto:toad%40yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.com>] On Behalf Of Bert
Scalzo
Sent: Wednesday, February 29, 2012 5:51 PM
To: [email protected]<mailto:toad%40yahoogroups.com>
Subject: [toad] RE: Parallel Execution

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.

-----Original Message-----
From: [email protected]<mailto:toad%40yahoogroups.com> <mailto:toad%40yahoogroups.com>
[mailto:[email protected]<mailto:toad%40yahoogroups.com> <mailto:toad%40yahoogroups.com> ] On Behalf Of
MCALLISTER, MICHAEL CTR AU Contractor AETC AETC/A3IS
Sent: Wednesday, February 29, 2012 5:15 PM
To: [email protected]<mailto:toad%40yahoogroups.com> <mailto:toad%40yahoogroups.com>
Subject: [toad] 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: [email protected]<mailto:michael.mcallister.2.ctr.au%40us.af.mil>
<mailto:michael.mcallister.2.ctr.au%40us.af.mil>