← Back to team overview

sslug-teknik team mailing list archive

Re: Optimering af oracle

 


MONZ wrote:

> Lars Brandi Jensen wrote:
> > Er der nogen der kender nogle gode dokumenter eller har tips til tuning
> > af oracle på linux ?. Jeg synes den er lidt sløv på min installation !.
>
> Udover tuning kan det måske være interessant at kigge på 'scu' til at
> ændre blokstørrelsen på disken. Der var en god diskussion på linux-scsi
> for 1-2 måneder siden; omkring 4K var vist ret optimalt til bl.a.
> databaser.
>
> --------
>
> The Scu kit can be found on my external web page at URL:
> http://www.bit-net.com/~rmiller/scu.html
>
> What's in it for you is more disk space - there's likely to be a gap of
> around 100 bytes between sectors.
>
> In my experience with mainframe drives (quite some years ago) optimum
> space
> usage was achieved at around 4K blocks - it varies a little with drive
> characteristics.
>
> --------
>
> Hi John,
>         Yep you certainly get more capacity, and I believe someone
> told me you should get better performance too.  I tried a 4K sector
> size, and see an increase of 99.22MB (base 2) on a 2GB drive.  I
> was able to do I/O to the disk after rebooting, which flushed the
> stale sector size.  I'm running a 2.2.16-22 kernel (RH 7.0).
>
> scu> sho capacity
>
> Disk Capacity Information:
>
>                       Maximum Capacity: 4110480 (2007.070 megabytes)
>                           Block Length: 512
>
> scu> set device block 4096
> scu> format

Lige en gammel tråd jeg tager op igen : Den sidste scu> format renser vel
disken totalt, ikke ?!.

Lars



References