sslug-teknik team mailing list archive

[ktk@xxxxxxxxxxx]

Hej lars,

Der er de sædvanlige:

1) Get the latest version of Linux. We ran into such horrible problems with Red Hat 6.0 and Oracle I still have nightmares. 6.2 works a lot better.
Redhat are now
           selling an 'oracle8i' tuned Linux version for $2100.
2) Increase your file limits. echo "16384" >/proc/sys/fs/file-max echo "49152" >/proc/sys/fs/inode-max ulimit
           -Hn 16384 (as root) ulimit -n 16384 (as your db user) From here, its standard db tuning:
3) Memory is a biggie. Make sure you have a ton. With Oracle I use the
           following rule of thumb: count the number of DIMM slots in your machine, multiply that by the largest DIMM size available e.g. 512Mb. You
should be able to
           scrape by on this.
4) Disks: the more the better. Use straight disks (no raid), Raid 0, raid 1, or raid 0+1 (depending on the level of safety you need), we use 0+1.
           Raid 5 has a write performance impact. The Oracle redo logs are a bottleneck. We write out two copies of our log to 2 different straight
disks for max
           performance.

Udover det, kan man optimere ved f.ex. at lave store blocke.. istedet for standard 8 bytes pr. block.. lav 64 bytes pr. block - giver en del disk
ydelse forbedring ved store filer.

Også kan man optimere oracle.. f.ex. roll-back logfilerne være store nok til at en enkelt transaktion kan holdes i en fil.. hvis de er for små, skal
der hele tiden skiftes fil..
 og det sløver f.ex. søgninger en del ned..

Er ikke Oracle haj.. kan ikke lige finde på andet.. er sikker på at Oracle har en "redbook" på emnet.

       .\|/.
       (o o)
--ooOo--(_)--oOoo------| This mail has been sent to you by: |----------

Klavs Klavsen, IT-coordinator and Systems Administrator at
Metropol Online - http://www.metropol.dk
Tlf. 33752700, Fax 33752720, Email ktk@xxxxxxxxxxx

Private Email klavs@xxxxxxxxxxx
  .oooO    Oooo.
__(   )___(   )_____This mail is based on 100% recycled bits_________
   \  (    ) /
    \ _)  (_/

Hej

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

Lars Brandi Jensen