Çë½ÌÒ»¸ö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 10g£¬Ä¬ÈÏ°²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......