尊龙凯时人生就是博

oracleÊý¾Ý¿âÈÕÖ¾Ôõô¿´

Éó²é oracle Êý¾Ý¿âÈÕÖ¾µÄÒªÁìÈçÏ£ºÊ¹Óà alter system »ò alter session ÏÂÁîÆôÓü´Ê±¸ú×ٻỰ¡£ÅÌÎÊ v$log_history¡¢v$logfile »ò v$log ÊÓͼ¡£Ä¬ÈÏÇéÐÎÏ£¬ÈÕÖ¾ÎļþλÓÚ $oracle_base/admin/[oracle_sid]/bdump£¨unix/linux£©»ò %oracle_base%\admin[oracle_sid]\bdump\£¨windows£©¡£

Oracle Êý¾Ý¿âÈÕÖ¾Éó²éÒªÁì

Oracle Êý¾Ý¿âÈÕÖ¾¼Í¼ÁËÊý¾Ý¿âÖб¬·¢µÄÒªº¦ÊÂÎñ£¬ÀýÈçÊý¾Ý¸ü¸Ä¡¢»á»°ÅþÁ¬ºÍ¶Ï¿ªÅþÁ¬¡£Éó²éÕâЩÈÕÖ¾¹ØÓÚʶ±ðÏ¢Õù¾öÊý¾Ý¿âÎÊÌâºÜÊÇÖ÷Òª¡£

ÔõÑùÉó²é Oracle Êý¾Ý¿âÈÕÖ¾

Óм¸ÖÖÒªÁì¿ÉÒÔÉó²é Oracle Êý¾Ý¿âÈÕÖ¾£º

ALTER SYSTEM SET LOGGING LEVEL = TRACE|ERROR|INFO;£º

½«ÈÕÖ¾¼¶±ðÉèÖÃΪ TRACE¡¢ERROR »ò INFO£¬ÒÔ¿ØÖƼͼµ½ÈÕÖ¾ÎļþµÄÊÂÎñÀàÐÍ¡£

ALTER SYSTEM SET EVENTS = immediate_trace_name EVENTS = 1000000 trace name context forever, level TRACE;£º

ÆôÓþßÓÐÌØÃüÃû³ÆµÄ¼´Ê±¸ú×ٻỰ£¬²¢½«ÆäÉèÖÃΪ¼Í¼ËùÓÐÊÂÎñ¡£

ALTER SESSION SET EVENTS = immediate_trace_name EVENTS = 1000000 trace name context forever, level TRACE;£º

½öÔÚÄ¿½ñ»á»°ÖÐÆôÓü´Ê±¸ú×ٻỰ£¬²¢½«ÆäÉèÖÃΪ¼Í¼ËùÓÐÊÂÎñ¡£

SELECT * FROM V$LOG_HISTORY;£º

ÁгöÊý¾Ý¿âÖÐÄ¿½ñºÍ´æµµµÄÈÕÖ¾Îļþ¡£

SELECT * FROM V$LOGFILE;£º

ÁгöÄ¿½ñ·­¿ªµÄÈÕÖ¾Îļþ¼°Æä״̬¡£

SELECT * FROM V$LOG;£º

ÁгöÈÕÖ¾ÎļþÖеĸ÷¸ö¼Í¼£¬°üÀ¨ÊÂÎñʱ¼ä´Á¡¢»á»° ID ºÍÊÂÎñÀàÐÍ¡£

ÈÕÖ¾ÎļþλÖÃ

ĬÈÏÇéÐÎÏ£¬Oracle Êý¾Ý¿âÈÕÖ¾ÎļþλÓÚÒÔÏÂλÖãº

Unix/Linux£º $ORACLE_BASE/admin/[ORACLE_SID]/bdump

Windows£º %ORACLE_BASE%\admin[ORACLE_SID]\bdump\

Ú¹ÊÍÈÕÖ¾ÐÅÏ¢

Oracle Êý¾Ý¿âÈÕÖ¾¼Í¼ʹÓÃÒÔÏÂ×ֶΣº

ʱ¼ä´Á£º ÊÂÎñ±¬·¢µÄʱ¼ä¡£

»á»° ID£º Ö´ÐвÙ×÷µÄ»á»°µÄ ID¡£

ÊÂÎñÀàÐÍ£º ÊÂÎñµÄÀàÐÍ£¬ÀýÈç SQL Óï¾ä¡¢ÅþÁ¬»ò¹ýʧ¡£

ÏêϸÐÎò£º ÊÂÎñµÄÏêϸÐÅÏ¢£¬ÀýÈç¹ýʧÐÂÎÅ»òÅÌÎÊÎı¾¡£

¹ÊÕÏɨ³ý

Éó²é Oracle Êý¾Ý¿âÈÕÖ¾¹ØÓÚʶ±ðÏ¢Õù¾öÊý¾Ý¿âÎÊÌâºÜÊÇÖ÷Òª¡£ÒÔÏÂÊÇһЩ³£¼ûµÄÈÕÖ¾¼ÍÈÎÃü;£º

ʶ±ð¹ýʧ£º ÈÕÖ¾Îļþ¿ÉÒÔ×ÊÖúʶ±ðÏ¢Õù¾öÊý¾Ý¿â¹ýʧ£¬ÀýÈçÅþÁ¬¹ýʧ¡¢Óï·¨¹ýʧ»ò×ÊԴȱ·¦¡£

Õï¶ÏÐÔÄÜÎÊÌ⣺ ÈÕÖ¾Îļþ¿ÉÒÔÌṩÓйØÊý¾Ý¿âÐÔÄܵĿ´·¨£¬ÀýÈçÂýËÙÅÌÎÊ»ò×ÊÔ´ÕùÓá£

Éó¼ÆÔ˶¯£º ÈÕÖ¾ÎļþÌṩÊý¾Ý¿âÔ˶¯µÄÀúÊ·¼Í¼£¬¿ÉÓÃÓÚÉó¼ÆÄ¿µÄ»òºÏ¹æÐÔÒªÇó¡£

ÒÔÉϾÍÊÇoracleÊý¾Ý¿âÈÕÖ¾Ôõô¿´µÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡

ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí£¬°æȨÕùÒéÓë±¾Õ¾Î޹أ¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í尊龙凯时人生就是博ÂËÓÍ»úÍø¹Ù·½Ì¬¶È£¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ£¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢£¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢£¬ÇëÄúÁ¬Ã¦ÁªÏµ尊龙凯时人生就是博ʵʱÐÞÕý»òɾ³ý¡£

Ïà¹ØÐÂÎÅ

ÁªÏµ尊龙凯时人生就是博

13452372176

¿É΢ÐÅÔÚÏß×Éѯ

ÊÂÇéʱ¼ä£ºÖÜÒ»ÖÁÖÜÎ壬9:30-18:30£¬½ÚãåÈÕÐÝÏ¢

QR code
sitemap¡¢ÍøÕ¾µØͼ