Oracle imports slow; ES40, T64U 5.1A, HSZ70, 9.2.0

From: Russ_Fish@idx.com
Date: Tue Oct 14 2003 - 13:58:00 EDT


Hi all--

This is probably a bit off topic, but I'm hoping someone has a similar
config and has seen this problem before.

We have an ES40, 4 CPU, 8 GB connected to an HSZ70. The system performs
nicely with one exception--it crawls when we run Oracle exports, imports,
and table drops. We've tested large unix to unix file copies, and those
work fine, so we're thinking it's somehow related to Oracle 9.2.0 disk
writes under 5.1B. We've tried all the Oracle-recommended tricks (large
rollback segment, noarchivelog, /dev/timedev, etc.) but so far it hasn't
helped. The system has plenty of free memory (no swapping at all), and if
the collective memory serves us, we did not see this problem when the
system was 4.0F with Oracle 8.1.7.

Any hints, suggestions, etc. greatly appreciated--we have some unhappy
users on our hands (so what's new).

--Russ

----------------------------------------------------
NOTICE OF CONFIDENTIALITY
----------------------------------------------------
The information in this email, including attachments, may be confidential and/or privileged and may contain confidential health information. This email is intended to be reviewed only by the individual or organization named as addressee. If you have received this email in error please notify IDX immediately - by return message to the sender or to security@idx.com - and destroy all copies of this message and any attachments. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of IDX. Confidential health information is protected by state and federal law, including, but not limited to, the Health Insurance Portability and Accountability Act of 1996 and related regulations.



This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:49:38 EDT