Skip to search.

Breaking News Visit Yahoo! News for the latest.

×Close this window

toad · Self Help List for TOAD Development Users

The Yahoo! Groups Product Blog

Check it out!

Group Information

  • Members: 7640
  • Category: Oracle
  • Founded: Jul 22, 1998
  • Language: English
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Messages

Advanced
Messages Help
Parallel Execution   Topic List   < Prev Topic  |  Next Topic >
Summarize Messages | View Threaded Sort by Date ^  
#57333 From: "MCALLISTER, MICHAEL CTR AU Contractor AETC AETC/A3IS" <michael.mcallister.2.ctr.au@...>
Date: Wed Feb 29, 2012 11:15 pm
Subject: Parallel Execution
michael.mcallister.2.ctr.au@...
Send Email Send Email
 
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@...

#57334 From: Bert Scalzo <bert.scalzo@...>
Date: Wed Feb 29, 2012 11:50 pm
Subject: RE: Parallel Execution
bert.scalzo
Send Email Send Email
 
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: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of
MCALLISTER, MICHAEL CTR AU Contractor AETC AETC/A3IS
Sent: Wednesday, February 29, 2012 5:15 PM
To: toad@yahoogroups.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:                    michael.mcallister.2.ctr.au@...

#57335 From: "MCALLISTER, MICHAEL CTR AU Contractor AETC AETC/A3IS" <michael.mcallister.2.ctr.au@...>
Date: Wed Feb 29, 2012 11:56 pm
Subject: RE: Parallel Execution
michael.mcallister.2.ctr.au@...
Send Email Send Email
 
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@...


-----Original Message-----
From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Bert
Scalzo
Sent: Wednesday, February 29, 2012 5:51 PM
To: toad@yahoogroups.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: toad@yahoogroups.com <mailto:toad%40yahoogroups.com>
[mailto:toad@yahoogroups.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: toad@yahoogroups.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: michael.mcallister.2.ctr.au@...
<mailto:michael.mcallister.2.ctr.au%40us.af.mil>

#57336 From: Bert Scalzo <bert.scalzo@...>
Date: Thu Mar 1, 2012 12:02 am
Subject: RE: Parallel Execution
bert.scalzo
Send Email Send Email
 
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: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of
MCALLISTER, MICHAEL CTR AU Contractor AETC AETC/A3IS
Sent: Wednesday, February 29, 2012 5:56 PM
To: toad@yahoogroups.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:                    michael.mcallister.2.ctr.au@...


-----Original Message-----
From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Bert
Scalzo
Sent: Wednesday, February 29, 2012 5:51 PM
To: toad@yahoogroups.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: toad@yahoogroups.com <mailto:toad%40yahoogroups.com>
[mailto:toad@yahoogroups.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: toad@yahoogroups.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: michael.mcallister.2.ctr.au@...
<mailto:michael.mcallister.2.ctr.au%40us.af.mil>

#57337 From: John Dorlon <john.dorlon@...>
Date: Thu Mar 1, 2012 1:48 am
Subject: Re: RE: Parallel Execution
jdorlon...
Send Email Send Email
 
That option affects SB data grids only. 

- John

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

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

-----Original Message-----
From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Bert
Scalzo
Sent: Wednesday, February 29, 2012 5:51 PM
To: toad@yahoogroups.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: toad@yahoogroups.com <mailto:toad%40yahoogroups.com>
[mailto:toad@yahoogroups.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: toad@yahoogroups.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: michael.mcallister.2.ctr.au@...
<mailto:michael.mcallister.2.ctr.au%40us.af.mil>


#57338 From: Bert Scalzo <bert.scalzo@...>
Date: Thu Mar 1, 2012 3:20 am
Subject: RE: RE: Parallel Execution
bert.scalzo
Send Email Send Email
 

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

 

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

 

 

That option affects SB data grids only. 

- John


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

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

-----Original Message-----
From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Bert
Scalzo
Sent: Wednesday, February 29, 2012 5:51 PM
To: toad@yahoogroups.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: toad@yahoogroups.com <mailto:toad%40yahoogroups.com>
[mailto:toad@yahoogroups.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: toad@yahoogroups.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: michael.mcallister.2.ctr.au@...
<mailto:michael.mcallister.2.ctr.au%40us.af.mil>


#57345 From: "MCALLISTER, MICHAEL CTR AU Contractor AETC AETC/A3IS" <michael.mcallister.2.ctr.au@...>
Date: Thu Mar 1, 2012 3:03 pm
Subject: RE: Parallel Execution
michael.mcallister.2.ctr.au@...
Send Email Send Email
 
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:                    michael.mcallister.2.ctr.au@...


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

-----Original Message-----
From: toad@yahoogroups.com <mailto:toad%40yahoogroups.com>
[mailto:toad@yahoogroups.com <mailto:toad%40yahoogroups.com> ] On Behalf Of
Bert
Scalzo
Sent: Wednesday, February 29, 2012 5:51 PM
To: toad@yahoogroups.com <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: toad@yahoogroups.com <mailto:toad%40yahoogroups.com>
<mailto:toad%40yahoogroups.com>
[mailto:toad@yahoogroups.com <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: toad@yahoogroups.com <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: michael.mcallister.2.ctr.au@...
<mailto:michael.mcallister.2.ctr.au%40us.af.mil>
<mailto:michael.mcallister.2.ctr.au%40us.af.mil>

 
Add to My Yahoo!      XML What's This?

Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines NEW - Help