Re: Async_io set up HP-UX for 10g Instances(these are apps instances)
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: edwin_kodamala@xxxxxxxxx
- Date: Fri, 3 Aug 2007 12:43:08 +0200
Edwin
- dbwr_io_slaves is used to simulate asynch io on platforms that do not
support it (for example, hp-ux with a filesystem (and not using raw devs)).
- db_writer_processes is used to start up multiple dbwr processes that will
manage the buffer cache together, if one process alone is too slow. your
value of 4 seems a bit high. How large is your sga / buffer cache ? Do you
really need 4 processes ?
- disk_asynch_io is used to enable the oracle kernel to make use of
asynchronous io, IF the OS supports it.
Stefan
On 8/2/07, edwin devadanam <edwin_kodamala@xxxxxxxxx> wrote:
>
> Hi
>
> We have this setup
> db_writer_processes = 4 disk_asynch_io = false
>
> I have doubts whether i can set the below on....
> please suggest advantages and disadvantages of below setting.......on
> HP-UX
> disk_asynch_io = TRUE
> tape_asynch_io = TRUE
>
> am unclear mainly about disk_asynch_io,db_writer_processes,DBWR_IO_SLAVES
>
> Any help would be appreciated.
>
> Regards,
> Edwin.K
>
> ------------------------------
> Shape Yahoo! in your own image. Join our Network Research Panel
> today!<http://us.rd.yahoo.com/evt=48517/*http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7>
>
>
--
=========================
Stefan P Knecht
Consultant
Infrastructure Managed Services
Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg
Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht@xxxxxxxxxxxx
http://www.trivadis.com
=========================
Other related posts:
