Home » RDBMS Server » Server Administration » Oracle7.3 is very slow
Oracle7.3 is very slow [message #52171] Sat, 06 July 2002 02:47 Go to next message
B.SUNIL KUMAR RAO
Messages: 5
Registered: February 2002
Junior Member
Hi,
I have oracle7.3 server on Unix .It is taking 20-30 sec. for to get the connection to database both from remotly and locally.
What could be the problem.I have checked with script utlbstat.sql and found all parameter are ok.
Ur help is Solicited.

Report message to a moderator

Re: Oracle7.3 is very slow [message #52179 is a reply to message #52171] Sun, 07 July 2002 22:31 Go to previous message
P
Messages: 29
Registered: May 2002
Junior Member
Have you tried to ping the listener? how long was the response.
how much load is there on your machine.
If there is almost no activity on your db the Bstat/estat may not produce a result which is useless to ascertaining where your current problem is occuring

Report message to a moderator

Previous Topic: Re: Oracle & WIN2K installation error
Next Topic: recovering redo logs
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 21:53:41 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.