- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- VXFS mount options for Oracle DB on XP1024 disks a...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2005 07:22 PM
тАО10-23-2005 07:22 PM
I did read in a White Paper that for taking full advantage of a high-end disks array when ruuning a Oracle DB, it was advisable to mount data lvols with the following options:
"-o nodatainlog,mincache=direct,convosync=direct"
in order to skip LVM cache and benefit from large cache at disk array level instead.
Any comment/warning about this advice on the mount options?
Rgds,
Romaric.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2005 07:29 PM
тАО10-23-2005 07:29 PM
Re: VXFS mount options for Oracle DB on XP1024 disks array:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2005 07:59 PM
тАО10-23-2005 07:59 PM
Re: VXFS mount options for Oracle DB on XP1024 disks array:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2005 09:36 PM
тАО10-23-2005 09:36 PM
Re: VXFS mount options for Oracle DB on XP1024 disks array:
"in order to skip LVM cache and benefit from large cache at disk array level instead" :
I suppose yuo meant the vxfs cache (not LVM). The file systems cache and XP array cache are 2 different things. The XP cache is part of the backend storage and that you use or not file systems cache does not affect it.
The options you mention for Oracle will be good if the access type is mostly random. If not you may find the file systems cache may helpin some instances.
The purpose of these options (require OnlineJFS product) is to bypass the file system cache and therefore you could dedicate more memory on the system to the Oracle SGA as opposed to the file systems.
see attachment
Unix Performance Cookbook.
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2005 10:47 PM
тАО10-23-2005 10:47 PM
SolutionIt's a good advice!
But be sure you have a well tuned database. Check, for example, if you have a good Buffer Cache Hit Ratio:
select round(((1-(sum(decode(name, 'physical reads', value,0)) /
(sum(decode(name,'db block gets', value,0))+
(sum(decode(name, 'consistent gets', value, 0))))))*100),2)
|| '%' "Buffer Cache Hit Ratio > 95%"
from v$sysstat;
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-24-2005 01:02 AM
тАО10-24-2005 01:02 AM
Re: VXFS mount options for Oracle DB on XP1024 disks array:
You will have an history (and baseline) for performance
http://www.oracle.com/technology/deploy/performance/pdf/statspack.pdf
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-24-2005 01:46 AM
тАО10-24-2005 01:46 AM
Re: VXFS mount options for Oracle DB on XP1024 disks array:
Still, the BEST Oracle storage on *any* disk infrasrtcuture (whether "cache-centric" --- XP for instance or not) is to store your Database raw - period.
Tools within LVM or VxVM allow for easy management of Raw storage -- contrary to earlier myths and 'lore that using raw storage is difficult.
Favourite Toy:
AMD Athlon II X6 1090T 6-core, 16GB RAM, 12TB ZFS RAIDZ-2 Storage. Linux Centos 5.6 running KVM Hypervisor. Virtual Machines: Ubuntu, Mint, Solaris 10, Windows 7 Professional, Windows XP Pro, Windows Server 2008R2, DOS 6.22, OpenFiler
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-24-2005 07:53 PM
тАО10-24-2005 07:53 PM