ÓÉ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
Ïà¹ØÎĵµ£º
for example:
15:18:59 SQL> create table t1 (a int, b int);
±íÒÑ´´½¨¡£
ÒÑÓÃʱ¼ä: 00: 00: 00.15
......
1.
´íÎóÌáʾ£ºORA-12545:ÒòÄ¿±êÖ÷»ú»ò¶ÔÏó²»´æÔÚ,Á¬½Óʧ°Ü.
´íÎóÖ¢×´£ºÐ½¨µÄÊý¾Ý¿âÔÚOEM¿ØÖÆÌ¨ÎÞ·¨ÏÔʾ£¨sysmanÓû§µÇ½£©£¬¶ÀÁ¢Æô¶¯Ä£Ê½¿ÉÒÔÕÒµ½£¬µ«ÎÞ·¨µÇ½£¬³öÏÖÈçÉÏ´íÎó¡£
½â¾ö°ì·¨£ºÐÞ¸Äoracle°²×°Ä¿Â¼Ï£¨oracle\ora90\network\ADMIN£©µÄtnsnames.oraÎļþ£¬½«µ±Ç°Êý¾Ý¿âÌí¼Óµ½¼àÌý¶ÔÏóÖС£ÐÞ¸ÄÖ®ºó£¬¿ÉÒÔÔÚ¶ÀÁ¢Ä ......
1.¸ü¸Ä¹éµµÂ·¾¶
ÔÚORACLE10GÖУ¬Ä¬ÈϵĹ鵵·¾¶Îª$ORACLE_BASE/flash_recovery_area¡£¶ÔÓÚÕâ¸ö·¾¶£¬
ORACLEÓÐÒ»¸öÏÞÖÆ£¬¾ÍÊÇĬÈÏÖ»ÄÜÓÐ2GµÄ¿Õ¼ä¸ø¹éµµÈÕ־ʹÓ㬿ÉÒÔʹÓÃÏÂÃæÁ½¸öSQLÓï¾äÈ¥²é¿´ËüµÄÏÞÖÆ
1. select * from v$recovery_file_dest;
sql >show parameter db_recovery_file_dest(Õâ¸ö¸üÓѺÃÖ±¹ÛһЩ)
µ± ......
¡¶1¡·DDLÓï¾ä(Êý¾Ý¶¨ÒåÓïÑÔ) Data Define Language
create
alter
drop
truncate ¿ªÍ·µÄÓï¾ä truncate table <±íÃû>
ÌØµã:<1>½¨Á¢ºÍÐÞ¸ÄÊý¾Ý¶ÔÏó
&nb ......
×î½üÏîÄ¿½ø¶È±È½Ï»ºÂý£¬³õ²½Ñо¿ÁËÒ»ÏÂOracleµÄ´æ´¢¹ý³Ì£¬½«´úÂëÌù³öÀ´¡£
Ê×ÏÈÏÈÌù³öÀ´OracleµÄ·ÖÒ³·ÖÒ³´æ´¢¹ý³Ì´úÂë°É¡£
1.ÕâÊǰüµÄ´úÂë
create or replace package DB_Oper is
-- Author : LIUBING
-- Created : 2009-10-28 15:01:30
-- Purpose : ²âÊÔOracleµ ......