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.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

HP-UX 11i / Oracle 9.2 options for mount

claudio_22
Regular Advisor

HP-UX 11i / Oracle 9.2 options for mount

Hi,

I've read following for optmize Oracle on HP-UX :

===============================
Using Online JFS improves performance
Set these mount options

delaylog
nodatainlog
mincache=direct
convosync=direct

======================================

I've read man pages , anyway is not clear to me about advantages .

What exactly do these options and , above all , what could be cons ?

Thanks

6 REPLIES
Chris Xu
Trusted Contributor

Re: HP-UX 11i / Oracle 9.2 options for mount

Here is a good discussion on that subject.

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

In short, Oracle has its own memory management (SGA). Disabling buffer cache on Oracle data filesystems is a way to avoid double buffer the same data.

Chris


Chris Xu
Trusted Contributor

Re: HP-UX 11i / Oracle 9.2 options for mount

Here is a more recent discussion on the subject:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=753721

Chris
Jean-Luc Oudart
Honored Contributor

Re: HP-UX 11i / Oracle 9.2 options for mount

Hi

you can check the attached document

Regards
Jean-Luc
fiat lux
Jean-Luc Oudart
Honored Contributor

Re: HP-UX 11i / Oracle 9.2 options for mount

Claudio,

I would also refer to the white papers indicated in this thread
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=712921

JFS tuning will give a better understanding for these parameters.

From my post (cf. 1st reply for you) last year, it does not seem that we'll get magic.

tuning the application / SQL should be the 1st step to improve the overall performance

Regards
Jean-Luc
fiat lux
Jean-Luc Oudart
Honored Contributor

Re: HP-UX 11i / Oracle 9.2 options for mount

Claudio,

You will be interested with (attached) the UX performance cookbook.

As a matter of fact, I'd be interested in performance results when you change these parameters.
You will have to record a performance baseline (OS & Oracle) before the changes, then new measures and compare.

Just let us know with your findings


Regards
Jean-Luc
fiat lux
claudio_22
Regular Advisor

Re: HP-UX 11i / Oracle 9.2 options for mount

Thanks Jean ,

I've a lot of material to look now :-)