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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
