Oracle-L: update on slow connections

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 14 Jan 2003 11:19:12 -0800
Message-ID: <F001.0052F7CF.20030114111912@fatcity.com>

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