Databases
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 :-)