topic Re: oracle db on SAN (EVA) in Operating System - HP-UX

oracle db on SAN (EVA)

Morten Kristiansen — Tue, 06 Apr 2004 06:05:26 GMT

Hi,

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.

Re: oracle db on SAN (EVA)

Printaporn_1 — Tue, 06 Apr 2004 06:10:56 GMT

almost of my dbfile size is 3GB.
what is the most performance boost up is try to minimize full table scan.

Re: oracle db on SAN (EVA)

Jean-Luc Oudart — Tue, 06 Apr 2004 09:00:51 GMT

If the databases exist already on direct attached disksystem, you will move to the SAN and this won't change their size !
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

Re: oracle db on SAN (EVA)

Nicolas Dumeige — Tue, 06 Apr 2004 09:19:48 GMT

Hello

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

Re: oracle db on SAN (EVA)

Hein van den Heuvel — Tue, 06 Apr 2004 09:43:45 GMT

Like 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.

Re: oracle db on SAN (EVA)

Morten Kristiansen — Tue, 06 Apr 2004 23:39:23 GMT

Sorry guys, forgot to tell you that we are moving from a tru64 platform using advanced FS, to a HP-UX platform using Veritas FS. So copying the database files is no issue. It have to be done by export/import. We are using RMAN backup utilities together with Legato.

Re: oracle db on SAN (EVA)

Hein van den Heuvel — Wed, 07 Apr 2004 00:14:04 GMT

Morten,
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.

Re: oracle db on SAN (EVA)

Syed Shaffat Ali — Wed, 07 Apr 2004 03:15:32 GMT

Hi!

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.

Re: oracle db on SAN (EVA)

Hein van den Heuvel — Wed, 07 Apr 2004 07:22:46 GMT

The EVA typically has 4 Fibre connections, and as I wrote before can deliver 350+ MB/sec when there is enough concurrent activity and they those 4 connections are all in use.
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.