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

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¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

ΪOracleÊý¾Ý¿â´´½¨Óû§

Oracle°²×°Íêºó£¬ÆäÖÐÓÐÒ»¸öȱʡµÄÊý¾Ý¿â£¬³ýÁËÕâ¸öȱʡµÄÊý¾Ý¿âÍ⣬ÎÒÃÇ»¹¿ÉÒÔ´´½¨×Ô¼ºµÄÊý¾Ý¿â¡£
    ¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÎªÁ˱ÜÃâÂé·³£¬¿ÉÒÔÓÃ'Database Configuration Assistant'Ïòµ¼À´´´½¨Êý¾Ý¿â¡£
    ´´½¨ÍêÊý¾Ý¿âºó£¬²¢²»ÄÜÁ¢¼´ÔÚÊý¾Ý¿âÖн¨±í£¬±ØÐëÏÈ´´½¨¸ÃÊý¾Ý¿âµÄÓû§£¬ ......

Oracle 9i LogMiner¹¤¾ßʹÓÃ˵Ã÷

Ô­ÎĵØÖ·£ºhttp://oracle.chinaitlab.com/induction/725752.html
Ò»¡¢logminerµÄÓÃ;
¡¡¡¡ÈÕÖ¾ÎļþÖдæ·Å×ÅËùÓнøÐÐÊý¾Ý¿â»Ö¸´µÄÊý¾Ý£¬¼Ç¼ÁËÕë¶ÔÊý¾Ý¿â½á¹¹µÄÿһ¸ö±ä»¯£¬Ò²¾ÍÊǶÔÊý¾Ý¿â²Ù×÷µÄËùÓÐDMLÓï¾ä¡£
¡¡¡¡logminer ¹¤¾ß¼´¿ÉÒÔÓÃÀ´·ÖÎöÔÚÏߣ¬Ò²¿ÉÒÔÓÃÀ´·ÖÎöÀëÏßÈÕÖ¾Îļþ£¬¼´¿ÉÒÔ·ÖÎö±¾Éí×Ô¼ºÊý¾Ý¿âµÄÖØ×÷ÈÕÖ¾ÎÄ ......

¡¾×ª¡¿ORACLEÓû§Á¬½ÓµÄ¹ÜÀí

ÓÃϵͳ¹ÜÀíÔ±£¬²é¿´µ±Ç°Êý¾Ý¿âÓм¸¸öÓû§Á¬½Ó£º

SQL> select username,sid,serial# from v$session;

Èç¹ûҪͣij¸öÁ¬½ÓÓÃ

SQL> alter system kill session 'sid,serial#';

 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ