Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¼Ó¿ìOracleµÄ»Ø¹öËÙ¶È

ÎÊÌâÃèÊö
1¡¢Ó¦ÓÃÁ¬½ÓÊý¾ÝÒì³£»ºÂý£¬°üÀ¨¿Í»§¶ËʹÓÃplsqlÁ¬½Ó£»
2¡¢Êý¾Ý¿âÖ÷»úcpuÕ¼ÓÃÂʾӸ߲»Ï£¬IOдÈë¾Ó¸ß²»Ï¡£
3¡¢Ö÷»úÈÕ³£Î¬»¤²Ù×÷ÏìÓ¦Âý£¬Èçman»òw£»
·ÖÎöÎÊÌâ
ØÏµÍ³¼°oracleÓ¦ÓÃΪʲôÏìÓ¦Âý
1¡¢ÎªÊ²Ã´ÏµÍ³Á¬wÕâô¼òµ¥µÄ²Ù×÷¶¼»á¾õµÃ¿¨ÄØ£¿
2¡¢ÎªÊ²Ã´Ã»ÓÐÈκÎÓ¦ÓýÓÈëµÄÇé¿öÏ£¬Êý¾Ý¿â»áÓдóÁ¿µÄдÈë²Ù×÷ÄØ£¿
Top //²é¿´cpuʹÓÃÇé¿ö£¬·¢ÏÖiowait%Õ¼ÓÃÁË´óÁ¿µÄcpuʱ¼ä£»
Iostat –mx 2 100 ²é¿´diskʹÓÃÇé¿ö£¬·¢ÏÖ´ÅÅÌÀûÓÃÂʳ¤Ê±¼ä´¦ÓÚ100%״̬£»½«ÏµÍ³ÏìÓ¦Âý¶¨Î»ÔÚioÇëÇó¹ý¶àµ¼Ö¡££¨¹ØÓÚiostatµÄʹÓòμûman£©¡£
ØÊ²Ã´µ¼Ö³öÏÖÈç´ËÖ®¶àµÄIOÇëÇóÄØ?
ÔÚ¹Û²ìºǫ́µÄ½ø³Ì£¬·¢ÏÖÓÐora_p000...ora_p015. ¹²16¸ö½ø³ÌÔÚÔËÐС£
ÎÒ»úÆ÷ÎïÀíÉÏ2¿ÅCPU£¬¹²ÓÐ8¸öcore £¨Cat /proc/cpuinfo¿ÉÒÔ¿´µ½»úÆ÷cpuÐÅÏ¢£©¡£ ÔËÐÐSqlplus “/as sysdba”½øÈësqlÃüÁîÐв鿴rollbackÏà¹Ø²ÎÊý£¬Show parameter rollback ¿´µ½FAST_START_PARALLEL_ROLLBACK = LOW£¬´Ë²ÎÊýΪĬÈÏÉèÖÃΪLOW£¬±íÃ÷²¢ÐÐÔËÐеĻعö½ø³ÌÓÐ2*number of cpu£¬ÔÚÎÒµÄϵͳ¸ÕºÃ±íÏÖΪ16¸ö½ø³Ì¡£ÓëÎÒʹÓÃps –ef | grep ora_p  ¿´µ½µÄora_p000_*0**µ½ora_p015_***½ø³Ì¶ÔÓ¦¡£
ØÎªÊ²Ã´»áÓÐÈç´Ë¶àµÄ»Ø¹ö½ø³Ì³öÏÖÄØ£¿
¾­¹ýѯÎÊÏîÄ¿×éÏà¹ØÈËÔ±£¬·¢ÏÖÓÐÈËÔÚÖ´ÐÐimpµ¼Èëʱ£¬ÊÖ¶¯ÖÕÖ¹ÁË¡£Äõ½¸ÃͬʵÄimpÓï¾äÒ»¿´Çå³þÁË£¬ÓÉÓÚµ¼ÈëµÄÊý¾ÝÁ¿½Ï´ó£¬ÓÖûÓÐÖðÐÐÌá½»£¨commit=y£©£¬Òì³£ÖÕÖ¹ºó²úÉú´óÁ¿µÄ»Ø¹ö¶¯×÷¡£
ػعöÂý²Ù×÷ΪʲôÂý£º
View $ORACLE_BASE/admin/$ORACLE_SID/bdump/alter_<ORACLE_SID>.log²é¿´oracle alertÈÕÖ¾£¬·¢ÏÖ´óÁ¿µÄCheckpoint not completed£¬±íÃ÷redoÎļþ×éÌ«ÉÙ£¬µ¼ÖÂLGWR½ø³ÌÔÚÇл»µ½ÐÂredo fileʱ£¬µÈ´ý¾ÉÊý¾ÝдÈë(dbwn)Êý¾ÝÎļþ£»
½â¾ö°ì·¨¾ÍÊÇÔö¼Óredo file ×飻
Alert database add logfile group 4(‘/u01/app/oracle/oradata/oracl/redo04.log’) size 100M;
Alert database add logfile group 5(‘/u01/app/oracle/oradata/oracl/redo05.log’) size 100M;
Alert database add logfile group 6(‘/u01/app/oracle/oradata/oracl/redo06.log’) size 100M;
¸ù¾ÝÐèÒª¿ÉÌí¼Ó¸ü¶àµÄredoÎļþ×é¡£
Select group#,members,status from v$log;·¢ÏÖÓÐinactive³öÏ־ͿÉÒÔÁË¡£Redo Îļþ´¦ÔÚactive״̬˵Ã÷redoÎļþ»¹Ã»Ð´ÈëÔÚÊý¾ÝÎļþÖУ¬Èô´ËʱLGWR switchÇл»µ½activeÎļþ£


Ïà¹ØÎĵµ£º

½â¾öOracle 9iºÍTomcat¶Ë¿Ú³åÍ»(×ªÔØ)


    ·½°¸Ò»£º
    ÐÂ×°ÁËϵͳºó£¬·¢ÏÖÔÚµ÷ÊÔ³ÌÐòʱTOMCATÌáʾ8080¶Ë¿ÚÒѱ»Õ¼Óã¬ÓÚÊÇÔËÐÐNETSTAT -ANO²é¿´¶Ë¿ÚʹÓÃÇé¿ö£¬·¢ÏÖ8080¶Ë¿Ú±»ORACLEµÄ¼àÌýÆ÷¸øÕ¼ÓÃÁË£¬ÓÚÊǽáºÏÉÏÍø²éµ½·½·¨£¬½«ORACLE XDBµÄHTTP·þÎñ¶Ë¿Ú¸Ä³É8081£¬ÎÊÌâ½â¾ö¡£
 
    ×ܽáһϿɽâ¾öµÄ·½ ......

install oracle 9204 on linux as4

 ÏÈroot´ò²¹¶¡£ºp3006854_9204_linux.zip
ÔÙÉèoracle»·¾³±äÁ¿
°²×°
°²×°½áÊø½¨¿â֮ǰÐèÒª´òµÄ²¹¶¡ÓУº
p2617419_220_GENERIC.zip
p3119415_9204_linux.zip
¾ßÌå²Î¿¼ÕâÆªÎÄÕ£º
Redhat Enterprise Linux 4°²×°oracle
¹Ø¼ü×Ö: redhat el4 oracle °²×°
Ò». °²×°×¼±¸
  1. as4°²×°Íêºó£¬ÐèÒª¼ì²éÏÂÁÐÈí¼þ ......

¡¾×ª¡¿ÈçºÎ²é¿´oracle sqlÖ´Ðмƻ®

·½·¨Ò»
µÚÒ»²½£ºµÇÈësql/plus Ö´ÐÐÃüÁÎÞÏȺó˳Ðò£©
set   time   on; (˵Ã÷£º´ò¿ªÊ±¼äÏÔʾ£©  
  set   autotrace   on; (˵Ã÷£º´ò¿ª×Ô¶¯·ÖÎöͳ¼Æ£¬²¢ÏÔʾSQLÓï¾äµÄÔËÐнá¹û£©  
  set   autotrace   traceonly; (˵à ......

OracleÊý¾Ýµ¼ÈëMySQL

 ## Oracle Êý¾Ýµ¼Èëµ½ Mysql ##                             
__________________________________________                                 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ