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:[email protected]] On Behalf Of MCALLISTER, MICHAEL CTR AU Contractor AETC AETC/A3IS
Sent: Wednesday, February 29, 2012 5:56 PM
To: [email protected]
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]


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Bert
Scalzo
Sent: Wednesday, February 29, 2012 5:51 PM
To: [email protected]
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:[email protected] <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> 
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> 






------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/