OracleÎﻯÊÓͼ
OracleµÄÎﻯÊÓͼÌṩÁËÇ¿´óµÄ¹¦ÄÜ£¬¿ÉÒÔÓÃÓÚÔ¤ÏȼÆËã²¢±£´æ±íÁ¬½Ó»ò¾Û¼¯µÈºÄʱ½Ï¶àµÄ²Ù×÷µÄ½á¹û£¬ÕâÑù£¬ÔÚÖ´Ðвéѯʱ£¬¾Í¿ÉÒÔ±ÜÃâ½øÐÐÕâЩºÄʱµÄ²Ù×÷£¬¶ø´Ó¿ìËٵĵõ½½á¹û¡£ÎﻯÊÓͼÓкܶ෽ÃæºÍË÷ÒýºÜÏàËÆ£ºÊ¹ÓÃÎﻯÊÓͼµÄÄ¿µÄÊÇΪÁËÌá¸ß²éѯÐÔÄÜ£»ÎﻯÊÓͼ¶ÔÓ¦ÓÃ͸Ã÷£¬Ôö¼ÓºÍɾ³ýÎﻯÊÓͼ²»»áÓ°ÏìÓ¦ÓóÌÐòÖÐSQLÓï¾äµÄÕýÈ·ÐÔºÍÓÐЧÐÔ£»ÎﻯÊÓͼÐèÒªÕ¼Óô洢¿Õ¼ä£»µ±»ù±í·¢Éú±ä»¯Ê±£¬ÎﻯÊÓͼҲӦµ±Ë¢Ð¡£
¡¡¡¡ÎﻯÊÓͼ¿ÉÒÔ·ÖΪÒÔÏÂÈýÖÖÀàÐÍ£º°üº¬¾Û¼¯µÄÎﻯÊÓͼ£»Ö»°üº¬Á¬½ÓµÄÎﻯÊÓͼ£»Ç¶Ì×ÎﻯÊÓͼ¡£ÈýÖÖÎﻯÊÓͼµÄ¿ìËÙˢеÄÏÞÖÆÌõ¼þÓкܴóÇø±ð£¬¶ø¶ÔÓÚÆäËû·½ÃæÔòÇø±ð²»´ó¡£´´½¨ÎﻯÊÓͼʱ¿ÉÒÔÖ¸¶¨¶àÖÖÑ¡ÏÏÂÃæ¶Ô¼¸ÖÖÖ÷ÒªµÄÑ¡Ôñ½øÐмòµ¥ËµÃ÷£º
¡¡¡¡´´½¨·½Ê½£¨Build Methods£©£º°üÀ¨BUILD IMMEDIATEºÍBUILD DEFERREDÁ½ÖÖ¡£BUILD IMMEDIATEÊÇÔÚ´´½¨ÎﻯÊÓͼµÄʱºò¾ÍÉú³ÉÊý¾Ý£¬¶øBUILD DEFERREDÔòÔÚ´´½¨Ê±²»Éú³ÉÊý¾Ý£¬ÒÔºó¸ù¾ÝÐèÒªÔÚÉú³ÉÊý¾Ý¡£Ä¬ÈÏΪBUILD IMMEDIATE¡£
¡¡¡¡²éѯÖØд£¨Query Rewrite£©£º°üÀ¨ENABLE QUERY REWRITEºÍDISABLE QUERY REWRITEÁ½ÖÖ¡£·Ö±ðÖ¸³ö´´½¨µÄÎﻯÊÓͼÊÇ·ñÖ§³Ö²éѯÖØд¡£²éѯÖØдÊÇÖ¸µ±¶ÔÎﻯÊÓͼµÄ»ù±í½øÐвéѯʱ£¬Oracle»á×Ô¶¯ÅжÏÄÜ·ñͨ¹ý²éѯÎﻯÊÓͼÀ´µÃµ½½á¹û£¬Èç¹û¿ÉÒÔ£¬Ôò±ÜÃâÁ˾ۼ¯»òÁ¬½Ó²Ù×÷£¬¶øÖ±½Ó´ÓÒѾ¼ÆËãºÃµÄÎﻯÊÓͼÖжÁÈ¡Êý¾Ý¡£Ä¬ÈÏΪDISABLE QUERY REWRITE¡£
¡¡¡¡Ë¢Ð£¨Refresh£©£ºÖ¸µ±»ù±í·¢ÉúÁËDML²Ù×÷ºó£¬ÎﻯÊÓͼºÎʱ²ÉÓÃÄÄÖÖ·½Ê½ºÍ»ù±í½øÐÐͬ²½¡£Ë¢ÐµÄģʽÓÐÁ½ÖÖ£ºON DEMANDºÍON COMMIT¡£ON DEMANDÖ¸ÎﻯÊÓͼÔÚÓû§ÐèÒªµÄʱºò½øÐÐˢУ¬¿ÉÒÔÊÖ¹¤Í¨¹ýDBMS_MVIEW.REFRESHµÈ·½·¨À´½øÐÐˢУ¬Ò²¿ÉÒÔͨ¹ýJOB¶¨Ê±½øÐÐˢС£ON COMMITÖ¸³öÎﻯÊÓͼÔÚ¶Ô»ù±íµÄDML²Ù×÷Ìá½»µÄͬʱ½øÐÐˢС£Ë¢Ðµķ½·¨ÓÐËÄÖÖ£ºFAST¡¢COMPLETE¡¢FORCEºÍNEVER¡£FASTˢвÉÓÃÔöÁ¿Ë¢Ð£¬Ö»Ë¢ÐÂ×ÔÉÏ´ÎË¢ÐÂÒÔºó½øÐеÄÐ޸ġ£COMPLETEˢжÔÕû¸öÎﻯÊÓͼ½øÐÐÍêÈ«µÄˢС£Èç¹ûÑ¡ÔñFORCE·½Ê½£¬ÔòOracleÔÚË¢ÐÂʱ»áÈ¥ÅжÏÊÇ·ñ¿ÉÒÔ½øÐпìËÙˢУ¬Èç¹û¿ÉÒÔÔò²ÉÓÃFAST·½Ê½£¬·ñÔò²ÉÓÃCOMPLETEµÄ·½Ê½¡£NEVERÖ¸ÎﻯÊÓͼ²»½øÐÐÈκÎˢС£Ä¬ÈÏÖµÊÇFORCE ON DEMAND¡£
¡¡¡¡ÔÚ½¨Á¢ÎﻯÊÓͼµÄʱºò¿ÉÒÔÖ¸¶¨ORDER BYÓï¾ä£¬Ê¹Éú³ÉµÄÊý¾Ý°´ÕÕÒ»¶¨µÄ˳Ðò½øÐб£´æ¡£²»¹ýÕâ¸öÓï¾ä²»»áдÈëÎﻯÊÓͼµÄ¶¨ÒåÖУ¬¶øÇÒ¶ÔÒÔºóµÄË¢ÐÂÒ²ÎÞЧ¡£
¡¡¡¡ÎﻯÊÓͼÈÕÖ¾£ºÈç¹ûÐèÒª½øÐпìËÙˢУ¬ÔòÐèÒª½¨Á¢ÎﻯÊÓͼÈÕÖ¾¡£ÎﻯÊÓͼÈÕÖ¾¸ù¾Ý²»Í¬ÎﻯÊÓͼµÄ¿ìËÙË¢Ð
Ïà¹ØÎĵµ£º
×÷Õß:Ñî´óÓÑ,Óà´¨ ²âÊÔÔ±:Íõ½¡
¿ª·¢¹¤¾ß:Oracle Jdeveloper 10131
ÈíÓ²¼þ»·¾³:
²Ù×÷ϵͳlinux redhat 3.0 Êý¾Ý¿âΪOracle 10G 10.0.2
Ó¦Ó÷þÎñÆ÷ΪSOA Application Server 10131
¿ª·¢ÓïÑÔ:java
¹ØÓÚÌåϵ½á¹¹,˵¶àÁËÒ²ÈÃÈ˾õµÃÔÎ.ÎÒÖ±½ÓʾÀýÒ»¸ö×ö·¨,ÖÁÓÚÀí½â,¾ÍÂýÂý¿´Êé°É!
²½Öè:
1.
´´ ......
Ò»¡¢Ê¹ÓÃsrvctl¹ÜÀíRACÊý¾Ý¿â
[root@NODE01 bin]# pwd
/orac/crs/bin # srvctlÔÚ$CRS_HOME/binĿ¼Ï£¬Ëü¿ÉÒÔÔÚÈκνڵãÉÏά»¤¡£
[root@NODE01 bin]# ./srvctl
Usage: srvctl <command> <object> [<options>]
command: enable|disable|start|stop|relocate|status| ......
SQL> conn system/oracle
Connected.
SQL> create table scott.t1(id number primary key,name varchar2(10)); --´´½¨²âÊÔ±í
Table created.
SQL> select constraint_name,table_name,constraint_type, --²é¿´ÏàÓ¦ÍêÕûÐÔÔ¼ÊøµÄ״̬
2 status,deferrable,deferred,validated
3 fro ......
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.shmm ......