RE: Slow create LMT - Oracle or Disk

Thanks, Dennis & Anand.  

I guess it's impolite to ask a question and then leave the responder up in the air, but other things had my attention for a couple of days. I think Dennis hit it on the head. The SAN array is RAID-5 with a 2Gb cache. On top of that, the array is a split mirror set which probably adds additional overhead. Thanks for your input.  

Mike Hand

From: Dennis Williams [mailto:oracledba.williams_at_gmail.com] Sent: Wednesday, May 31, 2006 2:14 PM
To: Hand, Michael T
Cc: oracle-l_at_freelists.org
Subject: Re: Slow create LMT - Oracle or Disk

Mike,  

I haven't experienced anything like this, but just a couple of questions:

• What is the disk configuration? RAID5?
• What is the size of the cache in front of the disk? Just an idea, but maybe if your cache is a few gig, the first ones went fast because you were just waiting for the cache to respond, but then once the cache was full, subsequent creates are as slow as the disk.

Dennis Williams

-- 
This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.



--
http://www.freelists.org/webpage/oracle-l