ÓÉ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
Ïà¹ØÎĵµ£º
×î½üÓÐÒ»ÈÎÎñ£¬ÐèҪʹÓÃOracleÊý¾Ý¿â£¬ÒÔǰ¶Ô´Ë²»Ì«ÊìϤ£¬¾Í´ÓÍøÉϲéÕÒ×ÊÁÏ£¬£¨ËµÊµÔÚµÄÍøÂçÕæÊÇÌ«ºÃÁË£¬Ò²¶à¿÷ÁËÐí¶àµÄÈÈÐĵļ¼ÊõÈËÔ±£¬Ô¸Òâ°Ñ×Ô¼ºµÄ¾ÑéºÍÐĵÃÓë´ó¼Ò·ÖÏí£©²¢×ªÌùÁËÒ»¸öÌû×Ӳο¼£¬²»¹ý´ËÌû×ÓÓÐЩµØ·½Ã»ÓÐ˵Çå³þ£¬È·ÊµÈÃÎÒ·ÑÁ˺ô󾢣¬²Å²âÊԳɹ¦¡£ÏÂÃæÎÒ°ÑÎҵIJ½Öè˵Ã÷һϣº£¨»·¾³£ºWindows XP sp2 + vs ......
·½·¨Ò»£¬Ê¹ÓÃSQL*Loader
Õâ¸öÊÇÓõĽ϶àµÄ·½·¨£¬Ç°Ìá±ØÐëoracleÊý¾ÝÖÐÄ¿µÄ±íÒѾ´æÔÚ¡£
´óÌå²½ÖèÈçÏ£º
1 ½«excleÎļþÁí´æÎªÒ»¸öÐÂÎļþ±ÈÈçÎļþÃûΪtext.txt£¬ÎļþÀàÐÍÑ¡Îı¾Îļþ£¨ÖƱí·û·Ö¸ô£©£¬ÕâÀïÑ¡ÔñÀàÐÍΪcsv£¨¶ººÅ·Ö¸ô£©Ò²ÐУ¬µ«ÊÇÔÚдºóÃæµÄcontrol. ......
1.
´íÎóÌáʾ£ºORA-12545:ÒòÄ¿±êÖ÷»ú»ò¶ÔÏó²»´æÔÚ,Á¬½Óʧ°Ü.
´íÎóÖ¢×´£ºÐ½¨µÄÊý¾Ý¿âÔÚOEM¿ØÖÆÌ¨ÎÞ·¨ÏÔʾ£¨sysmanÓû§µÇ½£©£¬¶ÀÁ¢Æô¶¯Ä£Ê½¿ÉÒÔÕÒµ½£¬µ«ÎÞ·¨µÇ½£¬³öÏÖÈçÉÏ´íÎó¡£
½â¾ö°ì·¨£ºÐÞ¸Äoracle°²×°Ä¿Â¼Ï£¨oracle\ora90\network\ADMIN£©µÄtnsnames.oraÎļþ£¬½«µ±Ç°Êý¾Ý¿âÌí¼Óµ½¼àÌý¶ÔÏóÖС£ÐÞ¸ÄÖ®ºó£¬¿ÉÒÔÔÚ¶ÀÁ¢Ä ......
declare
begin
--SQLÓï¾ä
--Ö±½ÓдµÄSQLÓï¾ä(DML/TCL)
--¼ä½Óдexecute immediate <DDL/DCLÃüÁî×Ö·û´®>
--select Óï¾ä
<1>±ØÐë´øÓÐinto×Ó¾ä
&n ......
ΪÁËÈ·¶¨±í¿Õ¼äÖаüº¬ÄÇЩÄÚÈÝ£¬ÔËÐУº
select owner,segment_name,segment_type
from dba_segments
where tablespace_name='<name of tablespace>'
²éѯ±í¿Õ¼ä°üº¬¶àÉÙÊý¾ÝÎļþ¡£
select file_name, tablespace_name
from dba_data_files
where tablespace_name ='<name of t ......