Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [06-2006 Date Index] [Date Next] || [Thread Prev] [06-2006 Thread Index] [Thread Next]

Re: Slow create LMT - Oracle or Disk

  • From: "Anand Rao" <panandrao@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 1 Jun 2006 12:19:43 +0530
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@xxxxxxxxx> 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





[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.