oracle¹²ÏíÄÚ´æÎÊÌâ - Oracle / ¿ª·¢
java.sql.SQLException: ORA-04031: unable to allocate 26416 bytes of shared memory ("shared pool","SELECT * from ( SELECT rownu...","Typecheck heap","qry_text : qcpisqt")
Õâ¸öÎÊÌâ¸ÃÔõô½â¾ö£¿ÔÚÍøÉÏËÑÁËÏÂҲûÕÒµ½¾ßÌåµÄ½â¾ö·½°¸¡£
²¹³ä£ºÒòΪÎÒ²éѯµÄÊý¾ÝÁ¿±È½Ï´ó¡£
°Ñshared_pool_sizeÖµµ÷´óÒ»µã
³öÏÖÕâ¸ö´íÎó£¬Òâζ×Åshare poolµÄÕùÓã¬share pool²»×ãÊÇÒ»¸ö±íÏ󣬷ÖÎöÄãµÄϵͳÊÇ·ñÕæµÄÊÇÄÚ´æ·ÖÅä²»¹»µ¼Ö£¬»¹ÊÇÒòΪûÓÐʹÓù²ÏíSQL£¬µ¼ÖµÄshare poolËéƬ¡£
ÎÒƴдµÄsqlȷʵÊÇÓеã´ó£¬²»ÖªµÀÕâ¸öÎÊÌâÊÇÓÉÓÚsql¹ý´óÒýÆðµÄ»¹ÊÇÊý¾ÝÁ¿±È½Ï´óÒýÆðµÄ¡£
Äã¿´ÏÂÄãµÄ¹²Ïí³Ø´óСÊǶà´ó,²»¿ÉÄÜ»áÕ¼Âú¹²Ïí³ØµÄ,2Â¥µÄ·ÖÎöÓеãµÀÀí,¿Éϧ»¹Ã»ÓÐѧµ½Ïà¹Ø֪ʶ...
java3344520
¿É·ñÁôÏÂQQÎÒÃǽ»Á÷Ò»ÏÂ
¹²Ïí³ØµÄ´óС ´óʦÃÇÒѾÓÐ϶¨ÂÛ ¿ÉÒÔÉÏÍøÕÒÕÒ
³öÏÖ¹²Ïí³Ø²»¹»·ÖÅäµÄÇé¿ö Ò»¸ö¾ÍÊǼӴó¹²Ïí³Ø Õâ¸ö²»Öα¾ ³¬¹ý500M ¾ø¶ÔÓ°ÏìÐÔÄÜ
¶þÓÅ»¯Óï¾ä ûÓа󶨱äÁ¿ÊÇ×î´óµÄ¿ÉÄÜÔÒò
лл£¬ÎÒ»¹ÔÚÕÒÔÒò¡£
1.¿´sgaµÄ´óС£¬ÊÇ·ñʹÓÃ×Ô¶¯ÄÚ´æ¹ÜÀí£¬²ÎÊýÊDz»Ò»ÑùµÄ£¬ÄÚ´æ´óСÊÇ·ñÉèÖúÏÀí¡£
2.ϵͳÓÐûÓÐͬʱµ÷ÓñȽϴóµÄ°ü£¬²¢ÇÒûÓа󶨱äÁ¿£¬Èç¹ûÓо³£µ÷Óõģ¬°Ñ°üpinµ½ÄÚ´æÀï
3.Õû¸öϵͳʹÓõÄsqlÊÇ·ñ°ó¶¨±äÁ¿£¬¾³£Ê¹ÓõÄsql¿ÉÒÔpinµ½ÄÚ´æ
4.¹ý¶àµÄÈí½â
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔص½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
CREATE OR REPLACE PROCEDURE usp_refreshTopN
IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó
SQL code:
wi ......
½ñÌìÓöµ½Ò»¸öºÜ¹îÒìµÄÎÊÌâ¡£ÎÒÔÚÒ»ÕűíÖÐÐÂÔöÁËÒ»¸ö×ֶΡ£È»ºóÓÃÈçϽű¾¸üÐÂÕâ¸ö×ֶεÄÖµ£º
SQL code:
update ibp_fund_information_tab set yield = 7.4520 where fund_code = '040003' and info_date = ......