Re: Problems starting SQLPLUS ?

Hans Forbrich <forbrich_at_yahoo.net> wrote in message news:<Ddotc.25268$SQ2.10382_at_edtnps89>...
> Happy John wrote:
>
> > 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
>
> Answer: yes, it's possible that you have a system problem. I'd narrow it
> down to one of: hardware, software or configuration.
>
> You do not describe whether the SQLPlus session is local to the machine
> running the Oracle server, or remote.
>
> Standard troubleshooting technique would suggest some of the following:
>
> - check the SQLplus from the other one (local/remote)
> - identify the load on the machine(s) (are there load-related bottlenecks)
> - review the system swapping/paging
> - review memory usage
> - review standard TCP/IP networking issues (or appropriate protocol)
>
> Also, when asking for assistance or ideas, version numbers (OS, Oracle,
> Oracle Networking, etc) are useful.
>
> /Hans

A brief comment seems in order. The original poster is using SQLPlus which relies upon the TCP/IP transport, the SQL*Net client, and the machine that it is launched from. By using our product, which is Java based, it would be possible to eliminate SQL*Net and/or the launching of the program as the problem. If our program was also slow, then the user could concentrate on Oracle server or network protocol issues.

[Quoted] [Quoted] Characterizing my post as a "shameless" promotion of our product seems rather harsh, because it is available at no cost to the poster and might actually help him solve his problem. The download and test would be a one-time event which would take about 5 minutes.

I personally contribute to various forums and Open Source projects and have for many years. I have also been able to solve many, many problems with the help of others who freely share their experience through these news groups. I believe that we all benefit from this collaboration, which often includes references to commercial and non-commercial products. Received on Fri May 28 2004 - 19:53:15 CEST