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

oracleÁ¬½ÓÊý¾Ý¿â²âÊÔ´úÂë

oracleÁ¬½ÓÊý¾Ý¿â²âÊÔ´úÂë
/**
*
* ˵Ã÷£º
* £¨1£©±¾ÀýʹÓÃJDBC_ODBCÇŽøÐÐÊý¾Ý¿âÁ¬½Ó£¬¹Ê´ËÐèÒªODBCÊý¾ÝÔ´
* £¨2£©±¾ÀýÖÐSQLΪ¸üÐÂÓï¾ä£¬¹Ê´ËʹÓÃÔØÌåµÄexecuteUpdate·½·¨£¬²¢ÇÒ·µ»ØÊÜÓ°Ïì¼Ç¼Êý
* (3) ÅäÖÃÁ¬½ÓORACLEµÄodbcÊý¾ÝÔ´ora
*/
//µ¼ÈëËùÐèÀà°ü
import java.sql.*;
public class JdbcTestOra2 {
public static void main(String args[]) {
    try {
      //×°ÔØÇý¶¯³ÌÐò
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     
      //½¨Á¢Êý¾Ý¿âÁ¬½Ó
      Connection con =
DriverManager.getConnection("jdbc:odbc:ora","scott","tiger");
     
      //´´½¨SQLÓï¾äÔØÌå
      Statement st = con.createStatement();
     
      //Ö´ÐÐSQLÓï¾ä£¬½ÓÊÕÖ´Ðнá¹û
      int rs = st.executeUpdate("update emp set
comm=1000");
           
      //´¦Àí½á¹û
      System.out.println("Ð޸ļǼÊý£º"+rs);
     
      //ÊÍ·ÅÊý¾Ý¿â×ÊÔ´£¬×¢Òâ˳Ðò
      st.close();
      con.close();           
    }
    catch (Exception e) {
      e.printStackTrace(System


Ïà¹ØÎĵµ£º

Oracle RAC ¹éµµ Óë ·Ç¹éµµ Çл»


Oracle µÄÉú²ú¿â¶¼ÊÇÆô¶¯Ôڹ鵵ģʽÏ£¬RACϹ鵵·Ç¹éµµµÄÇл»ºÍµ¥ÊµÀýÒ²ÊÇÒ»ÑùµÄ£¬¶¼ÊÇÔÚMOUNTģʽÏÂÖ´ÐÐALTER DATABASE ARCHIVELOG/NOARCHIVELOG;ÃüÁî¡£ ²»Í¬µÄÊÇ£ºRAC»·¾³ÏÂËùÓÐʵÀý¶¼±ØÐë´¦ÓÚ·ÇOPEN״̬£¬È»ºóÔÚÈÎÒâÒ»¸ö´¦ÓÚMOUNT״̬µÄʵÀýÖ´ÐÐALTER DATABASEÃüÁ²Ù×÷³É¹¦ºó£¬ÔÙÕý³£Æô¶¯ ......

ORACLE ×óÓÒÁ´½Ó

Êý¾Ý±íµÄÁ¬½ÓÓÐ:
1¡¢ÄÚÁ¬½Ó(×ÔÈ»Á¬½Ó): Ö»ÓÐÁ½¸ö±íÏàÆ¥ÅäµÄÐвÅÄÜÔÚ½á¹û¼¯ÖгöÏÖ
2¡¢ÍâÁ¬½Ó: °üÀ¨
     £¨1£©×óÍâÁ¬½Ó(×ó±ßµÄ±í²»¼ÓÏÞÖÆ)
     £¨2£©ÓÒÍâÁ¬½Ó(ÓÒ±ßµÄ±í²»¼ÓÏÞÖÆ)
     £¨3£©È«ÍâÁ¬½Ó(×óÓÒÁ½±í¶¼²»¼ÓÏÞÖÆ)
3¡¢×ÔÁ¬½Ó(Á¬½Ó·¢ÉúÔÚÒ»Õ ......

OracleºÍMySQL¡¢PostgreSQLÌØÐÔ¶Ô±È

¡¡Ëæ×ÅÏÖ´úÊý¾Ý¿â¿ÉÓÃÌØÕ÷¼¯µÄѸËÙÔö¼Ó£¬ºÜÄÑÇø·ÖÊëºÃÊ뻵¡£ÀýÈçOracleÀï¾ÍÓÐÐí¶àÄã¿ÉÄÜ´ÓÀ´¶¼²»ÐèÒªµÄ¸ß¼¶Êý¾Ý²Ö¿âÌØÕ÷¡£´ËÍâÒ²¿ÉÄÜÓÐһЩÆäËü²»¿É»òȱµÄÌØÕ÷±ÈÈçACIDÊÂÎñÌØÐÔ¡£ÎÒÃÇÀ´¿´Ò»¿´Ö÷ÒªµÄÒ»Ð©ÌØÕ÷£¬±ÈÈç´æ´¢¹ý³Ì£¬ÊÓͼ£¬¿ìÕÕ£¬±íÊý¾ÝÀàÐͺÍÊÂÎñµÈµÈ¡£Í¬Ê±ÎÒÃÇ·ÖÎöÒ»ÏÂPostgresql£¬MySQLºÍOracleÕ⼸¸öÊý¾Ý¿â£¬È»º ......

Oracle wait problems and potential solutions

Wait Problem Potential Fix Sequential Read Indicates many index reads—tune the code (especially joins) Scattered Read Indicates many full table scans—tune the code; cache small tables ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ