Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 10g°²×°µ½85%ʱ±¨´í

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

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

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

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

pl/sql - Oracle / ¿ª·¢

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

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ