LINUX
Next Entries »Linux vs. Oracle Tuning, Error : ORA-00845: MEMORY_TARGET not supported on this system
Friday, June 5th, 2009The ORA-00845:can arises for the following two reasons on linux system. 1)If the shared memory which is mapped to /dev/shm directory is less than the size of MEMORY_TARGET or MEMORY_MAX_TARGET. or, 2)If the shared memory is not mapped to /dev/shm directory. Make sure /dev/shm is properly mounted. You can see it by, df -h Filesystem [...]
Linux Oracle tuning parameter : Message queues
Friday, June 5th, 2009To view current settings, run command: more /proc/sys/kernel/msgmni more /proc/sys/kernel/msgmax To set it to a new value for this running session, which takes effect immediately, run command: echo 2048 > /proc/sys/kernel/msgmni echo 64000 > /proc/sys/kernel/msgmax
Linux Oracle tuning parameter : shmmax and shmall
Friday, June 5th, 2009maximum amount of memory = shmall * pagesize where pagesize = getconf PAGE_SIZE and shmall = cat /proc/sys/kernel/shmall
Linux Oracle tuning parameter : Semaphores
Friday, June 5th, 2009To view current settings, run command: more /proc/sys/kernel/sem 250 32000 32 1024 To set it to a new value for this running session, which takes effect immediately, run command: echo 500 512000 64 2048 > /proc/sys/kernel/sem Parameters meaning: SEMMSL – semaphores per ID SEMMNS – (SEMMNI*SEMMSL) max semaphores in system SEMOPM – max operations per [...]
Linux Oracle tuning parameter : Shared Memory
Friday, June 5th, 2009To view current settings, run command: more /proc/sys/kernel/shmmax To set it to a new value for this running session, which takes effect immediately, run command: echo 268435456 > /proc/sys/kernel/shmmax To set it to a new value permanently (so it survives reboots), modify the sysctl.conf file: … kernel.shmmax = 268435456
Cron – Zeitsteuerung unter Linux
Thursday, June 4th, 2009Kommando : crontab -e eingiben. Wenn der Editor nicht passt, dann export EDITOR=emacs eingeben Syntax : MINUTE STUNDE TAG MONAT WOCHENTAG BEFEHL dabei bedeuten: Minute, zu der das Skript ausgefuehrt werden soll. (Wertebereich: 0-59, *)
Next Entries »