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

Ò»¸öoracleСÎÊÌâ

ÎÒÓиöcontent×ֶΣ¬´æµÄ¶¼ÊÇÖÐÎÄÄÚÈÝ£¬ºÜ¶à£¬ÎÒÓÃvarchar2(4000)ÀàÐÍÒ²²»¹»Óð¡
ÓÐʲô·½·¨¿ÉÒÔ±£´æ´óÁ¿µÄÖÐÎÄÄÚÈÝ£¿¸æËßÎÒÏÂ
ÓÃclobÀàÐÍ×ֶΰÉ

1  LOB£¨CLOB/BLOB£©
2  LONG
3  ·ÖÁÐ

ORACLE½¨ÒéʹÓÃLOB£¬ÁíÍâLONGÀàÐÍÒ»¸ö±íÖ»ÄÜÓÐÒ»ÁС£
Èç¹û8000ÒÔÄÚ£¬½¨Òé·ÖÁ½ÁУ¬LOB¸ø¹ÜÀíºÍÊý¾ÝÇ¨ÒÆ´øÀ´²»±ã

clob ×Ö·ûÐÍ´ó¶ÔÏ󣬿ÉÒÔ´æ´¢Îı¾ÐÍ×Ö·ûÊý¾Ý£¬×î´óÈÝÁ¿¿É´ï4GB
blob ¶þ½øÖÆ´ó¶ÔÏó£¬Ò»°ãÓÃÓڴ洢ͼƬµÈ¶þ½øÖÆÊý¾Ý£¬×î´óÈÝÁ¿¿É´ï4GB

ºÇºÇ£¬ÖªµÀÀ²£¬Ð»Ð»ÄãÃÇ£¬½áÌù


Ïà¹ØÎÊ´ð£º

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ