Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle datawarahouse: i/o stuff

OMER ZENCIROGLU
Occasional Visitor

Oracle datawarahouse: i/o stuff

Hi, We're quite new with HP-UX & Oracle.
We have a new warehouse system running on an NPAR(4 cpu and 4 gb ram). HP-UX 11i and Oracle 9.2.0.4.
Trying to understand two things actually.
First the combination of OS parameters afftecting async i/o.
Plus are there any guidelines for mount options of oracle filesystems. (DB is no arc mode.)



6 REPLIES
Eric Antunes
Honored Contributor

Re: Oracle datawarahouse: i/o stuff

Hi Omer,

We are precisly discussing this on this thread:

http://forums.itrc.hp.com/service/forums/questionanswer.do?threadId=697612

Regards,

Eric
Each and every day is a good day to learn.
Jean-Luc Oudart
Honored Contributor

Re: Oracle datawarahouse: i/o stuff

Hi OMER

welcome to the forum !

There are a good few threads on the subjects.
I had a similar question regarding mount options for oracle DB
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=193104

also check this thread :
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=62288

What is the backend storage ?

Regards
Jean-Luc
fiat lux
OMER ZENCIROGLU
Occasional Visitor

Re: Oracle datawarahouse: i/o stuff

We're using HDS 9980V as backend storage.

Oracle :
dbwr_io_slaves :8
db_writer_processes :1
disk_asynch_io TRUE


HP-UX:
max_async_ports 50
aio_listio_max 256
aio_max_ops 2048
aio_physmem_pct 10
aio_prio_delta_max 20
fs_async 0
dbc_max_pct 10
dbc_min_pct 5

We have realized that oracle filesystems are all mounted with log option default mincache and convosync options.
Before looking into db, we wanted to take a look at OS site and found some configuration issues like these.
http://www.doag.org/pub/docs/sig/sap/2004-03/Dorer1.pdf

Yogeeraj_1
Honored Contributor

Re: Oracle datawarahouse: i/o stuff

hi,

concerning async i/o, the following kernel parameters needs to be reviewed:

a. max_async_ports limits the maximum number of processes that can concurrently use /dev/async

b. aio_max_ops limits the maximum number of asynchronous i/o operations that can be queued at any time. Set this parameter to the default value (2048)

also read metalink note: 139272.1 "HP-UX: Asynchronous i/o"

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
OMER ZENCIROGLU
Occasional Visitor

Re: Oracle datawarahouse: i/o stuff

We've checked that our kernel is not compiled with async driver. Since our oracle datafiles reside on filesystems not raw devices we're not using async i/o behaviour. right? So what is impact of having dbwr_io_slaves :8 and
db_writer_processes :1 set.I think that, in this situation using mutliple dw writers instead of io slaves may provide some performace gain.

OMER ZENCIROGLU
Occasional Visitor

Re: Oracle datawarahouse: i/o stuff

Many thanks for the extra info.