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

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


²âÊÔ»·¾³»ù±¾ÐÅÏ¢£º
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µÄ·½Ê½²î¡£
 


Ïà¹ØÎĵµ£º

oracle database link

Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈ
ÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£ 
1¡¢   Á´½Ó×Ö·û´®¼´·þÎñÃû£¬Ê×ÏÈÔÚ±¾µØÅäÖÃÒ»¸ö·þÎñÃû£¬µØÖ·Ö¸ÏòÔ¶³ÌµÄÊý¾Ý¿âµØÖ·£¬·þÎñÃûȡΪ½«À´ÄãҪʹÓõÄÊý¾Ý¿âÁ´Ãû£º
2¡¢´´½¨Êý¾Ý¿âÁ´½Ó£¬
½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁî£ ......

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


¹ØϵÐÍÊý¾Ý¿âÀíÂÛÖÐ×Ö¶ÎÖµ±ØÐëÊǵ¥Öµ£¬¶øoracleÖÐÔÊÐíÔÚÒ»¸ö×Ö¶ÎÖд洢һ¸ö±íµÄÄÚÈÝ¡£
È磺Ա¹¤±íÖеÄÍâ¼ü ²¿ÃűàºÅ£¬oracleÖÐÕâ¸ö×ֶοÉÒÔ´æ·Å²¿ÃŵļǼ¶ø²¢²»ÊÇÒ»¸öÍâ¼ü£¬ÕâÑù²éѯʱºòµÄЧÂÊ»áÌá¸ß¡£
¿É±äÊý×飺
´´½¨´øÓпɱäÊý×éµÄ±í
´´½¨¿É±äÊý×é»ùÀàÐÍ
create or replace type »ùÀàÐÍÃû as object(×Ö¶ÎÇåµ¥); ......

Oracle RAC ³£ÓÃά»¤¹¤¾ßºÍÃüÁî


Oracle µÄ¹ÜÀí¿ÉÒÔͨ¹ýOEM»òÕßÃüÁîÐнӿڡ£ Oracle ClusterwareµÄÃüÁ¿ÉÒÔ·ÖΪÒÔÏÂ4ÖÖ£º
½Úµã²ã£ºosnodes
ÍøÂç²ã£ºoifcfg
¼¯Èº²ã£ºcrsctl, ocrcheck,ocrdump,ocrconfig
Ó¦Óò㣺srvctl,onsctl,crs_stat
ÏÂÃæ·Ö±ðÀ´½éÉÜÕâЩÃüÁî¡£ 
Ò»£® ½Úµã²ã
Ö»ÓÐÒ»¸öÃüÁ¡¡osnodes£¬ Õâ ......

Oracle and IBM AIX 5.2 swapping and memory issues

Lately,
Jordan bank upgraded their ICBS banking software to Oracle 9i and
IDS9i. The Bank also moved from a decentralized to a centralized
system.
We were contracted to monitor and diagnose performance issues during the launching phase of the new system.
The IBM server was equipped with 32 GB o ......

ÔÚOracleÖÐʹÓÃ×Ô¶¯µÝÔöÁÐ

ÔÚOracleÖÐʹÓÃ×Ô¶¯µÝÔöÁÐ
Oracle 沒ÓÐ類ËÆ MS-SQL ¿ÉÒÔÖ±½ÓÐÞ¸Ä欄λ屬ÐÔ£¬設¶¨³É×Ô動編號欄룬ËùÒÔÎÒ們±Ø須͸過 Sequence Îï¼þµÄ nextval ·½·¨£¬È¡µÃÆäÏÂÒ»個Öµ£¬È»áá將´ËÖµÐÂÔöÖÁ TABLE ÖУ¬製Ôì³öÓÐ×Ô動編 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ