¡¾×ª¡¿OracleÖеÄÓ²½âÎöÓëÈí½âÎö
OracleÖеÄSQLÔÚÖ´ÐÐ֮ǰ½øÐнâÎö£¬Ò»¸öÓ²½âÎö°üÀ¨ÏÂÃæµÄ²½Ö裺
¼ÓÔØµ½¹²Ïí³ØÖÐ - SQLÔ´´úÂë±»¼ÓÔØµ½ÄÚ´æÖС£
Óï·¨½âÎö - Oracle¼ì²éÓ﷨ƴд´íÎó¡£
ÓïÒå½âÎö - OracleÑéÖ¤À´×ÔÊý¾Ý×ÖµäµÄËùÓбíÃûºÍÁÐÃû²¢ÇÒÑéÖ¤ÄãÊÇ·ñÓÐȨ·ÃÎÊÕâЩÊý¾Ý¡£
²éѯת»» - Èç¹ûÔÊÐí(query_rewrite=true)£¬oracle½«°Ñ¸´ÔÓµÄSQLת»»ÎªµÈ¼ÛµÄ¼òµ¥ÐÎʽ¡£
ÓÅ»¯ - ¸ù¾ÝģʽµÄͳ¼ÆÐÅÏ¢´´½¨Ö´Ðмƻ®£¨ÔÚ10gÖлòÐí»áʹÓö¯Ì¬µÄÑù±¾Í³¼ÆÐÅÏ¢£©¡£
´´½¨¿ÉÖ´ÐÐÎļþ - Oracle´´½¨Ò»¸ö·þÎñÓÚSQL²éѯµÄ¡¢µ÷Óñ¾µØÎļþµÄ¿ÉÖ´ÐÐÎļþ¡£
OracleÌṩÁËshared_pool_size²ÎÊýÀ´»º´æSQL´Ó¶øÊ¹ÎÒÃDz»ÐèÒªÖØ¸´½âÎöSQL¡£µ«ÊÇ£¬Èç¹ûshared_pool_sizeÉèÖÃ̫С»òÕßÔÚ´úÂëÖÐʹÓÃÁË·ÇÖØÓõÄSQL£¨ÀýÈç°üº¬Ö±½ÓÁ¿where name="fred")£¬SQLÓï¾ä¿ÉÄÜ»á¹ýÆÚ¡£
ÔÚOracleÖÐÈí½âÎöºÍÓ²½âÎöµÄÇø±ðÊÇʲô£¿½ö½öÊÇÉÏÃæÓúìÉ«±êÃ÷µÄµÚÒ»²½¡£Ò²¾ÍÊÇ˵£¬Èí½âÎö²»ÐèÒªÖØÐÂ×°ÔØµ½¹²Ïí³Ø£¨ÒÔ¼°Ïà¹ØµÄÄÚ´æ·ÖÅ䣩¡£
ͨ³£ºÜ¸ßµÄ½âÎöµ÷ÓôÎÊý£¨>10/Ã룩±íÃ÷ÄãµÄϵͳÓдóÁ¿²»Í¬µÄSQLÓï¾ä£¬»òÕßÄãµÄSQLÓï¾äûÓб»ÖØÓã¨ÀýÈ磬ûÓÐʹÓð󶨱äÁ¿£©¡£
Ó²½âÎöÐèÒª°ÑSQLÓï¾ä¼ÓÔØµ½¹²Ïí³ØÖС£Ó²½âÎö±ÈÈí½âÎö²îºÜ¶à£¬ÒòΪËüÇ£Éæµ½¹²Ïí³ØÖÐÄÚ´æµÄ·ÖÅäºÍ¹ÜÀí¡£Ò»µ©±»¼ÓÔØ£¬SQL±ØÐëÍêÈ«ÖØÐ¼ì²éÓï·¨ºÍÓïÒåÒÔ¼°Éú³É¿ÉÖ´ÐÐÄ¿±ê¡£
Èç¹ûshared_pool_sizeÉèÖõÄ̫С»òÕßSQLÓï¾äûÓÐÖØÓã¬Ôò»á·¢Éú´óÁ¿µÄÓ²½âÎö¡£
ËùÒÔÒªÊʵ±µÄÉèÖù²Ïí³Ø´óС²¢ÇÒͨ¹ýÖ÷»ú±äÁ¿ÖØÓÃSQL¡£
±¾ÎÄת×Ô£ºhttp://blog.csdn.net/zjliu1984/archive/2009/07/01/4312333.aspx
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
ORACLE SQLÓÅ»¯
£¨1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom ×Ó¾äÖеıíÃû£¬from ×Ó¾äÖÐдÔÚ×îºóµÄ±í
(»ù´¡±ídriving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom ×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç
¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, ÄǾÍÐè ......