Search the web
Sign In
New User? Sign Up
toad · Self Help List for TOAD Development Users
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Performance of Toad Debugger   Message List  
Reply | Forward Message #44821 of 49318 |
RE: [toad] Re: Performance of Toad Debugger

Exactly - see my last reply. I know you say SQL Developer does not have the issue - but they are using the JDWP debugger API, so unless you are choosing the same option in Toad - then by default you'd be using the old DBMS_DEBUG API - so you are not comparing apples to apples


From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Jeff Smith
Sent: Friday, November 21, 2008 8:35 AM
To: toad@yahoogroups.com
Subject: RE: [toad] Re: Performance of Toad Debugger

Oracle is hanging, not Toad.

If you ask to trace into, some parsing is happening, if you ‘step over’ it simply goes to the next line in the source.

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of urfriend_friendy
Sent: Friday, November 21, 2008 8:44 AM
To: toad@yahoogroups.com
Subject: [toad] Re: Performance of Toad Debugger

Scalzo,
Fortunately it wasn't a procedure/function in my case. But
unfortunately it took pretty much time for each and every statement
in the program!

Even if it's a procedure/function y shd it hang?

--- In toad@yahoogroups.com, Bert Scalzo <bert.scalzo@...> wrote:
>
> Trace into does not mean go to next statement - it means drill down
into next statement. So if next statement is a procedure/function
call - it's stepping into that code. And if you have set options to
ignore built-in ones - you're paying to do the work to skip it. I
suggest reviewing the help on what the various debugger step options
are/mean to be safe .....
>
> ________________________________
> From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf
Of urfriend_friendy
> Sent: Friday, November 21, 2008 7:05 AM
> To: toad@yahoogroups.com
> Subject: [toad] Re: Performance of Toad Debugger
>
>
> Jeff,
> It is taking time whenever I'm clicking 'Trace into' to go to the
> next statement.I checked the status of toad in Task manager and it
> was 'Not responding'.
> Thanks
> --- In toad@yahoogroups.com<mailto:toad%40yahoogroups.com>, Jeff
Smith <jeff.smith@> wrote:
> >
> > We need more info to help.
> >
> > Where is it slow, is it when it initiates a connection/execution
> session for example?
> >
> > From: toad@yahoogroups.com<mailto:toad%40yahoogroups.com>
[mailto:toad@yahoogroups.com<mailto:toad%40yahoogroups.com>] On Behalf
> Of urfriend_friendy
> > Sent: Thursday, November 20, 2008 5:20 AM
> > To: toad@yahoogroups.com<mailto:toad%40yahoogroups.com>
> > Subject: [toad] Performance of Toad Debugger
> >
> >
> > Hi There,
> >
> > Toad Debugger is extremely slow.I don't know y? Sometimes, it's
> simply
> > getting hanged up and I even got 'Application encountered
exception'
> > message when I clicked Step-Over when control was at the last
> statement.
> >
> > I am using Toad 9.5 with Oracle 10g on 1GB RAM Windows XP
> professional
> > OS.Is there any thing that I can do to improve the performance?
> > Also observed that Debugger of 'PL/SQL Developer' is pretty fast
on
> > the same computer and Database.
> >
>



Fri Nov 21, 2008 3:33 pm

bert.scalzo
Offline Offline
Send Email Send Email

Forward
Message #44821 of 49318 |
Expand Messages Author Sort by Date

Hi There, Toad Debugger is extremely slow.I don't know y? Sometimes, it's simply getting hanged up and I even got 'Application encountered exception' message...
urfriend_friendy
urfriend_fri...
Offline Send Email
Nov 20, 2008
1:09 pm

We need more info to help. Where is it slow, is it when it initiates a connection/execution session for example? From: toad@yahoogroups.com...
Jeff Smith
toaddev
Offline Send Email
Nov 20, 2008
1:18 pm

sqlmonitor to see what is going on? chris ________________________________ From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Jeff Smith ...
Tryon, Christopher S
nordberg3
Offline Send Email
Nov 20, 2008
1:37 pm

Jeff, It is taking time whenever I'm clicking 'Trace into' to go to the next statement.I checked the status of toad in Task manager and it was 'Not...
urfriend_friendy
urfriend_fri...
Offline Send Email
Nov 21, 2008
1:13 pm

Trace into does not mean go to next statement - it means drill down into next statement. So if next statement is a procedure/function call - it's stepping into...
Bert Scalzo
bert.scalzo
Offline Send Email
Nov 21, 2008
1:19 pm

Scalzo, Fortunately it wasn't a procedure/function in my case. But unfortunately it took pretty much time for each and every statement in the program! Even if...
urfriend_friendy
urfriend_fri...
Offline Send Email
Nov 21, 2008
2:32 pm

Oracle is hanging, not Toad. If you ask to trace into, some parsing is happening, if you 'step over' it simply goes to the next line in the source. From:...
Jeff Smith
toaddev
Offline Send Email
Nov 21, 2008
2:34 pm

Exactly - see my last reply. I know you say SQL Developer does not have the issue - but they are using the JDWP debugger API, so unless you are choosing the...
Bert Scalzo
bert.scalzo
Offline Send Email
Nov 21, 2008
3:34 pm

Scalzo, Thanx for your reply! But, can you help me resolve the below error when I tried JDWP Debugger of Toad. ORA-30683: failure establishing connection to...
urfriend_friendy
urfriend_fri...
Offline Send Email
Nov 24, 2008
12:14 pm

http://www.toadsoft.com/get2know9/#Java Make sure you have in the options your local pc IP/name referenced - the database opens a connection to your pc to init...
Jeff Smith
toaddev
Offline Send Email
Nov 24, 2008
12:44 pm

Toad simply calls an Oracle API debugger call to perform most operations - so if options and actions are selected that oppose or complicate each other - than...
Bert Scalzo
bert.scalzo
Offline Send Email
Nov 21, 2008
3:32 pm
Advanced

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