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