- Community Home
- >
- Storage
- >
- Entry Storage Systems
- >
- Disk Enclosures
- >
- Re: Should Oracle database filesystems be on actua...
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
тАО12-22-2003 05:08 AM
тАО12-22-2003 05:08 AM
Should Oracle database filesystems be on actual different EMC disks?
We had some performance problems recently and discovered that one of our Oracle Databases, although carefully distributed across some 35 different HyperVolumes, was actually jammed onto only 5 EMC physical disks.
(We filled out Symmetrix frame in "chunks", 50 disks on initial delivery, 20 more, 20 more, etc..)
Now, I know that all reads and writes from cache. But is there any value in actually distributing the Oracle Database file systems across separate PHYSICAL DISKS.
Please don't tell me about Oracle SAME (Stripe and Mirror Everything). We're NOT interested in doing that.
We're also not interested in doing the entire Symm as striped meta-volumes.
Stuart
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-22-2003 06:26 AM
тАО12-22-2003 06:26 AM
Re: Should Oracle database filesystems be on actual different EMC disks?
I am not sure about what kind of answere you want.
Each physical disk han handle a limited number of IOPS (perhaps 150 to 200) and, of course, the more disks your database is distributed across the better performance you can get. If your database realy need that performance is another question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-22-2003 06:46 AM
тАО12-22-2003 06:46 AM
Re: Should Oracle database filesystems be on actual different EMC disks?
off course the standard statement from Oracle is: Use as many disks as you can. Do you have any hint, that I/O is a bottleneck in your system? Avoiding I/O is still better than distributing it. ;-)
greetings,
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-22-2003 06:51 AM
тАО12-22-2003 06:51 AM
Re: Should Oracle database filesystems be on actual different EMC disks?
2. Our "sar -d" avwait and avserv went from 10 ms normal to as much as a 100 ms on a recent stress test; causing everybody to wonder about the disks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-22-2003 07:00 AM
тАО12-22-2003 07:00 AM
Re: Should Oracle database filesystems be on actual different EMC disks?
We try to put all dtabase files on the striped meta as far as possible and we have large amount of cache . But sometimes we are not able to put all of them on the striped meta and so we put it on the hypers but we haven't seen any performance issues since all read and write is through cache .
In your case may be the front end FA was hogged up if it was shared with other hosts possibly due to a 1Gb and 2 Gb HBA's zoned to the same FA port .
35 hypers onto 5 Physicals . Whats the size of your physicals and hypers . Usually hyper volume are assigned from adjacent physicals and there is low chances for one host to hypers from the same physical disk .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-22-2003 07:06 AM
тАО12-22-2003 07:06 AM
Re: Should Oracle database filesystems be on actual different EMC disks?
TO get the real picture of the I/O you will have to run I/O tests agains the frame itself , specially against the FA and the backend DA's .
YOu can gather performance data on the symm through ECC .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-04-2004 07:21 PM
тАО01-04-2004 07:21 PM
Re: Should Oracle database filesystems be on actual different EMC disks?
I try to avoid using metas unless it is administratively effecient to employ them. I also [try to] limit my metas to 8 hypers (the number of backend buses in the frame), with each on a different spindle and bus. For example, I would stripe logical volumes over 20 striped metas of 8 hypers each in a single volume group rather than manage 160 individual hypers in 10 volume groups. Further, I would distribute the metas over as many spindles as possible (say 48), but if the database acitivity is low, I may only need 16 spindles.
Keep in mind that, in older microcode, a single meta could only handle the same amount of io as, I think, four hypers. So you wouldn't gain any io performance by making the metas wider. Fortunately recent microcde has improved the io performance of meta-volumes.
I'll stop here because I'm afraid I may have made the issue more confusing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-04-2004 07:30 PM
тАО01-04-2004 07:30 PM
Re: Should Oracle database filesystems be on actual different EMC disks?
Did you setup some kind of load balancing with alternate paths ?
What about using PowerPath ?
How many connections from server(s) to EMC ?
How much cache installed ?
What kind of connection interfaces do you use ?
Some more info could be useful.
Rgds
Alexander M. Ermes