| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> update on slow connections
List,
OS Novell 4.2
Oracle 7.3.4.5.1
disks. OS and Oracle RAID 1
Data and Index RAID 5
Hardware Dell 6300 with Perc Controller Card.
The users were experiencing a doggy_slow_connect_time (technical
term)
connecting to the database. Of course it was the database that was the
problem. Nothing in the error or alert logs that was not normal. Once
the connections were established the work was slow but functional. A
shutdown of oracle and a reboot of the server solved the problem for a
while. After a few days the slowness would build again until a reboot
was performed by the network/sysadmin.
I viewed the system error log and found an enter where the perc card
showed an error to drive 0:0:0 on the days before the reboots.
We split the RAID 1 and the users response was good. Hardware support
was called and the perc card and drive 0:0:0 replaced and the server is
now faster than when installed. The normal daily load now takes 3+
minutes rather than the 5+ minutes before.
If you are having connection slow downs be sure to check ALL possible
solutions and read all logs for errors, even small ones can point to a
potential problem.
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
INET: RROGERS_at_galottery.org
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 14 2003 - 13:19:12 CST
 |
 |