3 disks in ONE volume or 3 vols for each disk ?

List,
i have been asked to suggest the placement of datafiles. on solaris. They have already created the volumes. For datafiles there's a big volume of 27GB, there are 3 Hdisks in that volume. I asked them to give me FIVE separate volumes to place the datafiles, but they say that using one big volume will strip the data and will be more faster etc...
my question is... how will be identify a hot block/table on ONE big volume ?

as we dont have any control where our datafile is place , right ? and we will NOT have the option of moving the file also ..

so..which one is better.. one BIG vol. or 3 small volumes mapping directly to
each hdisks.

TIA Rahul

 From: John Dunn <john.dunn_at_sefas.co.uk>  Date: Tue, 12 Sep 2000 11:59:15 +0100
 Subject: Dump table to MS ACCESS, then reload

I'm sure this has been asked before...but is there a quick way to output the data from one table to a format that can be loaded into ACCESS?

John  

 From: "K Gopalakrishnan" <kaygopal_at_yahoo.com>  Date: Tue, 12 Sep 2000 16:26:35 +0100
 Subject: Re: 3 disks in ONE volume or 3 vols for each disk ?

Hi !

I guess you are talking about RAID05 (or RAID 0) ? In anycase you don't have control over datafile placements.

In this case your asumption is right and if you have only these three disks (and if you place your redologs on that) the database will be :)

But coming back to identifying the hot table is not that difficult (you can look for dbfile_scattered/sequential read stats). Tuning is almost impossible in your case.

Regards,
K Gopalakrishnan
Bangalore, INDIA

• Original Message ----- From: Rahul <rahul_at_ratelindo.co.id>