Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Arch configuration -- I/O stuck

Arch configuration -- I/O stuck

From: Pablo ksksksk <p_rodri99_at_yahoo.es>
Date: Wed, 31 Oct 2001 11:43:13 -0800
Message-ID: <F001.003B994B.20011031114522@fatcity.com>

Hi list,

  Oracle 7.3.4
  HP-UX
  log_archive_buffer_size=32 (redo log blocks = 1K)   log_archive_buffers=4
  Filesystem based (no direct I/O)

  I've been detecting that my box gets stucked eventually for some time.
  When this happens I can't do even a "ls" (it actually executes it but it takes a long time).   If I check my cpu with TOP, I see 47% idle time and there's no process monopolizing the CPU.   But when I check disk activity with sar -d I see that one disk is 100% busy and it's avwait+avserv > 1000 ms. The other disks are fine.
  I then check disk activity with Glance and I can identify the process that's writting/reading on this disk is: ARCH (ARCH is writting a 1.9 GB redo log.)

  So here are my doubts:

      1)If only one disk is saturated (I've got about 30 disks in this box (a SYMMETRIX array) with some controllers), why does the whole box get stucked? why are even other applications connected to other instances running on this box affected? (may be because the HP-UX LVM system gets saturated???)

     2) What can I do to avoid this problem?, (reduce log_archive_buffers parameter may be, or increase log_archive_buffer_size)

help me on this
Thanks



Do You Yahoo!?
Yahoo! Messenger
Comunicación instantánea gratis con tu gente. http://messenger.yahoo.es
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: =?iso-8859-1?q?Pablo=20ksksksk?=   INET: p_rodri99_at_yahoo.es
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Oct 31 2001 - 13:43:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US