Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚ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
      ×¢Ò⣺ÈçÒâÉèÖôíÎó°²×°¹ý³ÌÖлá³öÏÖ´íÎóÌáʾ£¬°´ÌáʾÐ޸ļ´¿É!


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

Oracle High Water Mask

High Water Mask£¨×î¸ßˮλÏߣ¬ºÇºÇ£©ÒÔϼò³ÆHWM
deleteÃüÁî²»Ó°Ïì±í×ÔÉíµÄHWM£¬¼´±íÖеÄÇø¿é»áËæ×ÅÊý¾ÝÁ¿µÄÔö´ó¶øÔö´ó£¬µ«É¾³ýÊý¾Ýʱ£¬
Çø¿é²¢²»»á¼õÉÙ£¬µ±²éѯʱ£¬»á°´ÕÕHWMµÄ±ê׼ȥɨÃè±í£¬¼´Ê¹Ê¹ÓÃdelete½«±íÊý¾ÝÇå¿Õ£¬²éѯʱ£¬
ÒÀ¾É»áɨÃèHWMµÄÇø¿é£¬²éѯËÙ¶ÈÒ²¾ÍºÍûʹÓÃdeleteÃüÁî֮ǰÊÇÒ»ÑùµÄ£¬¶øtruncate¿ÉÒÔ½ ......

WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí


 WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí 
 
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
¼ÒÀïÓÃÀ´µĄ̈ʽ»úÉÏ×°Á˸öWINDOWSϵÄORACLE 10G,ºÃ¾ÃûÓÃÁË£¬½ñÌì´ò¿ª´òËãÓÃһϣ¬Æô¶¯Êý¾Ý¿â£¬Æô¶¯ÕìÌý£¬¿´×źÜÕý³££¬µ«ÊÇÔÚ¿Í»§¶ËµÄTNSPING
C:\>tnsping homedb
TNS Ping Utility for 32-bit Window ......

ͨ¹ý´´½¨ÐòÁÐÀ´ÊµÏÖORACLE SEQUENCEµÄ¼òµ¥½éÉÜ

ÔÚoracleÖÐsequence¾ÍÊÇËùνµÄÐòÁкţ¬Ã¿´ÎÈ¡µÄʱºòËü»á×Ô¶¯Ôö¼Ó£¬Ò»°ãÓÃÔÚÐèÒª°´ÐòÁкÅÅÅÐòµÄµØ·½¡£
1¡¢Create Sequence
ÄãÊ×ÏÈÒªÓÐCREATE SEQUENCE»òÕßCREATE ANY SEQUENCEȨÏÞ£¬
CREATE SEQUENCE emp_sequence
INCREMENT BY 1 -- ÿ´Î¼Ó¼¸¸ö
START WITH 1 -- ´Ó1¿ªÊ¼¼ÆÊý
NOMAXVALUE -- ²»ÉèÖÃ×î´óÖµ
NOCY ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ