Hi,

OK lets see how many disk do wee need for optimum performance:

1. Swap space
2. Operating system
3. redologs
4. system tables
5. user tables
6. user indexes
7. temporary tablespace

to get even more performance

async i/o, raw devices, how much channels for the controllers.

If you are finished you deserve a masters degree ;-) ...

regards,

Toni

Am 29.05.2006 um 15:29 schrieb Rami Aubourg-Kaires:

>
>> and what exactly will this help regarding performance?
>> (this is urban legend)
>
> A flamebaiter on the list? ;-)
>
> Seriously, depending on the number of indexes and the speed of your
> disk controller vs. the speed of your disks, you can get a 50%
> increase in write speeds.
>
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> For additional commands, email: suse-oracle-help@(protected)
> Please see http://www.suse.com/oracle/ before posting
>

--
+-----------------------------------------------------------------+
| Anton Dischner, Unix admin, Oracle-DBA   Phone: +49 89 70953202|
| Institut fuer Klinische Chemie        Fax : +49 89 70958888|
| Klinikum Grosshadern               Home : +49 89 69708766|
| Ludwig Maximilians Universitaet Muenchen Mobil: +49 172 8388880|
| 81366 Muenchen Germany                            |
| Marchioninistr. 15   Anton.Dischner"at"med.uni-muenchen.de   |
+-----------------------------------------------------------------+



--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting