Re: Problems starting SQLPLUS ?
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 27 May 2004 22:21:58 -0700
Message-ID: <1085721725.256858_at_yasure>
>>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
>>
>>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 22:21:58 -0700
Message-ID: <1085721725.256858_at_yasure>
Hans Forbrich wrote:
> Davis wrote: > >
>>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
>>
>>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
[Quoted] I didn't take his post that way at all. Perhaps I have misunderstood. But I don't see any relevance between what his product does and the question put forward about server slowness. Did I miss something?
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri May 28 2004 - 07:21:58 CEST