ÓÉ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.Ê×ÏÈÐèÒª½¨Á¢plan table,·ñÔò²»ÄÜʹÓÃ
½¨Á¢·½·¨£º
$oracle\rdbms\adminÏÂÓиö
utlxplan.sql
ÆäÄÚÈÝΪ:
create table PLAN_TABLE (
statement_id varchar2(30),
timestamp date,
remarks varchar2(80),
operat ......
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Êý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý·½·¨£¬ËüÃÇ·Ö±ðÊǵ¼³ö£¯µ¼È루EXP/IMP£©¡¢Èȱ¸·ÝºÍÀ䱸·Ý¡£µ¼³ö±¸¼þÊÇÒ»ÖÖÂß¼±¸·Ý£¬À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý¡£
Ò»¡¢ µ¼³ö£¯µ¼È루Export£¯Import£©
ÀûÓÃExport¿É½«Êý¾Ý´ÓÊý¾Ý¿âÖÐÌáÈ¡³öÀ´£¬ÀûÓÃImportÔò¿É½«ÌáÈ¡³öÀ´µÄÊý¾ÝËͻص½OracleÊý¾Ý¿âÖÐÈ¥¡£
£±¡¢ ¼òµ¥µ¼³öÊý¾Ý£¨Export£©ºÍµ¼ ......