Hi Leo,
i recently installed 2 servers Oracle 10.1.0.5 SLES9 SP3, 4GB Ram,
2*150 GB 15k discs.
One of them i accidentically put the indexes onto the first disk.
Bulk-Insert performance went horrible.
kind regards,
Toni
Am 29.05.2006 um 13:29 schrieb Leo Mannhart:
>
>>> One internal SCSI Disk (80GB)
>>> ...
>>> What else can i do in order to squeeze speed to oracle/sles9 ??
>
>> Buy a second disk. Separate indexes from other database data.
>
> and what exactly will this help regarding performance?
> (this is urban legend)
> Oracle is reading either an index block or a data block from an
> object at a time. it will/can not read both types of block at the
> same time. Isn't it most of the time the case that first will be
> read the index block and then the data block? So Oracle just reads
> one disk block after the other and therefore it doesn't matter
> where the disk block resides.
>
> You could separate redo-logs from other files. You could generate a
> statspack report for the time the application is running and then
> distribute the files according the physical reads/writes
>
> [snip]
>
> Cheers
> Leo
>
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> For additional commands, email: suse-oracle-help@(protected)
> Please see http://www.suse.com/oracle/ before posting
>
>
>
> --
> 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
