We have HP-UX 11.0 and are having IO problems.
Oracle and HP say to set a mount parameter
mincache=direct. We currently have it set
to mincache=tmpcache. But when we set it
to "direct" the db slows down to the point it's
unusable. HP said to increase the db_block_buffers,
so we increased then from 30k to 130k (8k block).
That's 1GB. The db was a little more usable but
still sucked. So we set the buffers back to 30k
and reset mincache back to tmpcache. Now the
db is again usable, but we there's still something
wrong with IO. sar reports WIO at +80%. ORacle
says that should be close to 0%. We are using
HP's LVM (resold veritas) and cooked files.
Any ideas?
thanks
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: tony ynot
INET: tony_ynot_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Tue Jan 14 2003 - 19:28:53 CST
