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

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 ¾ø¶ÔÓ°ÏìÐÔÄÜ 
  ¶þÓÅ»¯Óï¾ä ûÓа󶨱äÁ¿ÊÇ×î´óµÄ¿ÉÄÜÔ­Òò

ÒýÓÃ
¹²Ïí³ØµÄ´óС ´óʦÃÇÒѾ­ÓÐ϶¨ÂÛ ¿ÉÒÔÉÏÍøÕÒÕÒ

³öÏÖ¹²Ïí³Ø²»¹»·ÖÅäµÄÇé¿ö Ò»¸ö¾ÍÊǼӴó¹²Ïí³Ø Õâ¸ö²»Öα¾ ³¬¹ý500M ¾ø¶ÔÓ°ÏìÐÔÄÜ
¶þÓÅ»¯Óï¾ä ûÓа󶨱äÁ¿ÊÇ×î´óµÄ¿ÉÄÜÔ­Òò

лл£¬ÎÒ»¹ÔÚÕÒÔ­Òò¡£

1.¿´sgaµÄ´óС£¬ÊÇ·ñʹÓÃ×Ô¶¯ÄÚ´æ¹ÜÀí£¬²ÎÊýÊDz»Ò»ÑùµÄ£¬ÄÚ´æ´óСÊÇ·ñÉèÖúÏÀí¡£
2.ϵͳÓÐûÓÐͬʱµ÷ÓñȽϴóµÄ°ü£¬²¢ÇÒûÓа󶨱äÁ¿£¬Èç¹ûÓо­³£µ÷Óõģ¬°Ñ°üpinµ½ÄÚ´æÀï
3.Õû¸öϵͳʹÓõÄsqlÊÇ·ñ°ó¶¨±äÁ¿£¬¾­³£Ê¹ÓõÄsql¿ÉÒÔpinµ½ÄÚ´æ
4.¹ý¶àµÄÈí½â


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔص½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

oracle ´æ´¢¹ý³Ì¸Ä³É ÊÂÎï Ôõôд°¡ - Oracle / ¿ª·¢

CREATE OR REPLACE PROCEDURE usp_refreshTopN
 IS
 BEGIN
 
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......

OracleÐÐתÁÐ - Oracle / ¸ß¼¶¼¼Êõ

select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó

SQL code:
wi ......

¸ß·ÖÇó½âOracleÊý¾Ý¿âµÄÁéÒìʼþ - Oracle / ¿ª·¢

½ñÌìÓöµ½Ò»¸öºÜ¹îÒìµÄÎÊÌâ¡£ÎÒÔÚÒ»ÕűíÖÐÐÂÔöÁËÒ»¸ö×ֶΡ£È»ºóÓÃÈçϽű¾¸üÐÂÕâ¸ö×ֶεÄÖµ£º
SQL code:

update ibp_fund_information_tab set yield = 7.4520 where fund_code = '040003' and info_date = ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ