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

oracleÉèÖÃÓαê open_cursorsµÄ´óСÎÊÌâ ?

open_cursorsµÄÖµÉèÖÃÊDz»ÊÇÔ½´óÔ½ºÃ,Èç¹ûÉèÖôóµÄ»°,¶ÔʲôÓÐÓ°Ïì? 
It is important to set the value of OPEN_CURSORS high enough to prevent your application from running out of open cursors. The number will vary from one application to another. Assuming that a session does not open the number of cursors specified by OPEN_CURSORS, <span style="font-size:24px">there is no added overhead to setting this value higher than actually needed</span>.


ûӰÏ죬һ°ãдµÄºÃµÄ³ÌÐò£¬²»»á¹ý¶ÈʹÓÃcursor¡£

ÒýÓÃ
It is important to set the value of OPEN_CURSORS high enough to prevent your application from running out of open cursors. The number will vary from one application to another. Assuming that a session does not open the number of cursors specified by OPEN_CURSORS,there is no added overhead to setting this value higher than actually needed.


ûӰÏ죬һ°ãдµÄºÃµÄ³ÌÐò£¬²»»á¹ý¶ÈʹÓÃcursor¡£


  Really?

ÒýÓÃ
open_cursorsµÄÖµÉèÖÃÊDz»ÊÇÔ½´óÔ½ºÃ,Èç¹ûÉèÖôóµÄ»°,¶ÔʲôÓÐÓ°Ïì? 


ÉèÖùý´óµÄ»°£¬Èç¹û²¢·¢µÄʱºò£¬»á·ÃÎÊÓαêµÄ»°£¬ÄÇô»áʹӦÓÃÐÔÄܽµµÍ¡£

²Î¿¼£º
http://school.itzcn.com/special-spid-35.html
ÉÏÃæ½²½âµÄ±È½ÏÏêϸ£¬Ï£Íû¶ÔÂ¥Ö÷ÓÐËù°ïÖú¡£

²»ÊÇÔ½´óÔ½ºÃ£¬ºÏÊÊ×îºÃ¡£

ÊʺÏ×Ô¼ºµÄ²ÅÊÇ×îºÃµÄ¡£

¿Ï¶¨²»ÊÇÔ½´óÔ½ºÃ¡£Ò»°ãÀ´Ëµ¾¡Á¿ÉÙʹÓÃÓαꡣ¡£¡£ÓÈÆäÊÇ´óÓαê


Ïà¹ØÎÊ´ð£º

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

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

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

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

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ