Toad Alternative

pl/sql is so cool but nowadays I have a problem with it that I can't trace
from its forum even.
I HANGS whenever I am developing a procedure.Sometimes when editing
contents and sometimes when compiling procedure.
Is there any body have the same problem? Any idea about workaround of this?
Should I change oracle's parameters regarding pga or library cache....?
-Thanks


--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....racle/200507/1

Sybrand Bakker wrote:
> On Sun, 24 Jul 2005 17:58:23 +0200, "Martijn Tonies"
> <m.tonies@upscene-removethis.nospam.com> wrote:
>
>
>>Database Workbench is multi-threaded for running queries.
>>
>>It's not multi-threaded for connecting or loading metadata objects
>>though.
>>
>
>
>
> And again a thread like this has resulted in the inevitable
> self-marketing, which should be correctly identified as *SPAM*
>
>
> --
> Sybrand Bakker, Senior Oracle DBA


The sad thing is, that it started right off this way! Alexb asked
for a tool cheaper than toad, when the expected answer didn't come
out he gave the thread a quick knock in the right direction:

> Seriously all the tools mentioned are not multithreaded, they are all
> too cluttered for my taste. I found something at
> http://www.oncilla.com, it is still a beta did anyone try this tool?

Not to mention that he's wrong about toad or pl/sql developer not being
multithreaded.
Only two hours later, he's already an expert (in the thread about toad not
starting):

> Try a different tool, its at http://www.oncilla.com. very different
> than other tools I've seen

And then, another two hours later no more words about multithreading but
nifty point and clicky thingys:

> When you are looking at the PLSQL spec the functions/procedures become
> hotlinks clicking them will lead you to the actual code in the Body. It
> also identifies packages in the code and creates them as links, its
> cool especially if you are working in a E Business database with so
> much code you can get lost. You have to play around in it to see what I
> am talking about.

That's the lamest spam I've seen in a while. Does anyone remember the
first post where Alexb asked for something cheaper than Toad? Strangely
enough, the oncilla site has no pricing informations (the tool is beta),
so how can you actually compare prices if they don't exist? Aahh, I forgot,
we're dealing with tripple valued logic here: If the price is null, then
it might just be cheaper....

Cheers,
Holger

PS: And Alexb beware: One more mention of oncilla and you'll be marked as
spammer forever.

Sybrand,

> >Database Workbench is multi-threaded for running queries.
> >
> >It's not multi-threaded for connecting or loading metadata objects
> >though.
> >
>
>
> And again a thread like this has resulted in the inevitable
> self-marketing, which should be correctly identified as *SPAM*

I wouldn't have replied to this if it weren't for a mis-informed
statement being made about our products.


--
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Alexb wrote:
> Is there any multithreaded tool like toad, it should be cheaper then
> it though

http://sourceforge.net/projects/tora/

Tora seems to use a lot of CPU. I posted a message to their forum with
no reply:
http://sourceforge.net/forum/forum.p...forum_id=52737

Any suggestion is appreciated.

Yong Huang

In my shop TOAD causes all sorts of problems. It seems to hang and crash on the users
desktop which leaves the sessions hung in the DB's. Many times these sessions are holding
locks and waiting on pipe events which requires me to go in and manually kill them off.

I've never used any GUI tools ( I'm a command line guru ) regularly, but my experience
with TOAD would make me go elsewhere if I wanted one. It's a POS in my opinion.

-Kevin

"Alexb" <alexbeauc@yahoo.com> wrote in message
news:1122098412.361581.184220@g47g2000cwa.googlegr oups.com...
> Is there any multithreaded tool like toad, it should be cheaper then it
> though
>

yahoo.com">yong321@yahoo.com wrote:
> Tora seems to use a lot of CPU.

same problem for me.
full of bug, and completely unstable under windows.
I'll test it on linux some day...
Could be a great TOAD alternative if stable.

Ach C via DBMonster.com wrote:
> pl/sql is so cool but nowadays I have a problem with it that I can't trace
> from its forum even.
> I HANGS whenever I am developing a procedure. Sometimes when editing
> contents and sometimes when compiling procedure.
> Is there any body have the same problem? Any idea about workaround of this?

Never seen that problem. Then again perhaps my version is different to
yours, or the Oracle client or database version is different etc. The
vendor may be able to recommend tests or debug settings. This may not
be the best forum for "My PL/SQL Dev session hangs" type questions.

Actually it seems like they suggested a workaround when you posted
there:
http://www.allroundautomations.com/u...c;f=3;t=002299
Some version and environment information would probably help over there
as well.

> Should I change oracle's parameters regarding pga or library cache....?

No!

On 22 Jul 2005 23:00:12 -0700, Alexb wrote:

> Is there any multithreaded tool like toad, it should be cheaper then it
> though

SQLTools? www.sqltools.net

Patrick