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

oracle install

1 ¡¢´´½¨Óû§ºÍ×é
 /usr/sbin/groupadd oinstall
 /usr/sbin/groupadd dba
 /usr/sbin/useradd -g oinstall -G dba oracle
2¡¢ÅäÖÃOSºËÐIJÎÊý
 1£©±à¼­Îļþ /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
 
2) ʹºËÐIJÎÊýÉúЧ:
 /sbin/sysctl -p
 
3¡¢ÉèÖÃoracleÓû§µÄshellÏÞÖÆÖµ
1£©Ìí¼ÓÒÔÏÂÐе½Îļþ /etc/security/limits.conf :
oracle           soft    nproc   2047
oracle           hard    nproc   16384
oracle           soft    nofile  1024
oracle           hard    nofile  65536
 
2£©Ìí¼ÓÒÔÏÂÐе½Îļþ /etc/pam.d/login file, if it does not already exist:
session    required     pam_limits.so
 
3£©Ìí¼ÓÒÔÏÂÐе½Îļþ /etc/profile £¨for bash):
      if [ $USER = "oracle" ]; then
              if [ $SHELL = "/bin/ksh" ]; then
                    ulimit -p 16384
                    ulimit -n 65536
              else
                    ulimit -u 16384 -n 65536
    &nbs


Ïà¹ØÎĵµ£º

oracle ³£Óú¯Êý

SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2.CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ× ......

JMS+Oracle Advanced Queue(AQ)Ó÷¨Êµ¼ù

×÷Õß:Ñî´óÓÑ,Óà´¨ ²âÊÔÔ±:Íõ½¡
 
¿ª·¢¹¤¾ß:Oracle Jdeveloper 10131
ÈíÓ²¼þ»·¾³:
²Ù×÷ϵͳlinux redhat 3.0 Êý¾Ý¿âΪOracle 10G 10.0.2
Ó¦Ó÷þÎñÆ÷ΪSOA Application Server 10131
¿ª·¢ÓïÑÔ:java
¹ØÓÚÌåϵ½á¹¹,˵¶àÁËÒ²ÈÃÈ˾õµÃÔÎ.ÎÒÖ±½ÓʾÀýÒ»¸ö×ö·¨,ÖÁÓÚÀí½â,¾ÍÂýÂý¿´Êé°É!
²½Öè:
1.   
´´ ......

ORACLE ROWID

Ò».rowid¼ò½é
rowid¾ÍÊÇΨһ±êÖ¾¼Ç¼ÎïÀíλÖõÄÒ»¸öid£¬ÔÚoracle 8°æ±¾ÒÔǰ£¬rowidÓÉfile#+block#+row#×é³É£¬Õ¼ÓÃ6¸öbytesµÄ¿Õ¼ä£¬10 bit µÄ file# £¬22bit µÄ block# £¬16 bit µÄ row#¡£
´Óoracle 8¿ªÊ¼rowid±ä³ÉÁËextend rowid£¬ÓÉdata_object_id#+rfile#+block#+row#×é³É£¬Õ¼ÓÃ10¸öbytesµÄ¿Õ¼ä£¬ 32bitµÄ data_object_ ......

½ñÌì×°ORACLE µÄµãµãµÎµÎ£¡

ËäÈ»ÒÔǰÓÃÁ˼¸ÄêµÄORACLE µÄpl/sql  µ«°²×°½ñÌ컹ÊǵÚÒ»´Î£º
1£º »¹ÊÇÏȲο¼Ò»ÏÂÍøÕ¾£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
  1. Oracle 10g windows ƽ̨ϰ²×°
¡¡¡¡ÏÂÔØµØÖ·£º  http://download.csdn.net/source/1850497¡¡¡¡
¡¡¡¡ÔÚÏß¹Û¿´µØÖ·£ºhttp://v.youku.com ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ