¹ØÓÚoracle¿ª·¢Ñ§Ï°ÖеÄÎÊÌâ - Oracle / ¿ª·¢
×î½ü°ÑÒ»¸ö±È½ÏÍêÕûµÄoracleѧϰÊÓƵ¿´ÍêÁË£¬delphiѧ¹ýÒ»µã£¬ÒÔºó´ÓÊÂoracle¿ª·¢£¬ÌýÇ°±²ËµÒªÑ§ºÜ¶à¶«Î÷£¬.net java delphi ¶¼ÒªÈ¥Ñ§Ï£¬µ«ÊÇûŪÇå³þ£¬ÎÒÔÝʱµÄÄ¿±êÊÇѧ»áÀûÓÃ.netƽ̨¿ª·¢³öoracleµÄÊý¾Ý¿â£¬delphiÌýһЩÈË˵ǰ¾°²»Ì«ºÃ£¬ºÜ¶à¶¼ÊÇÓá£netºÍJavaµÄ¡£ÎÒÏëÏÈѧ»á¡£netƽ̨²Ù×÷×öoracleÊý¾Ý¿â£¬Ó¦¸ÃѧЩʲô£¿£¿ÇëÇ°±²ÃÅÏêϸָµãÏ£¬Îҵķ½ÏòÒѾ˵ÁË£¬¾ÍÊDz»ÖªµÀÔõôȥѧÄÄЩ¶«Î÷¡£Ì«Ï¸ÁË¡£¡£ÏñÄÇЩÓÃado.netµ÷ÓÃoracle°¡£¬»¹ÓÐ×ö¿ò¼ÜʲôµÄ£¬¸Ð¾õ·¶Î§Âù´ó£¬Ïë¸üÏêϸµãÖªµÀ×Ô¼º¸ÃÔõôȥѧ£¬Ñ§Ê²Ã´£¬Çë½ÌÁË£¬ ÔÚÕâÀïÏÈллÁË¡£
Ä㶼»ádelphiÁË£¬ado.netÓò»Á˶೤ʱ¼äµÄ
ÏÈÁ¬½ÓÉÏoracleÊý¾Ý¿â£¬×öÒ»¸öÔöɾ¸Ä³ÌÐò°É
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬ÈÏ°²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......