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

Çë½ÌÒ»¸öoracle¹ÜÀíµÄÎÊÌ⣡ - Oracle / »ù´¡ºÍ¹ÜÀí

·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿Ã»·ÖÁË£¬ÇëÔ­Á£¡
°ÑalertÈÕÖ¾·ÅÉÏÀ´¿´¿´


¶Ô²»ÄÜ¿¿²ÂµÎ£¬
²é¿´Ò»ÏÂÊý¾Ý¿âalter<sid>.logÈÕÖ¾£¬È·ÈÏÊÇ·ñÊÇÊý¾Ý¿âÎÊÌâ¡£

ÒýÓÃ
·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿Ã»·ÖÁË£¬ÇëÔ­Á£¡


»¹ÊÇÒª¿´¿´alertÈÕÖ¾Îļþ£¬Àï±ßÓ¦¸ÃÄÜÕÒµ½Ò»Ð©Òì³£Çé¿ö¡£

ºÃµÄ£¬Ð»Ð»¸÷λ´óϺ£¬ÎÒÈ¥¹«Ë¾ÕÒÒ»ÏÂÈÕÖ¾£¡

ÒòΪ̫´ó£¬·Åµ½ÎҵIJ©¿ÍÀïµÄÁ½ÆªÎÄÕ£¬ÒòΪ³õѧoracle£¬ËùÒÔÇë¸÷λ¶à¶à°ïÖú£¬Á´½ÓÓÐÁ½¸ö£º
Ò»¸öÊÇhttp://blog.csdn.net/xzb_99/archive/2010/04/29/5544316.aspx
ÁíÍâÒ»¸öÊÇhttp://blog.csdn.net/xzb_99/archive/2010/04/29/5544287.aspx

·þÎñÆ÷ÊÇ windows 2003server 64λ oracleÊÇ oracle10g 64λ

Çë½Ì¸÷λ´óϺ£¡

alertÈÕÖ¾ÖÐÖ»·¢ÏÖÒ»¸öJOBÖ´ÐÐʧ°Ü£¬ÎÞÆäËüÒì³£¡£

ÊÇɶOS£¿ ¼ÙÈçÊÇWINDWOS£¬¿ÉÒÔÔÙ¿´¿´WINDOWSµÄʼþ¹ÜÀíÆ÷¡£

ÁíÍ⣬

select * from v$resource_limit where resource_name in ('processes', 'sessions');

´ÓÕâ¸öSQLÖвéһϣ¬ÊÇ·ñÓдﵽLIMITµÄÏÞÖÆ





End_rbody_65101420//-->
¸Ã»Ø¸´ÓÚ2010-04-30 16:05:27±»¹ÜÀíԱɾ³ý



¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓ


Ïà¹ØÎÊ´ð£º

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

oracle adoÁ¬½ÓÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚÁ¬½ÓÊý¾ÝԴʱ£¬Êý¾ÝÁ¬½ÓÊôÐÔÖÐÑ¡Ôñoracle provider for ole db
µ¥»÷ÏÂÒ»²½Ê±±¨´í ¡°Ìṩ³ÌÐò²»ÔÙ¿ÉÓã¬ÇëÈ·¶¨Ìṩ³ÌÐò±»ÕýÈ·°²×°¡£¡±
ÎÒÓõÄÊÇoracle 8£¬ÏÈǰÓõÄ10gÒ²Óöµ½ÀàËÆµÄÎÊÌâ
ʹÓÃmicrosoft ole db pro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ