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

ORACLEÊý¾Ý¿â²åÈëÐÔÄܲâÊÔ

ORACLEÊý¾Ý¿â²åÈëÐÔÄܲâÊÔ
 
MKing
2010-3-8
 
²âÊÔ»·¾³»ù±¾ÐÅÏ¢£º
OS£ºWindows XP sp3
DB£ºOracle 9.2.0.1 δÆôÓù鵵
DBÖØ×öÈÕÖ¾Îļþ´óС£º100MB
Ó²ÅÌÐͺţºSAMSUNG HD161GJ£¨SATA-300,160G,7200rpm,8M cache£©
CPU£ºIntel Core2 E8400£¨3.0G£©
Äڴ棺2G
 
ͨ¹ýHD TuneµÃµ½µÄÓ²ÅÌ»ù±¾²âÊÔÐÅÏ¢£¬
IOPS£º66
¶ÁÈ¡£º90MB/s
дÈ룺82MB/s
 
²âÊÔ±í½Å±¾£º
 
create table T_EMPLOYEE
(
  ID            NUMBER(10) not null,
  NAME          VARCHAR2(20) not null,
  CREATE_DATE   DATE default sysdate not null,
  BIRTHDAY      DATE,
  ADDRESS       VARCHAR2(200),
  EMAIL         VARCHAR2(200),
  MOBILEPHONE   VARCHAR2(11),
  TELEPHONE     VARCHAR2(20),
  IDENTITY_CARD VARCHAR2(18),
  WEIGHT        NUMBER,
  HEIGHT        NUMBER
)
 
 
²åÈë10ÍòÌõ¼Ç¼£¬²ÉÓÃJava JDBC·½Ê½µÄ²âÊÔ½á¹ûÈçÏÂ(µ¥Î»£ºÃë)£º
 
Ö´Ðз½Ê½
OCI
TCP/IP
OCI
IPC
thin
AutoCommit=true
thin
AutoCommit=false
Statement(test1)
69.84
67.03
66.96
42.81
PreparedStatement(test2)
40
37.18
39.21
12.66
PreparedStatement Batch(test3)
51.72
50.78
2.81
2.81
 
 
´Ó²âÊÔ½á¹û¿ÉÒÔ¿´³ö£¬²ÉÓÃthinÁ¬½Ó·½Ê½ batch²åÈëµÄÐÔÄÜ×îºÃ£¬¶ø²ÉÓÃociµÄbatch²åÈëÐÔÄÜδµÃµ½Ìá¸ß£¬Ò²¿ÉÄÜÊÇbug¡£
¼ÇµÃÒÔÇ°ÔÚORACLEÎĵµÀï˵²ÉÓÃociģʽµÄÐÔÄÜ×îºÃ£¬9iÖо­¹ý²âÊÔÍêÈ«²»³ÉÁ¢£¬ÎÒÏë¿ÉÄÜÊÇÒÔÇ°java±¾ÉíÐÔÄܵÄÎÊÌ⣬ÏÖÔÚjavaÓïÑÔµÄÐÔÄÜÒѾ­·Ç³£ºÃÁË£¬thinÁ¬½Ó·½Ê½²»¹ÜÊÇ´Ó¹ÜÀí»¹ÐÔÄÜ·½ÃæÀ´Ëµ¶¼ÊÇÊ×Ñ¡ÁË¡£
 
×¢£º²ÉÓÃociµÄbatch²åÈëÐÔÄÜδµÃµ½Ìá¸ßȷʵÊÇBUG£¬ºóÀ´°ÑORACLE¿Í»§¶ËÉý¼¶µ½9.2.0.8£¬»¨µÄʱ¼äÖ»Òª6s£¬µ«»¹ÊDZÈthinµÄ·½Ê½²î¡£
 
ÒÔÏÂÊDzâÊÔ³ÌÐòÔ´Â룺
import java.sql.*;
import java.util.Calendar;
 
public class inserttest {
 


Ïà¹ØÎĵµ£º

Oracle¼¼ÊõÈËÔ±ÇóÖ°ÃæÊÔÌ⼯½õ

±¾ÎÄÊÇOracle¼¼ÊõÈËÔ±ÇóÖ°ÃæÊÔÌ⼯½õ£¬´ð°¸½ö¹©²Î¿¼……
¡¡¡¡1. ½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
¡¡¡¡½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄÊý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ ......

SQLServerºÍOracle³£Óú¯Êý¶Ô±È

SQLServerºÍOracleÊÇ´ó¼Ò¾­³£Óõ½µÄÊý¾Ý¿â£¬ÔÚ´Ë×ܽá³öÕâЩ³£Óú¯ÊýÒÔ¹©
´ó¼Ò²Î¿¼¡£
Êýѧº¯Êý
¡¡¡¡1.¾ø¶ÔÖµ
¡¡¡¡S:select abs(-1) value
¡¡¡¡O:select abs(-1) value from dual
¡¡¡¡2.È¡Õû(´ó)
¡¡¡¡S:select ceiling(-1.001) value
¡¡¡¡O:select ceil(-1.001) value from dual
¡¡¡¡3.È¡Õû£¨Ð¡£©
¡¡¡¡S:s ......

OracleÖÐto_char()²ÎÊýÏê½â

 1 -  /  ,  . ; :
"text" ʱ¼ä·Ö¸ô·ûºÅ£¬³ýÁ˱ê×¼µÄ¼¸¸ö£¬»¹ÔÊÐíÓÃÎÄ×Ö×÷Ϊ·Ö¸î·ûºÅ¡£
ÀýÈç to_char(sysdate,'YYYY"Äê"mm"ÔÂ"dd"ÈÕ"')=2008Äê04ÔÂ24ÈÕ
 2 AD
A.D.  ¼´À­¶¡ÎÄAnno DominiµÄ¼òд£¬±íʾ¹«Ôª.»á¸ù¾ÝnlsµÄ²»Í¬×ª»»Îª¹«Ôª»òÕßadµÈ
ÎÞÌØÊâ×¢ÒâÊÂÏî
 3 AM
A.M.  ÉÏ ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç11

´Ø£º
Óй«¹²ÁеÄÁ½¸ö»ò¶à¸ö±íµÄ¼¯ºÏ
´Ø±íÖеÄÊý¾Ý´æ´¢ÔÚ¹«¹²Êý¾Ý¿éÖÐ
´Ø¼ü£º
Ψһ±êʶ·û
´´½¨´Ø£º
¼õÉÙI/O²Ù×÷£¬¼õÉÙ´ÅÅ̿ռ䣬µ«ÊDzåÈëÐÔÄܽµµÍ¡£
Á½ÕűíÖÐÓй²Í¬µÄÁУ¬±ÈÈçѧÉú±íÖÐÓа༶±àºÅ£¬°à¼¶±íÖÐÒ²Óа༶±àºÅ£¬¿ÉÒÔ½«°à¼¶±àºÅ´æ·ÅÔÚ´ØÖÐ
create cluster ´ØÃû(
×Ö¶ÎÃû ÀàÐÍ
)tablespace ±íÃüÃû¿Õ¼ä;
cr ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ