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
Ïà¹ØÎĵµ£º
ת×Ô£ºhttp://www.oracle.com/technology/obe/obe9ir2/obe-cnt/plsql/plsql.htm
¶¼Ëµ¶ÁÊé²»ÇóÉõ½âº¦ËÀÈË£¬Ò»µãÒ²²»´í£¬×î½üÎÒ´ÓÍøÉÏÌÔµ½¹ØÓÚORACLEÈçºÎ´ÓÊý¾Ý¿âĿ¼Ï¶ÁÎļþ£¬ÓÚÊǾÍÓÃÓÚÉú²úÁË£¬½á¹ûÉÏÁËÉú²ú£¬³ÌÐòËÀ»î¾ÍÊÇÅܲ»³öÀ´£¬ÔÒòÊÇÎÒÃǵķþÎñÆ÷×öÁËREC£¬Èç¹ûÔÚÁ½Ì¨»úÆ÷ÉÏÕÒÒ»¸öĿ¼ÄØ£¬ÒÔÇ°ÄØÔÚ×Ô¼ºµÄ³ÌÐòÀï°Ñ·¾ ......
Oracle°²×°Íêºó£¬ÆäÖÐÓÐÒ»¸öȱʡµÄÊý¾Ý¿â£¬³ýÁËÕâ¸öȱʡµÄÊý¾Ý¿âÍ⣬ÎÒÃÇ»¹¿ÉÒÔ´´½¨×Ô¼ºµÄÊý¾Ý¿â¡£
¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÎªÁ˱ÜÃâÂé·³£¬¿ÉÒÔÓÃ'Database Configuration Assistant'Ïòµ¼À´´´½¨Êý¾Ý¿â¡£
´´½¨ÍêÊý¾Ý¿âºó£¬²¢²»ÄÜÁ¢¼´ÔÚÊý¾Ý¿âÖн¨±í£¬±ØÐëÏÈ´´½¨¸ÃÊý¾Ý¿âµÄ ......
http://www.ej38.com/showinfo/Oracle-108709.html
Oracle 10g statisticÊý¾Ýͳ¼Æ,Oracle»á¸ù¾ÝÕâЩͳ¼ÆÐÅÏ¢À´¾ö¶¨ÊÇ×ßRBO(Rule-BasedOptimization)£¬»¹ÊÇ×ßCBO(Cost-BasedOptimization)£¬»áȥѡÔñÄÄÖÖÖ´Ðмƻ®¸ü»®Ëã,Ó°ÏìÊÇ·ñ×ßÏà¹ØµÄË÷ÒýµÈ.Èç¹ûÊÇCBOµÄ»°£¬ËüÒÀ¿¿×¼È·µÄ£¨»òÕß˵±È½Ï׼ȷµÄ£©Í³¼ÆÐÅÏ¢À´²úÉúÓÅ»¯µÄÖ ......
Redo Byte Address (RBA)
Recent entries in the redo thread of an Oracle instance are addressed using a 3-part redo byte address, or RBA. An RBA is comprised of
the log file sequence number (4 bytes)
the log file block number (4 bytes)
the byte offset into the block at which the redo record sta ......