Re: Problems starting SQLPLUS ?
Date: 27 May 2004 08:26:06 -0700
Message-ID: <80de4f.0405270726.32e0420_at_posting.google.com>
[Quoted] john.hetherington_at_xansa.com (Happy John) wrote in message news:<4cc96e58.0405270127.4261f71_at_posting.google.com>...
> 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
[Quoted] [Quoted] 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 Received on Thu May 27 2004 - 17:26:06 CEST