·¢²¼Ê±¼ä : ÐÇÆÚËÄ ÎÄÕÂORACLEÊý¾Ý¿âѲ¼ìÄ£°å¸üÐÂÍê±Ï¿ªÊ¼ÔĶÁ
5. Êý¾Ý¿â¼òµ¥·çÏÕÆÀ¹À
5.1
°²È«ÐÔ¹ÜÀí
ÔÚ°²È«ÐÔ·½Ã棬Ö÷Òª¿¼ÂÇÓû§·ÃÎÊÊý¾Ý¿âµÄ¿ØÖÆÒÔ¼°Î¬»¤ÏµÍ³µÄ°²È«ÐÔÎÊÌâ¡£ Database Administrator Usernames/Passwords Oracle×Ô¶¯Éú³ÉÁ½¸öÓû§£¬²¢ÊÚÓèDBAȨÏÞ£º ? SYS ? SYSTEM
¾¼ì²é£¬SYSºÍSYSTEM¶¼Ã»ÓÐʹÓóõʼȱʡÃÜÂë¡£ÕâÑùÓÐÀûÓÚά»¤Êý¾Ý¿âµÄ°²È«ÐÔ£¬·ñÔòÈκξßÓÐOracle֪ʶ±³¾°µÄÈ˶¼ÄܽøÈëÊý¾Ý¿â¡£ ½¨Ò飺
Ä¿Ç°Êý¾Ý¿âÓû§°²È«·½ÃæÉèÅZÁ¼ºÃ£¬ÉèÅZ°²È«ºÏÀí¡£ SYSDBA Users
±»ÊÚÓèSYSDBAȨÏÞµÄÓû§Äܹ»½øÐÐDBAµÄ²Ù×÷£¬°üÀ¨½¨Á¢Êý¾Ý¿â£¬¹Ø±ÕÊý¾Ý¿â¡£ ½¨Ò飺
Ä¿Ç°Êý¾Ý¿â²»´æÔÚ¾ßÓÐDBAȨÏÞµÄÒµÎñÓû§£¬Óû§È¨ÏÞ¹ÜÀíÇé¿ö½ÏºÃ¡£
½¡¿µ¼ì²é±¨¸æ µÚ17Ò³
6. SqlNet ¸Å¿ö
Net8Äܹ»ÔÚ²»Í¬¼ÆËã»úÉÏ°²×°·þÎñºÍÓ¦ÓóÌÐò£¬²¢ÇÒÄܹ»Ê¹ËüÃÇÈçͬͬһ²ãÉϵÄÓ¦ÓóÌÐòÒ»Ñù½øÐÐͨÐÅ¡£Net8µÄÖ÷Òª¹¦ÄܾÍÊÇ´´½¨ÍøÂçͨ»°£¬²¢ÇÒÔÚ¿Í»§¶ËºÍ·þÎñÆ÷¶Ë£¬»òÕßÁ½¸ö·þÎñÆ÷¶ËÖ®¼äת»»Êý¾Ý¡£Net8±ØÐë°²×°ÔÚÍøÂçµÄÿ̨»úÆ÷ÉÏ¡£µ±ÍøÂçͨ·½¨Á¢£¬Net8°çÑÝ×Å¿Í»§¶ËºÍ·þÎñÆ÷¶ËÊý¾ÝͶµÝÕߵĽÇÉ«¡£
6.1 ¼àÌýÆ÷Listener
λÓÚ·þÎñÆ÷¶ËµÄ¼àÌý³ÌÐòÊǵ¥¶ÀµÄ½ø³Ì¡£Ëü´Ó¿Í»§¶Ë½ÓÊÜÁ¬½ÓÇëÇ󣬲¢¹ÜÀíÕâЩ¶Ô·þÎñ¶ËµÄÇëÇó¡£µ±Ç°LISTENERµÄ²ÎÊýÉèÅZÈçÏ£º
Parameter STARTUP_WAIT_TIME_LISTENER CONNECT_TIMEOUT_LISTENER TRACE_LEVEL_LISTENER Value N/A N/A N/A Ö»Óе±SQLNETÐèÒª¸ú×ÙÅжÏËù³öÏÖµÄÎÊÌâʱ£¬TRACE_LEVEL_LISTENER²ÅÐèÒª±»ÉèÅZ¡£Ëù»ñµÃµÄ¸ú×ÙÎļþÐè½»ÓÉOracle Support½øÐзÖÎö¡£SQLNET¸ú×ÙÖ»ÐèÔÚÒ»¶Îʱ¼äÄÚ¿ªÆô£¬ÒòΪÕ⽫ռÓÃһЩÍøÂç×ÊÔ´¡£
6.2 SQL*Net
ÅäÅZÎļþSQLNET.ORA°üº¬ÁË¿Í»§¶ËºÍ·þÎñÆ÷¶ÔSQL*NetÅäÅZµÄÉèÅZÐÅÏ¢¡£µ±Ç°µÄSQLNET²ÎÊýÈçÏ£º
Parameter AUTORCLATIC_IPC TRACE_LEVEL_CLIENT TRACE_FILE_CLIENT TRACE_DIRECTORY_CLIENT SQLNET.EXPIRE_TIME Value N/A N/A N/A N/A N/A
6.3 TNSNAMES
TNSNAMES.ORA°üº¬ÓëÁ¬½ÓÃèÊö·ûÏàÆ¥ÅäµÄÍøÂç·þÎñÃû¡£Á¬½ÓÃèÊö·û°üÀ¨¼àÌý³ÌÐòµÄµØÖ·ÒÔ¼°connect_data¡£TNSNAMES.ORAÉèÅZÈçÏ£º
ÓÉÓÚTNSNAMESÖÐÏà¹ØµÄÍøÂç·þÎñÃû±È½Ï¶à£¬ÍêÕûµÄTNSNAMES.ORAÖеÄÄÚÈÝ¿ÉÒÔ¼û·þÎñÆ÷ÉϵÄÅäÅZÎļþ¡£
½¡¿µ¼ì²é±¨¸æ µÚ18Ò³
7. Êý¾Ý¿âÐÔÄÜ
Êý¾Ý¿âµÄÐÔÄÜÇé¿öͨ¹ýAWRµÄ±¨¸æÀ´ÌåÏÖ¡£ÓÉÓÚ±¾´Î¼ì²é²¢²»ÊÇÍêÕûµÄÐÔÄܼì²é£¬ËùÒÔ±¾±¨¸æÖ»ÁоÙ×îÖ÷ÒªµÄÐÔÄÜÎÊÌâ¡£ XXXX
Begin Snap: End Snap: Elapsed: DB Time: Snap Id Snap Time Sessions Cursors/Session YYYY
Begin Snap: End Snap: Elapsed: DB Time: Snap Id Snap Time Sessions Cursors/Session ÎÒÃÇ¿ÉÒԲο¼Óû§ÏµÍ³Ã¦Ê±µÄAWRÐÅÏ¢½øÐзÖÎö£¬²»Ò»¶¨¾ÖÏÞÓÚ¼ì²éʱ¶Î£¬ÕâÑù¿ÉÒÔ¸ü¼ÓÉîÈëµÄ·¢ÏÖÎÊÌâ¡£
7.1 Êý¾Ý¿â¸÷Ïî»ùÓÚʱ¼äÄ£Ð͵Äͳ¼ÆÐÅÏ¢
¶ÔÊý¾Ý¿âÒµÎñ¸ººÉѹÁ¦×î´óÇé¿öÏÂÿһ¸öʵÀýµÄÒ»¸öAWR±¨¸æµÄÁгöÖ÷ÒªµÄÐÔÄܽá¹û£¬ÈçÊý¾Ý¿â¸÷Ïî»ùÓÚʱ¼äÄ£Ð͵Äͳ¼ÆÐÅÏ¢µÈ£º XXXX
Statistic Name sql execute elapsed time DB CPU parse time elapsed hard parse elapsed time hard parse (sharing criteria) elapsed time PL/SQL execution elapsed time PL/SQL compilation elapsed time connection management call elapsed time sequence load elapsed time repeated bind elapsed time hard parse (bind mismatch) elapsed time DB time background elapsed time background cpu time Time (s) % of DB Time YYYY
Statistic Name DB CPU sql execute elapsed time Time (s) % of DB Time ½¡¿µ¼ì²é±¨¸æ µÚ19Ò³
parse time elapsed hard parse elapsed time hard parse (sharing criteria) elapsed time hard parse (bind mismatch) elapsed time PL/SQL execution elapsed time sequence load elapsed time PL/SQL compilation elapsed time connection management call elapsed time inbound PL/SQL rpc elapsed time repeated bind elapsed time DB time background elapsed time background cpu time
7.2 XXXX
Êý¾Ý¿â¸ººÉѹÁ¦·ÖÎö
Load Profile
Redo size: Logical reads: Block changes: Physical reads: Physical writes: User calls: Parses: Hard parses: Sorts: Logons: Executes: Transactions: % Blocks changed per Read: Rollback per transaction %: Per Second Recursive Call %: Rows per Sort: Per Transaction YYYY
Load Profile
Redo size: Logical reads: Block changes: Physical reads: Physical writes: User calls: Parses: Hard parses: Sorts: Logons: Executes: Transactions: Per Second Per Transaction ½¡¿µ¼ì²é±¨¸æ µÚ20Ò³