RE: Parallel Execution

Bert

Thanks for the clarification, I appreciate it :-)

Regards,

Mike McAllister 
Principal Systems Engineer
Decypher
DSN:                      487-3751
Commercial:       (210) 652-3751
Cell:                       (512) 423-7447
Email:                    [email protected]


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Bert
Scalzo
Sent: Wednesday, February 29, 2012 6:02 PM
To: [email protected]
Subject: [toad] RE: Parallel Execution

  

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>