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

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 PLSQL¶ÁÎļþ

ת×Ô£ºhttp://www.oracle.com/technology/obe/obe9ir2/obe-cnt/plsql/plsql.htm
¶¼Ëµ¶ÁÊé²»ÇóÉõ½âº¦ËÀÈË£¬Ò»µãÒ²²»´í£¬×î½üÎÒ´ÓÍøÉÏÌÔµ½¹ØÓÚORACLEÈçºÎ´ÓÊý¾Ý¿âĿ¼Ï¶ÁÎļþ£¬ÓÚÊǾÍÓÃÓÚÉú²úÁË£¬½á¹ûÉÏÁËÉú²ú£¬³ÌÐòËÀ»î¾ÍÊÇÅܲ»³öÀ´£¬Ô­ÒòÊÇÎÒÃǵķþÎñÆ÷×öÁËREC£¬Èç¹ûÔÚÁ½Ì¨»úÆ÷ÉÏÕÒÒ»¸öĿ¼ÄØ£¬ÒÔÇ°ÄØÔÚ×Ô¼ºµÄ³ÌÐòÀï°Ñ·¾ ......

oracle´´½¨±í¿Õ¼äºÍ±í

 Oracle°²×°Íêºó£¬ÆäÖÐÓÐÒ»¸öȱʡµÄÊý¾Ý¿â£¬³ýÁËÕâ¸öȱʡµÄÊý¾Ý¿âÍ⣬ÎÒÃÇ»¹¿ÉÒÔ´´½¨×Ô¼ºµÄÊý¾Ý¿â¡£
    ¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÎªÁ˱ÜÃâÂé·³£¬¿ÉÒÔÓÃ'Database Configuration Assistant'Ïòµ¼À´´´½¨Êý¾Ý¿â¡£
    ´´½¨ÍêÊý¾Ý¿âºó£¬²¢²»ÄÜÁ¢¼´ÔÚÊý¾Ý¿âÖн¨±í£¬±ØÐëÏÈ´´½¨¸ÃÊý¾Ý¿âµÄ ......

Oracle 10g StatisticÊý¾Ýͳ¼Æ

http://www.ej38.com/showinfo/Oracle-108709.html
 Oracle 10g statisticÊý¾Ýͳ¼Æ,Oracle»á¸ù¾ÝÕâЩͳ¼ÆÐÅÏ¢À´¾ö¶¨ÊÇ×ßRBO(Rule-BasedOptimization)£¬»¹ÊÇ×ßCBO(Cost-BasedOptimization)£¬»áȥѡÔñÄÄÖÖÖ´Ðмƻ®¸ü»®Ëã,Ó°ÏìÊÇ·ñ×ßÏà¹ØµÄË÷ÒýµÈ.Èç¹ûÊÇCBOµÄ»°£¬ËüÒÀ¿¿×¼È·µÄ£¨»òÕß˵±È½Ï׼ȷµÄ£©Í³¼ÆÐÅÏ¢À´²úÉúÓÅ»¯µÄÖ ......

ORACLE RBA(redo byte address)

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ