¼Ó¿ì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Îļþ£
Ïà¹ØÎĵµ£º
SQL> conn system/oracle
Connected.
SQL> create table scott.t1(id number primary key,name varchar2(10)); --´´½¨²âÊÔ±í
Table created.
SQL> select constraint_name,table_name,constraint_type, --²é¿´ÏàÓ¦ÍêÕûÐÔÔ¼ÊøµÄ״̬
2 status,deferrable,deferred,validated
3 fro ......
ÏÈroot´ò²¹¶¡£ºp3006854_9204_linux.zip
ÔÙÉèoracle»·¾³±äÁ¿
°²×°
°²×°½áÊø½¨¿â֮ǰÐèÒª´òµÄ²¹¶¡ÓУº
p2617419_220_GENERIC.zip
p3119415_9204_linux.zip
¾ßÌå²Î¿¼ÕâƪÎÄÕ£º
Redhat Enterprise Linux 4°²×°oracle
¹Ø¼ü×Ö: redhat el4 oracle °²×°
Ò». °²×°×¼±¸
1. as4°²×°Íêºó£¬ÐèÒª¼ì²éÏÂÁÐÈí¼þ ......
Jsp Á¬½Ó mySQL¡¢Oracle Êý¾Ý¿â±¸Íü
2009-12-15 16:47
Jsp »·¾³Ä¿Ç°×îÁ÷ÐеÄÊÇ Tomcat5.0¡£Tomcat5.0 ×Ô¼º°üº¬Ò»¸ö Web ·þÎñÆ÷£¬Èç¹ûÊDzâÊÔ£¬¾Íû±ØÒª°Ñ Tomcat Óë IIS »ò Apache ¼¯³ÉÆðÀ´¡£ÔÚ Tomcat ×Ô´øµÄ Web ·þÎñÆ÷Ï¿ÉÒÔ½øÐÐ Jsp ²âÊÔ¡£
°²×° Tomcat5.0 Ç°ÐèÒª°²×° JDK(Èç¹ûÊÇ Windows server ......
OracleµÄÍâ¼üÓÃÀ´ÏÞÖÆ×Ó±íÖвο¼µÄ×ֶεÄÖµ£¬±ØÐëÔÚÖ÷±íÖдæÔÚ¡£¶øÇÒÔÚÖ÷±íµÄ¼Ç¼·¢Éú±ä»¯µ¼ÖÂÍâ¼ü²Î¿¼Î¨Ò»Ô¼ÊøÖµ·¢ÉúÁ˱仯ʱ£¬¶¨ÒåÁËһϵÁеĶ¯×÷¡£ ÔÚSQL92±ê×¼Öж¨ÒåÁ˼¸ÖÖÍâ¼ü¸Ä±äºó£¬ÈçºÎ´¦Àí×Ó±í¼Ç¼µÄ¶¯×÷£¬ÆäÖаüÀ¨£º
ÏÞÖÆRestrict£ºÕâÖÖ·½Ê½²»ÔÊÐí¶Ô±»²Î¿¼µÄ¼Ç¼µÄ¼üÖµÖ´Ðиüлòɾ³ýµÄ²Ù×÷£»ÖÃΪ¿ÕSet to null ......
ÓÃoracleµÄжÔسÌÐò²¢²»ÄÜÍêȫжÔظɾ»¡£Èç֮ǰµÄÃüÃûµÄoracle sid ²»ÄÜÔÙʹÓ᣻áÌáʾsid´æÔÚ¡£ÏÂÃæÊÇÔÚwinxpÏÂÍêȫжÔØoracleµÄ·½·¨¡£
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ
Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle ......