sslug-teknik team mailing list archive
-
sslug-teknik team
-
Mailing list archive
-
Message #34172
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