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 {
 
Ïà¹ØÎĵµ£º
sql plus ±£´æsqlÓï¾ä
save 'd:\sql.txt';½«oracle»º´æÇøÖеÄsqlÓï¾ä´æÈëÎļþ¡£
get 'd:\sql.txt';´ËʱsqlÓï¾ä±»¼ÓÔص½oracle»º´æÇø£¬Ê¹ÓÃrun;ÃüÁîÖ´ÐÐsqlÓï¾ä¡£
@'d:\sql.txt';¼ÓÔØsqlÓï¾ä²¢Ö±½ÓÖ´ÐС£
oracleÖеĺ¯Êý
1. ת»»º¯Êý
TO_CHAR(number[,format])
½«Ò»¸öÊýֵת»»³ÉÓëÖ®µÈ¼ÛµÄ×Ö·û´®.Èç¹û²»Ö¸ ......
±¾ÎĽéÉÜÁËORACLEÖ´Ðмƻ®µÄһЩ»ù±¾¸ÅÄ¹©Ñ§Ï°Ó¦Óá£
Ò»£®Ïà¹ØµÄ¸ÅÄî
RowidµÄ¸ÅÄrowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊDZíÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ ......
Îҵݲװ¹ý³Ì
1¡¢±à¼ /etc/apt/sources.list £º
sudo cp /etc/apt/sources.list /etc/apt/sources.list.bak #±¸·Ý
sudo gedit /etc/apt/sources.list
¼ÓÈëÏÂÃæÕâ¸öÔ´£º
deb http://oss.oracle.com/debian unst ......
¡í1:È¡µÃµ±Ç°ÈÕÆÚÊDZ¾Ôµĵڼ¸ÖÜ
SQL> select to_char(sysdate,'YYYYMMDD W HH24:MI:SS') from
dual;
TO_CHAR(SYSDATE,'YY
-------------------
20030327 4 18:16:09
SQL> select to_char(sysdate,'W') from dual;
T
-
4 ......