Re: Problems starting SQLPLUS ?
From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Thu, 27 May 2004 15:57:47 GMT
Message-ID: <%dotc.25269$SQ2.13475_at_edtnps89>
>
> There are several possible reasons including Oracle Server slowness,
> application server slowness, and networking issues.
>
> If you want to try and narrow things down, you could try our Super*SQL
> product which is Java based and perfoms many of the same functions as
> SQLPlus. If Super*SQL connects quickly then the problem is with your
> application server (i.e. the machine that SQLPlus is being launched
> from). If Super*SQL connects just as slowly as SQLPlus, then telnet
> to the Oracle server machine (if you can). Try running either SQLPlus
> or Super*SQL from that machine. If the connections are fast, then
> your network is the problem.
>
> Super*SQL is in Beta test so you can use it free of charge. For more
> information visit www.sqlmagic.com
Date: Thu, 27 May 2004 15:57:47 GMT
Message-ID: <%dotc.25269$SQ2.13475_at_edtnps89>
Davis wrote:
> john.hetherington_at_xansa.com (Happy John) wrote in message
> news:<4cc96e58.0405270127.4261f71_at_posting.google.com>...
[Quoted] [Quoted] >> When I start SQLPLUS it takes ages to do anything. Even when I dont >> enter any details on the command line, it takes 1 minute to ask for >> username. >> >> We are running on AIX? Could it be a system problem, we have alot of >> KPROC processes. >> >> Regards, John
>
> There are several possible reasons including Oracle Server slowness,
> application server slowness, and networking issues.
>
> If you want to try and narrow things down, you could try our Super*SQL
> product which is Java based and perfoms many of the same functions as
> SQLPlus. If Super*SQL connects quickly then the problem is with your
> application server (i.e. the machine that SQLPlus is being launched
> from). If Super*SQL connects just as slowly as SQLPlus, then telnet
> to the Oracle server machine (if you can). Try running either SQLPlus
> or Super*SQL from that machine. If the connections are fast, then
> your network is the problem.
>
> Super*SQL is in Beta test so you can use it free of charge. For more
> information visit www.sqlmagic.com
Davis,
With the discussion around SPAM in these groups lately, I commend you on your intelligent compromise between being a contributor and making people aware of your product. I'm impressed.
/Hans Received on Thu May 27 2004 - 17:57:47 CEST