- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- oracle db on SAN (EVA)
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
тАО04-05-2004 11:05 PM
тАО04-05-2004 11:05 PM
we are going to move all our databases to a EVA SAN from HP. Today all databases are running on direct attached disksystem. When we move the databases to the SAN, what filesize on the databasefiles are most appropriate? I guess to small will generate alot of files and more waist of space. To big will slow down the restore procedures. Is 4 GB appropriate or is 8 GB appropriate. Any suggestions? Pros and cons? Our biggest database is 350 GB. It will be running on HP-UX 11i on Risc processors.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-05-2004 11:10 PM
тАО04-05-2004 11:10 PM
Re: oracle db on SAN (EVA)
what is the most performance boost up is try to minimize full table scan.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2004 02:00 AM
тАО04-06-2004 02:00 AM
Re: oracle db on SAN (EVA)
I suppose you're talking about future databases ?
A SAN should improve IO as you have "some" read and write cache. I you can have it go for RAID0+1 instead of RAID5.
What kind of backup utility do you use ?
Regards,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2004 02:19 AM
тАО04-06-2004 02:19 AM
Re: oracle db on SAN (EVA)
Our policy is 5 Go per DBF (on an EMC DMX200 SAN.)
The db block size and OS size have been subject to various discution and documentation. As for the size of the datafiles, is there any Oracle recommandation on that ?
Since the IO load is spread on various disks, with the abstration layer of the volume manager product, does it really matter ?
The maxime filesize on HP with Oracle Block size of 8k, is 4194303 * 8k = 34gigs.
Filesize Limits for HPUX (Note:62407.1)
Cheers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2004 02:43 AM
тАО04-06-2004 02:43 AM
SolutionLike Jean-Luc says, the dbf files already have a given size. Just move (copy) them over and be happy? Or were you planning on a full export - create initial db - import for the move?
> to small will generate alot of files and more waist of space
Nah, too small just give an annoying amount of files to think about, report in statspack and so on. Waste of space is no serious concern.
> To big will slow down the restore procedures
Nah, there is no such thing as 'too big'.
What is your datarate expectation? 50MB/sec? 100MB/sec? if so 4GB will take 40 second, 8GB a minute or two. For many installations that is not significant.
You have to move the data anyway, all of it.
So whether you have 20 times 2GB or 2 times 20 GB is not going to matter much! It is only a management/scripting issue.
I sometimes keep my dbf files a little smaller (like only 10GB) to be able to copy several in parallel. But with EVA's even that is of minor importance. Since the EVA will engage lots of disks behind a lun, you only need a few concurrent stream to push the IO subsystem to high datarates (like 100MB/sec. We get 350MB per-second-per-EVA for carefully layed out connections).
At those datarates, a single 10GB file will take 2 minutes or so.
Once you have your EVA's connected I STRONGLY recommend verifying the IO throughput potential. Preferably with a dedicated tool (HP internally we use diskbench, and dt), be a couple of dd scripts will do the job too.
hth,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2004 04:39 PM
тАО04-06-2004 04:39 PM
Re: oracle db on SAN (EVA)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2004 05:14 PM
тАО04-06-2004 05:14 PM
Re: oracle db on SAN (EVA)
I am interested to learn to what extent HP is involved with the migration. Did the customer request help? Did HP propose? Are they ssing a service/consultancy or the regular DBA(s) and SSys Admin(s)? Time window? Test runs? Things along those lines.
I'd much appreciate a short Email to me. Mostly out of personal curiosity, and a little because I sit next to, and occasionally work with, folks that facilitate migrations.
Thanks!
hein at hp dot com.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-06-2004 08:15 PM
тАО04-06-2004 08:15 PM
Re: oracle db on SAN (EVA)
Does the EVA provide u fibre connectivity or is it SCSI?
If its fibre i dont think u should bother abt the speed as i have mostly 5GB datafiles and the read write is superb.
Regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-07-2004 12:22 AM
тАО04-07-2004 12:22 AM
Re: oracle db on SAN (EVA)
Thise max throughput requires a minimum of 2 HBAs in your servers and clever zoning / device selection to spread the load over the HBA's.
Hein.