OracleÊý¾Ý¿âÐÔÄܵ÷ÊÔ¹¤¾ß
Oracle Enterprise Manager Oracle EMÊÇÓû§°²×°Oracle£¬´´½¨ÁËÊý¾Ý¿â²¢ÅäÖúÃÍøÂç×ÊÔ´ºó£¬Oracle¸½´ø°²×°µÄÒ»¸öÊý¾Ý¿â¹ÜÀíÈí¼þ¡£Í¬Ê±£¬EMÒ²Ìṩ¶ÔÐÔÄܵ÷ÊÔÓаïÖúµÄ¹¤¾ß£¬ÈçSQL*LoaderºÍRecovery Manager £¨RMAN£©µÈ¡£ Oracle Diagnostics Pack (ODP) ODPÓ¦¸ÃËãÊÇOracleÊý¾Ý¿â»·¾³ÐÔÄܵ÷ÊÔµÄ×îÖ÷ÒªºÍ×îÓÐЧµÄ¹¤¾ß£¬ËüÌṩÐÔÄÜÆ¿¾±×Ô¶¯Ê¶±ð(Automatic Identification of performance bottlenecks)£¬Òýµ¼ÐÔÎÊÌâ½âÎö£¨Guided problem resolution£©ºÍÍêÕûµÄϵͳ¼à¿Ø¡£ODPµÄÖ÷Òª¹¦ÄÜ°üÀ¨Automatic Workload Repository (AWR)£¬Automatic Database Diagnostic Monitor (ADDM)ºÍActive Session History (ASH)¡£ Oracle Database Tuning Pack Oracle Databae Tuning PackÍê³ÉÁËÊý¾Ý¿âÓ¦ÓÃÐÔÄܵ÷Õû¹ý³ÌµÄ×Ô¶¯»¯£¬Òò´Ë¿ÉÒÔÏÔÖøµØ½µµÍÊý¾Ý¿â¹ÜÀí³É±¾£¬Ìá¸ßÐÔÄܺͿɿ¿ÐÔ¡£Ö÷Òª°üº¬µÄ¹¦ÄÜÓУº 1. SQL Tuning Advisor Tuning Advisor¿ÉÒÔÈÃÓû§ÊäÈëÒ»¸ö»òÕ߶à¸öSQLÓï¾ä£¬È»ºóÊä³ö¾ßÌåµÄÕë¶ÔSQLµ÷ÓŵĽ¨ÒéºÍÍƼö£¬Í¬Ê±¶ÔÿһÌõ½¨Òé¸ø³ö½âÊͺÍÔ¤¼ÆºÃ´¦¡£Ã¿Ìõ½¨Ò鶼ÓëÔÚ¶à¸ö¶ÔÏóÉϵÄͳ¼ÆÐÅÏ¢£¬´´½¨ÐµÄË÷Òý£¬Öع¹SQLÓï¾ä»òÕß´´½¨SQL ProfilesÓйء£ 2. SQL Access Advisor ¸Ã¹¦ÄÜͨ¹ýÍƼöºÏÊʵÄmaterialized views, view logs, Ë÷ÒýÒÔ¼°partition for a given SQL workloadÀ´ÓÅ»¯SQL²éѯµÄÊý¾ÝÁ¬½Ó·¾¶¡£ Oracle Real Application Testing Ö÷ÒªµÄ¹¦ÄÜÓУº 1. Databse Replay ¸Ã¹¦ÄÜ¿ÉÒÔÈÃÓû§ÔÚProductionϵͳÀï»ñÈ¡Êý¾Ý¿âµÄÔËÐÐ×´¿ö£¬È»ºóÔÚ²âÊÔ»·¾³ÖУ¬ÓÃͬÑùµÄʱ¼äºÍ²¢·¢À´ÖØ·Å¡£ 2. SQL Performance Analyzer Õâ¸ö¹¦Äܼòµ¥¶øÑÔ£¬¾ÍÊÇÔÚÓû§³·Ïú»òÕßÌí¼ÓSQLÓï¾äµÄÐÞ¸ÄÖ®ºó£¬À´²éÔÄSQLÓï¾äÐ޸ĵĺóµÄÐÔÄÜÒÔ¼°Ð§¹ûµÄ¡£
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
Oracle°²×°Íêºó£¬ÆäÖÐÓÐÒ»¸öȱʡµÄÊý¾Ý¿â£¬³ýÁËÕâ¸öȱʡµÄÊý¾Ý¿âÍ⣬ÎÒÃÇ»¹¿ÉÒÔ´´½¨×Ô¼ºµÄÊý¾Ý¿â¡£
¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÎªÁ˱ÜÃâÂé·³£¬¿ÉÒÔÓÃ'Database Configuration Assistant'Ïòµ¼À´´´½¨Êý¾Ý¿â¡£
´´½¨ÍêÊý¾Ý¿âºó£¬²¢²»ÄÜÁ¢¼´ÔÚÊý¾Ý¿âÖн¨±í£¬±ØÐëÏÈ´´½¨¸ÃÊý¾Ý¿âµÄÓû§£¬ ......
ÔÎĵØÖ·£ºhttp://oracle.chinaitlab.com/induction/725752.html
Ò»¡¢logminerµÄÓÃ;
¡¡¡¡ÈÕÖ¾ÎļþÖдæ·Å×ÅËùÓнøÐÐÊý¾Ý¿â»Ö¸´µÄÊý¾Ý£¬¼Ç¼ÁËÕë¶ÔÊý¾Ý¿â½á¹¹µÄÿһ¸ö±ä»¯£¬Ò²¾ÍÊǶÔÊý¾Ý¿â²Ù×÷µÄËùÓÐDMLÓï¾ä¡£
¡¡¡¡logminer ¹¤¾ß¼´¿ÉÒÔÓÃÀ´·ÖÎöÔÚÏߣ¬Ò²¿ÉÒÔÓÃÀ´·ÖÎöÀëÏßÈÕÖ¾Îļþ£¬¼´¿ÉÒÔ·ÖÎö±¾Éí×Ô¼ºÊý¾Ý¿âµÄÖØ×÷ÈÕÖ¾ÎÄ ......
ÓÃϵͳ¹ÜÀíÔ±£¬²é¿´µ±Ç°Êý¾Ý¿âÓм¸¸öÓû§Á¬½Ó£º
SQL> select username,sid,serial# from v$session;
Èç¹ûҪͣij¸öÁ¬½ÓÓÃ
SQL> alter system kill session 'sid,serial#';
......