Oracle ×Ö¶ÎÀàÐÍ
Oracle ×Ö¶ÎÀàÐÍ
×Ö¶ÎÀàÐÍ
ÃèÊö
×ֶγ¤¶È¼°Æäȱʡֵ
CHAR (size )
ÓÃÓÚ±£´æ¶¨³¤(size)×Ö½ÚµÄ×Ö·û´®Êý¾Ý¡£
ÿÐж¨³¤£¨²»×㲿·Ö²¹Îª¿Õ¸ñ£©£»×î´ó³¤¶ÈΪÿÐÐ2000×Ö½Ú£¬È±Ê¡ÖµÎªÃ¿ÐÐ1×Ö½Ú¡£ÉèÖó¤¶È(size)Ç°Ð迼ÂÇ×Ö·û¼¯Îªµ¥×Ö½Ú»ò¶à×Ö½Ú¡£
VARCHAR2 (size )
ÓÃÓÚ±£´æ±ä³¤µÄ×Ö·û´®Êý¾Ý¡£ÆäÖÐ×î´ó×Ö½Ú³¤¶ÈÓÉ(size)Ö¸¶¨¡£
ÿÐг¤¶È¿É±ä£¬×î´ó³¤¶ÈΪÿÐÐ4000×Ö½Ú¡£ÉèÖó¤¶È(size)Ç°Ð迼ÂÇ×Ö·û¼¯Îªµ¥×Ö½Ú»ò¶à×Ö½Ú¡£
NCHAR(size )
ÓÉ×Ö·û¼¯¾ö¶¨±£´æµÄÊǶ¨³¤(size£©µÄ×Ö·û»ò×Ö½Ú¡£
ÿÐж¨³¤£¨²»×㲿·Ö²¹Îª¿Õ¸ñ£©¡£ ¶Ô¹Ì¶¨¿í¶ÈµÄ×Ö·û¼¯À´Ëµ£¬³¤¶È(size£©ÊÇÖ¸×Ö·ûµÄ¸öÊý£¬¶Ô±ä¿íµÄ×Ö·û¼¯À´Ëµ£¬³¤¶È(size£©ÊÇÖ¸×ֽڵĸöÊý¡£×î´ó³¤¶È(size£©È¡¾öÓÚ±£´æÔÚÒ»¸ö×Ö·ûÖеÄ×ֽڵij¤¶È£¬Ã¿ÐеÄ×î´ó³¤¶ÈΪ2000×Ö½Ú¡£ÓÉ×Ö·û¼¯¾ö¶¨È±Ê¡ÖµÎª1¸ö×Ö·û»ò1¸ö×Ö½Ú¡£
NVARCHAR2 (size )
ÓÉ×Ö·û¼¯¾ö¶¨±£´æ±ä³¤µÄ×Ö·û»ò×Ö½Ú¡£ÆäÖÐ×î´ó³¤¶ÈÓÉ(size)Ö¸¶¨¡£
ÿÐб䳤¡£¶Ô¹Ì¶¨¿í¶ÈµÄ×Ö·û¼¯À´Ëµ£¬³¤¶È(size£©ÊÇÖ¸×Ö·ûµÄ¸öÊý£¬¶Ô±ä¿íµÄ×Ö·û¼¯À´Ëµ£¬³¤¶È(size£©ÊÇÖ¸×ֽڵĸöÊý¡£×î´ó³¤¶È(size£©È¡¾öÓÚ±£´æÔÚÒ»¸ö×Ö·ûÖеÄ×ֽڵij¤¶È£¬Ã¿ÐеÄ×î´ó³¤¶ÈΪ4000×Ö½Ú¡£ÓÉ×Ö·û¼¯¾ö¶¨È±Ê¡ÖµÎª1¸ö×Ö·û»ò1¸ö×Ö½Ú¡£
LONG
±£´æ±ä³¤µÄ×Ö·û´®Êý¾Ý¡£
ÔÚ±íÖÐÿÐеij¤¶È¿É±ä£¬×î´ó³¤¶ÈΪÿÐÐ231 - 1×Ö½Ú»ò2G¡£
NUMBER (p, s )
±£´æ±ä³¤µÄÊý×Ö¡£ÆäÖо«¶ÈµÄ×î´óֵΪp£¬ºÍ/»òÓÐЧµÄÊý×ÖλÊýsµÄ×î´óÖµ38¡£
ÿÐб䳤¡£Ã¿ÐеÄ×î´ó³¤¶ÈΪ21×Ö½Ú¡£
DATE
±£´æ¶¨³¤µÄÈÕÆÚ»òʱ¼äÊý¾Ý£¬·¶Î§Îª¹«ÔªÇ°4712/01/01µ½¹«Ôª9999/12/31¡£
ÿÐй̶¨Îª7×Ö½Ú³¤¶È£¬È±Ê¡ÖµµÄÈÕÆÚÃèÊö£¨ÀýÈçDD-MON-YY£©ÓÉNLS_DATE_FORMAT²ÎÊýÉèÖá£
RAW (size )
±£´æ±ä³¤µÄ¶þ½øÖÆÊý¾Ý¡£×î´ó³¤¶ÈÓÉsizeÖ¸¶¨¡£
ÔÚ±íÖÐÿÐеij¤¶È¿É±ä£¬×î´ó³¤¶ÈΪÿÐÐ2000×Ö½Ú¡£
LONG RAW
±£´æ±ä³¤µÄ¶þ½øÖÆÊý¾Ý¡£
ÔÚ±íÖÐÿÐеij¤¶È¿É±ä£¬×î´ó³¤¶ÈΪÿÐÐ231 - 1×Ö½Ú»ò2G¡£
BLOB
±£´æ¶þ½øÖÆÊý¾Ý¡£
×î´ó³¤¶ÈΪ232 - 1×Ö½Ú»ò4G¡£
CLOB
±£´æµ¥×Ö½Ú×Ö·ûÊý¾Ý¡£
×î´ó³¤¶ÈΪ232 - 1×Ö½Ú»ò4G¡£
NCLOB
±£´æÓÉ×Ö·û¼¯Ö¸¶¨µÄµ¥×Ö½Ú»ò¹Ì¶¨¿í¶È¶à×Ö½Ú»ò±ä¿í¶à×Ö½ÚµÄ×Ö·ûÊý¾Ý¡£
×î´ó³¤¶ÈΪ232 - 1×Ö½Ú»ò4G¡£
BFILE
±£´æÔÚÍⲿÎļþµÄ¶þ½øÖÆÊý¾Ý¡£
×î´ó³¤¶ÈΪ232 - 1×Ö½Ú»ò4G¡£
Char ÓÃÓÚÃèÊö¶¨³¤µÄ×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=2000×Ö½Ú
var
Ïà¹ØÎĵµ£º
ÒÔÏÂÒÔ½ØͼÐÎʽ¼òÊö¹ØÓÚÔÚIBMСÐÍ»úÉÏ°²×°µ¥»ú°æOracleÊý¾Ý¿âµÄ¹ý³Ì¡£ÒÔ¹©´ó¼Ò²Î¿¼£¬ÒÔ±ã¶ÔÓÚIBMСÐÍ»ú&AIX&Oracle½øÐгõ²½µÄÁ˽⡣ Machine£ºIBM POWER 520 OS&Version£ºAIX_5300-07 Oracle Version:10.2.0.1 ÒÔÏÂÊÇÏêϸ½Øͼ£º 1_OS_Check&Filesets_Check 2_ÀûÓÃsmitty installpÃüÁî½øÈëÈí¼þ£¨°ü£ ......
ÔÚÊý¾Ý¿âµÄÈÕ³£Ñ§Ï°ÖУ¬·¢ÏÖ¹«Ë¾Éú²úÊý¾Ý¿âµÄĬÈÏÁÙʱ±í¿Õ¼ätempʹÓÃÇé¿ö´ïµ½ÁË30G£¬Ê¹ÓÃÂÊ´ïµ½ÁË100%£»´ýµ÷ÕûΪ32Gºó£¬Ê¹ÓÃÂÊ»¹ÊÇΪ100%£¬µ¼Ö´ÅÅÌ¿Õ¼äʹÓýôÕÅ¡£¸ù¾ÝÁÙʱ±í¿Õ¼äµÄÖ÷ÒªÊǶÔÁÙʱÊý¾Ý½øÐÐÅÅÐòºÍ»º´æÁÙʱÊý¾ÝµÈÌØÐÔ£¬´ýÖØÆôÊý¾Ý¿âºó£¬temp»á×Ô¶¯ÊÍ·Å¡£ÓÚÊÇÏëͨ¹ýÖØÆôÊý¾Ý¿âµÄ·½Ê½À´»º½âÕâÖÖÇé¿ö£¬µ«ÊÇÖØÆôÊý¾Ý ......
latchÊÇÓÃÓÚ±£»¤Äڴ棨ϵͳȫ¾ÖÇø£¬SGA£©ÖеĹ²ÏíÄÚ´æ½á¹¹µÄ»¥³â»úÖÆ¡£Latch¾ÍÏñÊÇÄÚ´æÉϵÄËø£¬¿ÉÒÔÓÉÒ»¸ö½ø³Ì·Ç³£¿ìËٵؼ¤»îºÍÊÍ·Å£¬ÓÃÓÚ·ÀÖ¹¶ÔÒ»¸ö¹²ÏíÄÚ´æ½á¹¹½øÐв¢ÐзÃÎÊ¡£Èç¹ûlatch²»¿ÉÓã¬ÄÇô½«¼Ç¼latchÊÍ·Åʧ°Ü¡£¾ø´ó¶àÊýlatchÎÊÌⶼÓëûÓÐʹÓð󶨱äÁ¿£¨library-cache latch£¨¿â»º´ælatch£©£©¡¢ÖØ×öÈÕÖ¾Éú³ÉÎÊÌâ ......
http://www.puschitz.com/InstallingOracle10g.shtml
ÎÒÓõÄÊÇCentos5.4
DVD¹âÅÌ°²×°µÄlinux²Ù×÷ϵͳ£¬°²×°linuxµÄʱºòÑ¡ÉÏ¿ª·¢¹¤¾ß£¬Xmanager,ÓëÊý¾Ý¿âÏà¹ØµÄ°ü¡£
²Ù×÷ϵͳ°²×°Íê³ÉÖ®ºóÐèÒª½øÐÐһϵÁеÄÅäÖòÅÄÜ°²×°oracle10g£¬ÏÂÃæ°Ñ
Ö÷Òª²½Öè¼Ç¼ÏÂÀ´¡£
1.°²×°Íê²Ù×÷ϵͳ֮ºó»¹ÊÇÓÐЩ°üûÓа²×°£¬È»¶ø°²×°oracle10 ......
Oracle Êý¾Ý¿â 11gÃæÏò DBA ºÍ¿ª·¢ÈËÔ±µÄÖØÒªÐÂÌØÐÔ:SecureFiles£º
1¡¢SecureFiles£ºÐ LOB
Á˽âÈçºÎʹÓÃÐÂÒ»´ú LOB£ºSeureFiles¡£SecureFiles ¼¯ÍⲿÎļþºÍÊý¾Ý¿â LOB ·½·¨µÄÓŵãÓÚÒ»Éí£¬¿ÉÒÔ´æ´¢·Ç½á¹¹»¯Êý¾Ý£¬ÔÊÐí¼ÓÃÜ¡¢Ñ¹Ëõ¡¢Öظ´Ïû³ýµÈµÈ¡£
Êý¾Ý¿âפÁô BLOBS »ò OS Îļþ
ÄúÔÚ Oracle Êý¾Ý¿âÖÐ ......