¡¾×ª¡¿Oracle¼à¿Ø¹¤¾ß¸ÅÀÀ
Oracle¼à¿Ø¹¤¾ß¸ÅÀÀ
Kaya ·¢±íÓÚ os2ora.com
дÁËLinuxÉϵļà¿ØÓë·ÖÎö¹¤¾ß
Ö®ºó£¬Ð´Ð´OracleÉÏÏàÓ¦µÄ¼à¿ØÓë·ÖÎö¹¤¾ß»¹ÊÇͦÓÐÒâ˼µÄ£¬Ò»·½Ãæ¿ÉÒÔ¸ü¼ÓÍêÕû£¬Ò»·½Ãæ¿ÉÒÔ½øÐкáÏò¶Ô±È¡£
LinuxÉϵÄÐÔÄÜÊý¾ÝÒ»°ã¶¼À´×ÔÓÚ/procÎļþϵͳ£¬¶øOracleÔòÊÇÀ´×ÔÓÚV$ÊÓͼ¡£Òò´Ë£¬ËùÓеÄOracle¼à¿Ø¹¤¾ßµÄʵÏÖ¶¼Íò±ä²»Àë
V$
ÊÓͼ¡£¶øÕâЩ¸öÊÓͼÀïÃ棬×îÖØÒªµÄÓ¦ÍÆv$sysstat¡£ÀïÃæ¼Ç¼×ÅInstanceÒ»¼¶µÄ¸÷¸öͳ¼ÆÊý¾ÝµÄµ±Ç°Öµ£¬ÀýÈçCPUÀûÓÃÇé¿ö£¬Âß¼
¶Á£¬Redo
SizeµÈµÈ¡£10gºóÓÐÁËÁíÒ»¸öÖØÒªµÄÊÓͼ£¬½Ðv$active_session_history,ͨ¹ýËü¿ÉÒÔÈÝÒ׵صÃÖªµ±Ç°InstanceµÄ»î¶¯×´
̬£¬Ö÷ÒªÊǸ÷¸öʱ¿Ìϵͳ¶¼ÔڵȴýÄÄЩʼþ£¬Í¨¹ý¶ÔÕâЩµÈ´ýʼþºÍÏàÓ¦µÈ´ý´ÎÊýµÄͳ¼Æ£¬¾Í¿ÉÒÔÇåÎúµØÁ˽âϵͳµÄÀúÊ·¹¤×÷¸ºÔØÌØÕ÷ºÍѹÁ¦Çé¿ö¡£Èç¹ûÏë»ñÈ¡µ±Ç°
ÕýÔÚÖ´ÐеÄSQL£¬Ôò¿É²éѯv$sqlÊÓͼ¡£Èç¹ûÏë»ñÈ¡µ±Ç°SQLµÄÖ´Ðмƻ®£¬Ôò¿Éµ÷ÓÃdbms_xplan.display_cursor¡£´ÓÕâ·½Ãæ
½²£¬Ã¿Ò»¸öDBA¶¼¾ß±¸×Åдһ¸öOracleµÄ¼à¿Ø¹¤¾ßµÄÄÜÁ¦¡£ËüÓ¦¸Ã±Èдһ¸öLinuxµÄ¼à¿Ø¹¤¾ßÀ´µÃÈÝÒ×¼òµ¥µÃ¶à¡£
Èç¹û¶Ô¼à¿Ø¹¤¾ß×öÏ·ÖÀàµÄ»°£¬¿ÉÒÔ·Ö³ÉÁ½À࣬һÀàÊÇ»ùÓÚÎı¾Ä£Ê½µÄ£¬Ò»ÀàÊÇ»ùÓÚGUIģʽµÄ¡£´ó²¿·ÖDBA¶¼×Ô¼ºÊÕ¼¯ÁËһЩºÜ³£¼ûµÄ¼à¿Ø½Å±¾£¬ÎÒÏë
¿ÉÒÔ°ÑÕâÒ»Àà¹éΪ»ùÓÚÎı¾Ä£Ê½µÄ¹¤¾ß¡£Îı¾Ä£Ê½µÄºÃ´¦ÔÚÓÚÇáÁ¿¼¶£¬·´Ó¦Ëٶȿ죬±È½ÏÊʺÏÔÚshellģʽϺÍsqlplusÐͬ¹¤×÷¡£´ó²¿·ÖDBA¿ÉÄÜÒ²
±È½ÏÏ°¹ßÕâ¸öģʽ£¬°üÀ¨ÎÒÔÚÄÚ¡£
GUIģʽÓõý϶àµÄ¹¤¾ßÓ¦¸ÃÊÇToad¡£ºÜ²»´íµÄÒ»¸ö¹¤¾ß£¬ÓÃËüÀ´¼à¿Øsessions£¬sessionÕýÔÚÖ´ÐеÄÓï¾ä£¬sessionµÄµÈ´ýʼþÊÇÎÒ×î³£ÓõÄÒ»¸ö¹¦ÄÜ¡£
Ò²ÓÐһЩºóÆðÖ®Ð㣬Óиö¹¤¾ßÒ²ÐíÖµµÃÒ»Ìᣬ½Ð×öDB Optimizer
¡£×îÖ÷ÒªµÄÊÇÕâ¸ö²úÆ·µÄÖ÷Òª²ÎÓëÕߣº²ÎÓëÁË10g EMÀïµÄPerformance PageµÄÖØÐÂÉè¼ÆµÄKyle Hailey
¡£ÒÔÒ»¸ö½Øͼ×öΪ½áβ°É:
±¾ÎÄת×Ô£ºhttp://www.os2ora.com/oracle-monitoring-tool-summary-and-recommend/
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ORACLEÊý¾Ý¿âµÄÈÕÖ¾Îļþ$ORACLE_BASE/admin/orasid/bdump/alert_orasid.log¼Ç¼ÁËÖØ×÷ÈÕÖ¾µÄת»»£¬
Êý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ£¬Êý¾Ý¿â½á¹¹µÄ¸Ä±ä£¬»ØÍ˶εÄÐ޸ģ¬ËÀËø£¬ÄÚ²¿´íÎóµÈÐÅÏ¢.
Êý¾Ý¿â¹ÜÀíÔ±ÐèÒª¼ì²éÕâ¸öÎļþÓÐÎÞORA-´íÎ󲢶¨ÆڵضÔÕâ¸öÈÕÖ¾Îļþ½øÐд浵ÕûÀí ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
1¡¢Ð´BATÎļþ
------------------------------------------------------------------------------------------------------
if "%time:~0,1%"==" " (set backup_file=%date:~0,4%%date:~5,2%%date:~8,2%-0%time:~1,1%%time:~3,2%%time:~6,2%) else (set backup_file=%date:~0,4%%date:~5,2%%date:~8,2%-%time:~0,2%%time: ......