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: 

Mincache and Convosync access

Highlighted
Wilder Mellotto
Frequent Advisor

Mincache and Convosync access

Hi, we need some information about direct i/o.

 

We have one 9000/800/SD16A running HP-UX B.11.11 connected to one storage EMC DMX4 with 2 HBAs. The LUN paths was tested and all 4 path for a single LUN are working with load balance, that we can view with "powermt watch"

We have some issues with Oracle performance and we changed some attributes for some filesystems with oracle datafiles and here some tests:


Options - rw,delaylog,largefiles 0 2

 

# time prealloc tempfile 524288000;rm tempfile
real 8.9
user 0.0
sys 3.0

 

 

 

For Oracle cookbook performance is recommended to do direct i/o and then:

 

Options - rw,delaylog,largefiles,mincache=direct,convosync=direct 0 2

# time prealloc tempfile 524288000;rm tempfile

real 1:14.3
user 0.0
sys 11.6

 

 

What is causing this huge diference timing? Can anyone help?

 

Thanks.

1 REPLY
Matti_Kurkela
Honored Contributor

Re: Mincache and Convosync access

If you are tuning a filesystem for maximum Oracle performance, you should measure it with an Oracle-level benchmark, not with an OS-level benchmark.

 

The options "mincache=direct,convosync=direct" are effectively disabling OS-level caching for the filesystem for most operations. It makes sense, because Oracle already has its own set of caches - and because Oracle "knows what it is doing", its cache can support Oracle-level operations more efficiently than the standard OS-level cache. But when you disable OS-level caching, any operations done by generic programs to that particular filesystem can of course be significantly slower.

MK