Ò»¸öoracleСÎÊÌâ
ÎÒÓиöcontent×ֶΣ¬´æµÄ¶¼ÊÇÖÐÎÄÄÚÈÝ£¬ºÜ¶à£¬ÎÒÓÃvarchar2(4000)ÀàÐÍÒ²²»¹»Óð¡
ÓÐʲô·½·¨¿ÉÒÔ±£´æ´óÁ¿µÄÖÐÎÄÄÚÈÝ£¿¸æËßÎÒÏÂ
ÓÃclobÀàÐÍ×ֶΰÉ
1 LOB£¨CLOB/BLOB£©
2 LONG
3 ·ÖÁÐ
ORACLE½¨ÒéʹÓÃLOB£¬ÁíÍâLONGÀàÐÍÒ»¸ö±íÖ»ÄÜÓÐÒ»ÁС£
Èç¹û8000ÒÔÄÚ£¬½¨Òé·ÖÁ½ÁУ¬LOB¸ø¹ÜÀíºÍÊý¾ÝÇ¨ÒÆ´øÀ´²»±ã
clob ×Ö·ûÐÍ´ó¶ÔÏ󣬿ÉÒÔ´æ´¢Îı¾ÐÍ×Ö·ûÊý¾Ý£¬×î´óÈÝÁ¿¿É´ï4GB
blob ¶þ½øÖÆ´ó¶ÔÏó£¬Ò»°ãÓÃÓڴ洢ͼƬµÈ¶þ½øÖÆÊý¾Ý£¬×î´óÈÝÁ¿¿É´ï4GB
ºÇºÇ£¬ÖªµÀÀ²£¬Ð»Ð»ÄãÃÇ£¬½áÌù
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
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 / ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......