ÔÚFedora 10ÉÏ°²×°Oracle£¨10.2.0£©[³Ï®]
ÔÚFedora 10ÉÏ°²×°Oracle£¨10.2.0£©
ĬÈϵÄϵͳ²ÎÊýÏ£¬ÔÚFedora 10ÉÏÎÞ·¨°²×°Oracle£¬ÐèÒª½øÐÐÏÂÁÐÈô¸É´¦Àí£º
1. Ñé֤ϵͳҪÇó
ÒªÑé֤ϵͳÊÇ·ñÂú×ã Oracle 10g Êý¾Ý¿âµÄ×îµÍÒªÇó£¬ÒÔ root Óû§Éí·ÝµÇ¼²¢ÔËÐÐÒÔÏÂÃüÁî¡£
Òª²é¿´¿ÉÓà RAM ºÍ½»»»¿Õ¼ä´óС£¬ÔËÐÐÒÔÏÂÃüÁ
# grep MemTotal /proc/meminfo
MemTotal:512236 kB
# grep SwapTotal /proc/meminfo
SwapTotal:1574360 kB
ËùÐè×îС RAM Ϊ 512MB£¬¶øËùÐè×îС½»»»¿Õ¼äΪ 1GB¡£¶ÔÓÚ RAM СÓÚ»òµÈÓÚ 2GB µÄϵͳ£¬½»»»¿Õ¼äӦΪ RAM ÊýÁ¿µÄÁ½±¶£»¶ÔÓÚ RAM ´óÓÚ 2GB µÄϵͳ£¬½»»»¿Õ¼äӦΪ RAM ÊýÁ¿µÄÒ»µ½Á½±¶¡£ Oracle 10g Èí¼þ»¹ÐèÒª 2.5GB µÄ¿ÉÓôÅÅ̿ռ䣬¶øÊý¾Ý¿âÔòÁíÐè 1.2GB µÄ¿ÉÓôÅÅ̿ռ䡣/tmp Ŀ¼ÖÁÉÙÐèÒª 400MB µÄ¿ÉÓÿռ䡣Ҫ¼ì²éϵͳÉϵĿÉÓôÅÅ̿ռ䣬ÔËÐÐÒÔÏÂÃüÁ
# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 6.8G 1.3G 5.2G 20% /
/dev/sda1 99M 17M 77M 18% /boot
¸ÃʾÀý±íÃ÷£¬/tmp Ŀ¼ûÓÐ×Ô¼ºµÄÎļþϵͳ¡££¨¶Ô±¾Ö¸Ä϶øÑÔ£¬ËüÊǸùÎļþϵͳµÄÒ»²¿·Ö¡££©
2. ÐÞ¸ÄϵͳÄں˲ÎÊý¡£¼ÓÒÔϵÄÄÚÈݵ½Îļþ/etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
×¢Ò⣺ÈçÒâÉèÖôíÎó°²×°¹ý³ÌÖлá³öÏÖ´íÎóÌáʾ£¬°´ÌáʾÐ޸ļ´¿É!
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
High Water Mask£¨×î¸ßˮλÏߣ¬ºÇºÇ£©ÒÔϼò³ÆHWM
deleteÃüÁî²»Ó°Ïì±í×ÔÉíµÄHWM£¬¼´±íÖеÄÇø¿é»áËæ×ÅÊý¾ÝÁ¿µÄÔö´ó¶øÔö´ó£¬µ«É¾³ýÊý¾Ýʱ£¬
Çø¿é²¢²»»á¼õÉÙ£¬µ±²éѯʱ£¬»á°´ÕÕHWMµÄ±ê׼ȥɨÃè±í£¬¼´Ê¹Ê¹ÓÃdelete½«±íÊý¾ÝÇå¿Õ£¬²éѯʱ£¬
ÒÀ¾É»áɨÃèHWMµÄÇø¿é£¬²éѯËÙ¶ÈÒ²¾ÍºÍûʹÓÃdeleteÃüÁî֮ǰÊÇÒ»ÑùµÄ£¬¶øtruncate¿ÉÒÔ½ ......
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
¼ÒÀïÓÃÀ´µĄ̈ʽ»úÉÏ×°Á˸öWINDOWSϵÄORACLE 10G,ºÃ¾ÃûÓÃÁË£¬½ñÌì´ò¿ª´òËãÓÃһϣ¬Æô¶¯Êý¾Ý¿â£¬Æô¶¯ÕìÌý£¬¿´×źÜÕý³££¬µ«ÊÇÔÚ¿Í»§¶ËµÄTNSPING
C:\>tnsping homedb
TNS Ping Utility for 32-bit Window ......
ÔÚoracleÖÐsequence¾ÍÊÇËùνµÄÐòÁкţ¬Ã¿´ÎÈ¡µÄʱºòËü»á×Ô¶¯Ôö¼Ó£¬Ò»°ãÓÃÔÚÐèÒª°´ÐòÁкÅÅÅÐòµÄµØ·½¡£
1¡¢Create Sequence
ÄãÊ×ÏÈÒªÓÐCREATE SEQUENCE»òÕßCREATE ANY SEQUENCEȨÏÞ£¬
CREATE SEQUENCE emp_sequence
INCREMENT BY 1 -- ÿ´Î¼Ó¼¸¸ö
START WITH 1 -- ´Ó1¿ªÊ¼¼ÆÊý
NOMAXVALUE -- ²»ÉèÖÃ×î´óÖµ
NOCY ......