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.log messages.

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@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

Re: Slow create LMT - Oracle or Disk

Anand Rao

2006-06-01