Re: Slow create LMT - Oracle or Disk

Just some thoughts....

did you check for any async IO problems? is the async IO driver configured properly? i usually wouldn't dare ask these questions for a Tru64 box....it works like a charm...

but, you never know. check the trace files in udump or for some alert.logmessages.

since you mentioned file...i am assuming you are using a filesystem such as JFS2. any errors in /var/adm/messages ? or in the /var/adm/syslog.<date>/syslog.log ?

maybe some other process is pumping IO into the same disk or VG ???? ...

cheers
anand

On 31/05/06, Dennis Williams <oracledba.williams_at_gmail.com> wrote:
>
> 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
>

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