¡¾ÊÕ²ØÕûÀí¡¿OracleÊý¾Ý¿âÌåϵ¼Ü¹¹
ÔÎļûhttp://blog.csdn.net/kele1121/archive/2009/10/30/4742051.aspxÓëhttp://www.itpub.net/thread-1105403-1-1.html
Ëùν
Oracle
µÄÌåϵ¼Ü¹¹£¬ÊÇÖ¸
Oracle
Êý¾Ý¿â¹ÜÀíϵͳµÄµÄ×é³É²¿·ÖºÍÕâЩ×é³É²¿·ÖÖ®¼äµÄÏ໥¹ØÏµ£¬°üÀ¨
ÄÚ´æ½á¹¹¡¢ºǫ́½ø³Ì¡¢ÎïÀíÓëÂß¼½á¹¹µÈ¡£
Oracle
Êý¾Ý¿âµÄÌåϵºÜ¸´ÔÓ£¬¸´ÔÓµÄÔÒòÔÚÓÚËü×î´óÏ޶ȵĽÚÔ¼
Äڴ棬´ÓÉÏͼ¿ÉÒÔ¿´³ö£¬ËüÔÚÕûÌåÉÏ·ÖʵÀýºÍÊý¾Ý¿âÎļþÁ½²¿·Ö¡£
£¨
1
£©Ê×ÏÈÇø·ÖÒ»ÏÂÊý¾Ý¿âµÄʵÀý£¨
Instance
£©ºÍÊý¾Ý¿âÁ½¸ö¸ÅÄ
l
ORACLE
ʵÀý
=
½ø³Ì
+
½ø³ÌËùʹÓõÄÄÚ´æ
(SGA)
£¬ÊµÀýÊÇÒ»¸öÁÙʱÐԵĶ«Î÷£¬ÄãÒ²¿ÉÒÔÈÏΪËü´ú±íÁËÊý¾Ý¿âijһʱ¿ÌµÄ״̬£¡
l
Êý¾Ý¿â
=
ÖØ×öÎļþ
+
¿ØÖÆÎļþ
+
Êý¾ÝÎļþ
+
ÁÙʱÎļþ£¬Êý¾Ý¿âÊÇÓÀ¾ÃµÄ£¬ÊÇÒ»¸öÎļþµÄ¼¯ºÏ¡£
ORACLE
ʵÀýºÍÊý¾Ý¿âÖ®¼äµÄ¹ØÏµ
1.
ÁÙʱÐÔ
(instance)
ºÍÓÀ¾ÃÐÔ
(
Êý¾Ý¿â
)
2.
ʵÀý£¨
instance
£©¿ÉÒÔÔÚûÓÐÊý¾ÝÎļþµÄÇé¿öϵ¥¶ÀÆô¶¯
startup nomount ,
ͨ³£Ã»Ê²Ã´ÒâÒå
3.
Ò»¸öʵÀýÔÚÆäÉú´æÆÚÄÚÖ»ÄÜ×°ÔØ
(alter database mount)
ºÍ´ò¿ª
(alter database open)
Ò»¸öÊý¾Ý¿â
4.
Ò»¸öÊý¾Ý¿â¿É±»Ðí¶àʵÀýÍ¬Ê±×°ÔØºÍ´ò¿ª
(
¼´
RAC)
£¬
RAC
»·¾³ÖÐʵÀýµÄ×÷ÓÃÄܹ»µÃµ½³ä·ÖµÄÌåÏÖ
!
ÏÂÃæ¶ÔʵÀýºÍÊý¾Ý¿â×öÏêϸµÄÚ¹ÊÍ£º
ÔÚ
Oracle
ÁìÓòÖÐÓÐÁ½¸ö´ÊºÜÈÝÒ×»ìÏý£¬Õâ¾ÍÊÇ
“
ʵÀý
”
£¨
instance
£©ºÍ
“
Êý¾Ý¿â
”
£¨
database
£©¡£×÷Ϊ
Oracle
ÊõÓÕâÁ½¸ö´ÊµÄ¶¨ÒåÈçÏ£º
Êý¾Ý¿â
£¨
database
£©£ºÎïÀí²Ù×÷ϵͳÎļþ»ò
´ÅÅÌ
£¨
disk
£©µÄ¼¯ºÏ¡£Ê¹ÓÃ
Oracle 10g
µÄ×Ô¶¯´æ´¢¹ÜÀí£¨
Automatic Storage Management
£¬
ASM
£©»ò
RAW
·ÖÇøÊ±£¬Êý¾Ý¿â¿ÉÄܲ»×÷Ϊ²Ù×÷ϵͳÖе¥¶ÀµÄÎļþ£¬µ«¶¨ÒåÈÔÈ»²»±ä¡£
ʵÀý
£¨
instance
£©£ºÒ»×é
Oracle
ºǫ́½ø³Ì
/
Ïß³ÌÒÔ¼°Ò»¸ö¹²ÏíÄÚ´æÇø£¬ÕâЩÄÚ´æÓÉͬһ¸ö¼ÆËã»úÉÏÔËÐеÄÏß³Ì
/
½ø³ÌËù¹²Ïí¡£ÕâÀï¿ÉÒÔά»¤Ò×ʧµÄ¡¢·Ç³Ö¾ÃÐÔÄÚÈÝ£¨ÓÐЩ¿ÉÒÔË¢ÐÂÊä³öµ½´ÅÅÌ£©¡£¾ÍËãûÓдÅÅÌ´æ´¢£¬Êý¾Ý¿âʵÀýÒ²ÄÜ´æÔÚ¡£Ò²ÐíʵÀý²»ÄÜËãÊÇÊÀ½çÉÏ
Ïà¹ØÎĵµ£º
ÔÚÉÏÆªÎÄÕÂÀï“×ß½üOracleÊý¾Ý×Öµä--Êý¾Ý×Öµä±í”£¬ÎÒÃÇ̸µ½ÁËÊý¾Ý×Öµä¶ÔÓÚÎÒÃÇ×÷ΪDBA¶ÔÊý¾Ý¿âά»¤µÄÖØÒªÐÔ¡£Êý¾Ý¿âµÄ¶ÔÏóÐÅÏ¢£¬±ÈÈç±í£¬Óû§£¬´æ´¢¹ý³Ì£¬º¯Êý£¬ÊÓͼ£¬Ë÷ÒýµÈµÈ£¬ÕâЩ´æÔÚÔÚÊý¾Ý¿âÀïµÄ¶ÔÏóµÄÐÅÏ¢£¬¶¼ÊÇÔÚÊý¾Ý×Öµä±íÀï½øÐÐά»¤µÄ£¬ÎÒÃÇ¿ÉÒÔ½èÓÃһЩ±È½ÏºÃµÄOracle¿ª·¢¹¤¾ß±ÈÈçPLSQL dev»òÕß ......
select 'create sequence '||sequence_name||
' minvalue '||min_value||
' maxvalue '||max_value||
' start with '||last_number||
&n ......
ÔÚÊý¾Ý²Ö¿â»·¾³ÖУ¬ÎÒÃÇͨ³£ÀûÓÃÎﻯÊÓͼǿ´óµÄ²éÑ¯ÖØÐ´¹¦ÄÜÀ´ÌáÉýͳ¼Æ²éѯµÄÐÔÄÜ£¬µ«ÊÇÎﻯÊÓͼµÄ²éÑ¯ÖØÐ´¹¦ÄÜÓÐʱºòÎÞ·¨ÖÇÄܵØÅжϲéѯÖÐһЩÏà¹ØÁªµÄÌõ¼þ£¬ÒÔÖÁÓÚÓ°ÏìÐÔÄÜ¡£±ÈÈçÎÒÃÇÓÐÒ»ÕÅÏúÊÛ±ísales£¬ÓÃÓÚ´æ´¢¶©µ¥µÄÏêϸÐÅÏ¢£¬°üº¬½»Ò×ÈÕÆÚ¡¢¹Ë¿Í±àºÅºÍÏúÊÛÁ¿¡£ÎÒÃÇ´´½¨Ò»ÕÅÎﻯÊÓͼ£¬°´Ô´洢ÀÛ¼ÆÏúÁ¿ÐÅÏ¢£¬¼ ......
INºÍEXISTSÇø±ð
in ÊǰÑÍâ±íºÍÄÚ±í×÷hash join£¬¶øexistsÊǶÔÍâ±í×÷loop£¬Ã¿´ÎloopÔÙ¶ÔÄÚ±í½øÐвéѯ¡£
Ò»Ö±ÒÔÀ´ÈÏΪexists±ÈinЧÂʸߵÄ˵·¨ÊDz»×¼È·µÄ¡£
Èç¹û²éѯµÄÁ½¸ö±í´óСÏ൱£¬ÄÇôÓÃinºÍexists²î±ð²»´ó¡£
Èç¹ûÁ½¸ö±íÖÐÒ»¸ö½ÏС£¬Ò»¸öÊÇ´ó±í£¬Ôò×Ó²éѯ±í´óµÄÓÃexists£¬×Ó²éѯ±íСµÄÓÃin£º
ÀýÈ磺±íA£¨Ð¡±í£©£¬±íB ......
select trim(leading | trailing | both ' ' from ' abc d ') from dual;
È¥µô×Ö·û´® ' abc d ' µÄÇ°Ãæ/ºóÃæ/ǰºóµÄ¿Õ¸ñ
ÀàËÆº¯Êý£ºltrim, ......