²»°²×°Oracle¿Í»§¶ËÁ¬½ÓOracle
ÔÀ´Á¬½ÓORACLE×ÜÊÇҪװORACLE¿Í»§¶Ë£¬Í¦Âé·³µÄ£¬Ò»·½ÃæÒª´øORACLEµÃÅÌ£¬ÁíÒ»·½Ã棬װÕâô´óµÃ¶«Î÷Ò²ÈÃÈ˺ܲ»Ë¬¡£Oracle´Ó10g¿ªÊ¼Ð³öÁËÒ»¸öInstant Client£¬ÊÇÕë¶ÔWINDOWSƽ̨µÄ£¬²»Óð²×°¿Í»§¶Ë¾Í¿ÉÒÔÁ¬½ÓOracleÊý¾Ý¿â¡£Instant ClientÊÇÒ»¸ö½ÏΪÇáÁ¿¼¶µÄ¿Í»§°ü£¬Êµ¼ÊÊÇÒ»¸özipÎļþ£¬40¶àM£¬²»ÐèÒª°²×°£¬Ö±½Ó½âѹËõ£¬¿ÉÒԺͳÌÐòÒ»Æð´ò°ü£¬²»¹ýĿǰ²»ÄÜÁ¬½Ó8.1.7.4֮ǰµÄÊý¾Ý¿â¡£
1¡¢ÏÂÔØÏàÓ¦µÄ³ÌÐò£»
http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/htdocs/winsoft.html?_template=/ocom/print£¨ÖÐÎĵģ©
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html£¨Ó¢Îĵģ©
2¡¢½«Oracle Instatnt Client½âѹÖÁD:\instantclient
3¡¢½«Oracle ODBC½âѹÖÁD:\instantclient
4¡¢ÉèÖÃϵͳ»·¾³±äÁ¿£»
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK(»òSIMPLIFIED CHINESE_CHINA.ZHS16GBK)
TNS_ADMIN = D:\instantclient
LD_LIBRARY_PATH = D:\instantclient£¨¸Ã±äÁ¿¿ÉÄÜ¿ÉÒÔÊ¡ÂÔ£©
SQL_PATH = D:\instantclient
Oracle_home= D:\instantclient
Path = % Path %; D:\instantclient
5¡¢ÔÚD:\instantclientÖÐÓÃÌí¼ÓÈçÏÂÄÚÈݵÄÎļþ,ÎļþÃûΪtnsnames.ora
# tnsnames.ora Network Configuration File: D:\instantclient\tnsnames.ora
# Generated by Oracle configuration tools.
ORB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = local)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orb)
)
)
Òª°²×°ODBCµÄ»°ÏÂÔØInstant Client Package – ODBC£¬½âѹµ½D:\instantclient·¾¶Ï£¬È»ºóÔÙÃüÁîÌáʾ·ûÖÐÊäÈëodbc_install.exe¡££¨¼ÇµÃµ±Ç°Ä¿Â¼Ò»¶¨ÒªÊÇodbc_install.exeËùÔÚµÄĿ¼£¬Òª²»»á³ö´í£©
³£ÉèµÄ×Ö·û¼¯£º
Set nls_lang=simplified chinese_china.zhs16cgb231280
Set nls_lang=simplified chinese_china.ZHS16GBK
Set nls_lang=simplified chinese_china.Utf8
±¸×¢£º
instantclient-basic-win32-11.1.0.6.0.zip -Õâ¸öÊÇÖ§³ÖOracle 9i ÒÔÉϵİ棨²»°üÀ¨Oracle9i£©
instantclie
Ïà¹ØÎĵµ£º
Oracle´´½¨É¾³ýÓû§¡¢½ÇÉ«¡¢±í¿Õ¼ä¡¢µ¼Èëµ¼³ö¡¢...ÃüÁî×ܽá
//´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace zfmi_temp
tempfile 'D:\oracle\oradata\zfmi\zfmi_temp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//tempfile²ÎÊý±ØÐëÓÐ
//´´½¨Êý¾Ý±í¿Õ¼ä
create table ......
connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ¥ËµÀ´Êǽ«Ò»¸öÊ÷×´½á¹¹´æ´¢ÔÚÒ»ÕűíÀ±ÈÈçÒ»¸ö±íÖдæÔÚÁ½¸ö×Ö¶ ......
COMMITÊÇÒ»¸ö·Ç³£¿ìµÄ²Ù×÷£¬µ±ÎÒÃÇ·¢²¼commitÃüÁîʱ£¬ÕæÕýÀ§Äѵ͝×÷ÒѾÍê³É£¬
ÔÚÊý¾Ý¿âÖÐÒѾִÐÐÁËÊý¾Ý¸ü¸Ä£¬ËùÒÔÒѾÍê³ÉÁË99%µÄÈÎÎñ£¬ÀýÈ磺ÏÂÁвÙ×÷ÒѾ²úÉú£º
1.ÔÚSGA(Buffer Cache)ÖÐÒѾÉú³ÉÁËundo¿é£»
2.ÔÚSGA(Buffer Cache)ÖÐÒѾÉú³ ......
ÓÐÁ½ÖÖº¬ÒåµÄ±í´óС¡£Ò»ÖÖÊÇ·ÖÅä¸øÒ»¸ö±íµÄÎïÀí¿Õ¼äÊýÁ¿£¬¶ø²»¹Ü¿Õ¼äÊÇ·ñ±»Ê¹Ó᣿ÉÒÔÕâÑù²éѯ»ñµÃ×Ö½ÚÊý£º
select segment_name, bytes
from user_segments
where segment_type = 'TABLE';
»òÕß
Select Segment_Name,Sum(bytes)/1024/1024 from User_Extents Group By Segment_Name
ÁíÒ»ÖÖ±íʵ¼ÊÊ¹Ó ......
BLOBµÄº¬Òå¡¡¡¡
BLOB (binary large object)£¬¶þ½øÖÆ´ó¶ÔÏó£¬ÊÇÒ»¸ö¿ÉÒÔ´æ´¢¶þ½øÖÆÎļþµÄÈÝÆ÷¡£
¡¡¡¡ÔÚ¼ÆËã»úÖУ¬BLOB³£³£ÊÇÊý¾Ý¿âÖÐÓÃÀ´´æ´¢¶þ½øÖÆÎļþµÄ×Ö¶ÎÀàÐÍ¡£
¡¡¡¡BLOBÊÇÒ»¸ö´óÎļþ£¬µäÐ͵ÄBLOBÊÇÒ»ÕÅͼƬ»òÒ»¸öÉùÒôÎļþ£¬ÓÉÓÚËüÃǵijߴ磬±ØÐëʹÓÃÌØÊâµÄ·½Ê½À´´¦Àí£¨ÀýÈ磺ÉÏ´«¡ ......