CentOS5.2ÉÏ°²×°Oracle 10g 10.0.2.1.0
×¢Ò⣺ΪSWAP·ÖÅäµÄ¿Õ¼äÒª³¬¹ý1G£¬Òª²»È»ºóÃæ×°Oralce»áÒòΪ¿Õ¼ä²»×ã¶øÎÞ·¨°²×°¡£²¢ÇÒÒª¹Ø±Õ·À»ðǽ£¬¹Ø±ÕSELIINUX
ÐÞ¸ÄhostÎļþ
Hosts File
# vi /etc/hosts
192.168.10.10 oracle oracle.localdomain oracle
127.0.0.1 oracle localhost.localdomain localhost
×¢Ò⣺ÄãÒª°Ñ192.168.10.10¸Ä³ÉÄã×Ô¼ºµÄIP£¬ÎÒÕâÀïÖ»ÊÇдÎÒ±¾»úµÄIPµÄ¡£
ÉèÖÃÄں˲ÎÊý
# vi /etc/sysctl.conf
ÔÚÐÐÄ©Ìí¼ÓÒÔÏÂÄÚÈÝ
#use for oracle
#kernel.shmall = 2097152
#kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
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
ÔÙÔËÐÐsysctl -pÓ¦ÓÃÒÔÉϲÎÊý
# /sbin/sysctl -p
ÉèÖÃ×î´ó´ò¿ªÎļþÊý
# vi /etc/security/limits.conf
ÔÚÐÐÄ©Ìí¼ÓÒÔÏÂÄÚÈÝ
#use for oracle
* soft nofile 65536
* hard nofile 65536
ÉèÖûỰ
# vi/etc/pam.d/login
ÐÐÄ©Ìí¼ÓÒÔÏÂÄÚÈÝ
sessionrequired /lib/security/pam_limits.so
²éѯËùÐè°²×°°üÊÇ·ñÍêÕû
ÒÔrootÓû§ÔÚÖÕ¶ËÖÐÖ´ÐÐÒÔÏÂÃüÁ
rpm -q gcc make binutils openmotif setarch compat-db compat-gcc compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel
Èç¹ûûÓа²×°ÕâЩ°üµÄ»°£¬¿ÉÒÔÔÚCentOS°²×°¹âÅ̵ÄCentOSĿ¼ÏÂÕÒµ½ÏàÓ¦µÄrmpÎļþÀ´°²×°£¬Èç¹ûÄãµÄ·þÎñÆ÷¿ÉÒÔÁªÍøµÄ»°£¬Ò²¿ÉÒÔͨ¹ýyumµÄ·½Ê½ÏÂÔØ°²×°£¬ÔÚÖÕ¶ËÖÐÖ´ÐÐÒÔÏÂÃüÁ
# yum -y install setarch-2*
# yum -y install make-3*
# yum -y install glibc-2*
# yum -y install libaio-0*
# yum -y install compat-libstdc++-33-3*
# yum -y install compat-gcc-34-3*
# yum -y install compat-gcc-34-c++-3*
# yum -y install gcc-4*
# yum -y install libXp-1*
# yum -y install openmotif-2*
# yum -y install compat-db-4*
°´ÃüÁîÌáʾµÄÏÂÔØ°²×°£¬ËùÐèµÄʱ¼äÈ¡¾öÓÚÄãµÄÍøËÙ¡£Èç¹û²»ÄÜÉÏÍøÔò¿ÉÒÔ´Ó¹âÅÌ°²×°¾ßÌåµÄ°²×°·½·¨ÊÇÏȹÒÔعâÇýʹÓà mount /dev/cdrom /media È»ºócd /media ¾Í¿ÉÒÔ½øÈë¹âÅÌĿ¼ÁË¡£ÔÙʹÓÃrpm -ivh xxx.rpm¸ñʽÀ´°²×°¡££¨×¢ÒâXXXΪÄãÒª°²×°µÄ°²×°°üÃû×Ö£©
¿ÉÄÜ°²×°ÍêÁËÒÔºóÓÃÉÏÊöÃüÁî²é¿´»¹ÊÇ»á³öÏÖijЩ°üûÓа²×°µÄÐÅÏ¢£¬Õâ¸ö²»ÓÃÀí»á£¬¾Ý˵ÊÇrp
Ïà¹ØÎĵµ£º
Oracle ÏòÒ»¸ö±íÖвåÈëÊý¾ÝµÄÁ½ÖÖ·½Ê½£º
Conventional Insert Operations£º´«Í³²åÈë»áÓÅÏÈʹÓøßˮλ֮Ï£¬»á±£Ö¤Êý¾ÝÓ¦ÓÃÍêÕûÐÔ£º¸ßˮλ֮ÏÂÊÇÖ¸£ºÉ¾³ýÖ®ºóµÄÊ£Óà¿Õ¼ä£¬¸ßˮλ֮ÉÏÊÇÖ¸£º´ÓÀ´Ã»ÓÐÓùýµÄ´¦Å®¿é¡£
Direct-path Insert Operatio ......
1. ϵͳÅäÖùý³Ì
2.1. oracle°²×°Ìõ¼þ¼ì²é
2.1.1. Ó²¼þ¼ì²é
¼ì²éÓ²¼þÇé¿öÊÇ·ñ·ûºÏoracle 10g µÄ°²×°ÒªÇó¡£ÒÔrootµÇ¼ϵͳ£¬ÓÃϱíÃüÁîÊä³öµÄÖµÓ¦´óÓÚ»òµÈÓÚ½¨ÒéÖµ¡£
¼ì²éÏîÄ¿
ÃüÁî ......
OracleÖÐstart with...connect by prior×Ó¾äÓ÷¨
connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ ......
Ç¿ÖÆÇл»ÖØ×öÈÕÖ¾
ALTER SYSTEM SWITCH LOGFILE; Ç¿ÖƲúÉú¼ì²éµã
ALTER SYSTEM CHECKPOINT; ¼ä½Ó²úÉú¼ì²éµã(É趨ʵÀý»Ö¸´Ê±¼ä²»³¬¹ýmmÃë,Ò༴ִÐмì²éµãÖ®ºóÔËÐг¬¹ýÕâ¸öʱ¼ä¾ÍÔÙ´ÎÖ´Ðмì²éµã)
ALTER SYSTEM SET FAST_START_MTTR_TARGET = ÃëÊý; »ñÈ¡ÖØ×öÈÕÖ¾ÎļþÐÅÏ¢
SELECT group#, ......