ÓÉdzÈëÉî½²½âOracleÊý¾Ý¿â½ø³ÌµÄÏà¹Ø¸ÅÄî
OracleÊý¾Ý¿â½ø³Ì¸ÅÊö£º
Database buffer cacheÖ÷ÒªÓÃÓÚ´æ´¢Êý¾ÝÎļþÖеÄÊý¾Ý¿é
Êý¾Ý¿â¸ßËÙ»º´æµÄÊý¾Ý¿éÊǸßËÙ»º´æÓëÊý¾ÝÎļþ½øÐÐÐÅÏ¢½»»»µÄ»ù±¾µ¥Î»¡£ÔÚOracleÊý¾Ý¿â8iÒÔÇ°,Êý¾Ý¿é´óСֻÓÐÒ»ÖÖ,¶øOracleÊý¾Ý¿â9iÒÔºóÖ§³Ö2K,4K,8KB,16KB¼°32KBÎåÖÖ¡£
ÓÃÃüÁîSQL>SHOW PARAMETER DB¿ÉÒÔÏÔʾµ±Ç°Êý¾Ý¿âµÄBUFFER CACHE
Êý¾Ý¿â»º´æºÍÌصãÈçÏÂ:
<1>.¸ù¾Ý×î½ü×îÉÙʹÓÃLRU.
<2>. ÓÉDB_BLOCK_SIZEÀ´Ö¸¶¨´óС.
<3>.ORACLEʹÓÃʱÊÇÒÔ¿é´óСΪµ¥Î»½øÐÐÊý¾Ý´æÈ¡µÄ.
»¹°üº¬ÒÔÏÂһЩ¶ÀÁ¢µÄ×Ó»º´æ:
<1>.DB_CACHE_SIZE.
<2>.DB_KEEP_CACHE_SIZE.
<3>.DB_RECYCLE_CACHE_SIZE.
×¢:¿ÉÒÔÓÃAlter system set db_cache_advice=on;ÉèÖóɸù¾ÝϵͳµÄ½¨ÒéÀ´Ö¸¶¨´óС¡£
REDO LOG FILEÖ÷ÒªÊÇÓÃÓÚÖØ×öÈÕÖ¾
ÓÃÃüÁîSQL>SHOW PARAMETER LOG_BUFFER¡£
SQL>ALTER SYSTEM SET LOG_BUFFER_SIZE=60M¡£
ÓÃÀ´ÏÔʾ»òÐÞ¸ÄÖØ×öÈÕÖ¾»º³åÇøµÄһЩÐÅÏ¢¡£
ÃüÁîSQL>achive log list ¿ÉÒԲ鿴Êý¾Ý¿âµ±Ç°µÄ¹éµµÄ£Ê½¡£
LARGE POOL:
ÓëJAVA POOLÒ»Ñù,¶¼ÊÇ×÷Ϊϵͳ¿ÉÑ¡µÄÄÚ´æ½á¹¹,ÓÉSGAÀ´ÅäÖá£
JAVA POOL:
µ±°²×°»òʹÓÃJAVAʱ²ÅÓõ½.
ORACLEÄÚ´æ½ø³Ì°üÀ¨Á½¸ö,Ò»¸öÊÇSGA,Ò»¸öÊÇPGA.
(1).SGAÔÚORACLEʵÀýÆô¶¯Ê±·ÖÅä,ÊÇORACLEʵÀýµÄÒ»¸ö»ù±¾×é¼þ.
(2).PGAÊÇÔÚµ±·þÎñÆ÷½ø³ÌÆô¶¯Ê±·ÖÅäµÄ.
½ø³Ì½á¹¹:
<1>.USER PROCESS.ÓÃÓÚÓû§ÓëORACLE SERVER½»»¥µÄ½ø³Ì.
USER PROCESS±ØÐëÓëORACLE½¨Á¢Á¬½Óºó²Å¿ÉʹÓÃ,²»¿ÉÓëORACLE SERVER½»»¥.
<2>.SERVER PROCESS.
SERVER PROCESSÔÚÓû§Óë·þÎñÖ®¼ä½¨Á¢Á¬½Óºó,ΪִÐÐÓû§ÃüÁîµÄÒ»¸ö½ø³Ì.
<3>.BACKGROUND PROCESS.
ºǫ́½ø³Ì:DATABASE WRITER (DBWn)ÓÃÀ´°ÑDATA BUFFER CACHEÖеÄÔàÊý¾Ýд»Øµ½Êý¾Ý¿âÖÐ.
(×¢:ÔàÊý¾ÝÊDZ»¸Ä±äµÄÊý¾Ý.)
ÔÚÒÔÏÂÇé¿öÏÂËü»áдÊý¾Ý¿â:
<1>.ÔÚ·¢ÉúCHECKPOINTͬ²½.
<2>.ÔàÊý¾Ý´ïµ½·§Öµ.
<3>.DATABASE BUFFER CACHE ×ÔÓÉ¿Õ¼äÌ«ÉÙÁË.
<4>.TIMEOUT (3ÃëÖÓ.)
<5>.RAC PING REQUEST.
<6>.TABLESPACE OFFLINE.
<7>.TABLESPACE READONLY.
<8>.TABLE DROP OR TABLE TRUNCATE (±íÊý¾ÝÇå¿Õ»ò±í½á¹¹É¾³ý).
<9>.TABLESPACE BEGIN BACKUP.
ÓÉSGA (°üº¬DATABASE BUFFER CACHE,BACKGROUND PROCESS)-----> [ DBWn ]----> {data fi
Ïà¹ØÎĵµ£º
Êý¾Ý¿âµÄÆô¶¯ÓÐÈýÖÖ£º
1
£º
startup nomount
ÕâÖÖ¹ý³ÌÓÖ³ÆΪ£º·Ç°²×°Æô¶¯
Æô¶¯¹ý³ÌΪ£ºÆô¶¯
oracle
ʵÀý£¬²»¼ÓÔØÊý¾Ý¿â£¬²»´ò¿ªÊý¾Ý¿â¡£ÔÚÕâ¸ö¹ý³ÌÖÐÖ»ÐèÒª
init.ora
³õʼ»¯²ÎÊýÎļþ£¬Öؽ¨¿ØÖÆÎļþ£¬¼´Æô¶¯ ......
1.1.1 OracleÎﻯÊÓͼ¼ò½é
1. ÎﻯÊÓͼ˵Ã÷
ÎﻯÊÓͼ (Materialized View)£¬ÔÚÒÔÇ°µÄOracle°æ±¾ÖгÆΪ¿ìÕÕ(Snapshot)¡£Oracle µÄÎﻯÊÓͼÌṩÁËÇ¿´óµÄ¹¦ÄÜ£¬¿ÉÒÔÓÃÓÚÔ¤ÏȼÆËã²¢±£´æ±íÁ¬½Ó»ò¾Û¼¯µÈºÄʱ½Ï¶àµÄ²Ù×÷µÄ½á¹û ......
oracleµÄÌåϵºÜÅÓ´ó£¬ÒªÑ§Ï°Ëü£¬Ê×ÏÈÒªÁ˽âoracleµÄ¿ò¼Ü¡£ÔÚÕâÀ¼òÒªµÄ½²Ò»ÏÂoracleµÄ¼Ü¹¹£¬ÈóõѧÕ߶ÔoracleÓÐÒ»¸öÕûÌåµÄÈÏʶ¡£
¡¡¡¡1¡¢ÎïÀí½á¹¹£¨ÓÉ¿ØÖÆÎļþ¡¢Êý¾ÝÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ¡¢²ÎÊýÎļþ¡¢¹éµµÎļþ¡¢ÃÜÂëÎļþ×é³É£©
¡¡¡¡¿ØÖÆÎļþ£º°üº¬Î¬»¤ºÍÑéÖ¤Êý¾Ý¿âÍêÕûÐԵıØÒªÐÅÏ¢¡¢ÀýÈ磬¿ØÖÆÎļþÓÃÓÚʶ±ðÊý¾ÝÎļ ......
Ò»¡¢PL/SQL³öÏÖµÄÄ¿µÄ
¡¡¡¡½á¹¹»¯²éѯÓïÑÔ(Structured Query
Language£¬¼ò³ÆSQL)ÊÇÓÃÀ´·ÃÎʹØϵÐÍÊý¾Ý¿âÒ»ÖÖͨÓÃÓïÑÔ£¬ËüÊôÓÚµÚËÄ´úÓïÑÔ£¨4GL£©£¬ÆäÖ´ÐÐÌصãÊǷǹý³Ì»¯£¬¼´²»ÓÃÖ¸Ã÷Ö´ÐеľßÌå·½·¨ºÍ;
¾¶£¬¶øÊǼòµ¥µÄµ÷ÓÃÏàÓ¦Óï¾äÀ´Ö±½ÓÈ¡µÃ½á¹û¼´¿É¡£ÏÔÈ»£¬ÕâÖÖ²»¹Ø×¢ÈκÎʵÏÖϸ½ÚµÄÓïÑÔ¶ÔÓÚ¿ª·¢ÕßÀ´ËµÓÐ׿«´óµÄ ......
¡¶1¡·DDLÓï¾ä(Êý¾Ý¶¨ÒåÓïÑÔ) Data Define Language
create
alter
drop
truncate ¿ªÍ·µÄÓï¾ä truncate table <±íÃû>
Ìصã:<1>½¨Á¢ºÍÐÞ¸ÄÊý¾Ý¶ÔÏó
&nb ......