Oracle
« Previous Entries Next Entries »Codebeispiel Oracle : Anzahl doppelter Datensätze
Friday, June 12th, 2009select wp_id, count (*) as anzahl from tmp_Kurse group by wp_id having count(*) >1;
SqlDeveloper – Keyboard problems
Friday, June 12th, 2009Can ‘t use some keys like “del,return,arrows”. If they worked before, something got deconfigured (happens sometimes, but noone knows why or how). To restore them: Preferences – Accelerators – Load Preset – Default.
Linux Oracle tuning parameter : Shutdown GUI
Friday, June 5th, 2009Modify the ‘inittab’ file to set boot level as 3:
Linux Oracle tuning parameter : Disable Unnecessary Daemons
Friday, June 5th, 2009/sbin/chkconfig –levels 2345 sendmail off /sbin/chkconfig sendmail off
Linux Oracle tuning parameter : Tune TCP
Friday, June 5th, 2009To view current TCP settings, run command: sysctl net.ipv4.tcp_keepalive_time net.ipv4.tcp_keepalive_time = 7200 // 2 hours where net.ipv4.tcp_keepalive_time is a TCP tuning parameter. To set a TCP parameter to a value, run command: sysctl -w net.ipv4.tcp_keepalive_time=1800
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 [...]
« Previous Entries Next Entries »