ºìÁªLinuxÃÅ»§
Linux°ïÖú

oracleÖвÎÊýsessionºÍ processesµÄÉèÖÃ

·¢²¼Ê±¼ä:2006-10-19 21:55:17À´Ô´:ºìÁª×÷Õß:ckernel
1.sessions

ÔÚ³õʼ»¯²ÎÊýËùÉ趨µÄÏÞÖÆÖУ¬×îΪÈËËùÖªµÄ¹À¼Æ¾ÍÊÇsessionsºÍprocesses

Sessions ²ÎÊýÖ¸¶¨ÁËÒ»¸ö InstanceÖÐÄܹ»Í¬Ê±´æÔÚµÄsessionsÊýÁ¿£¬»òÕß˵£¬¾ÍÊÇÄÜͬʱµÇ½µ½Êý¾Ý¿âµÄ²¢·¢Óû§Êý¡£Í¨³££¬ÎÒÃÇÉ趨Õâ¸öÊý×ÖʱÐèÒª¿¼ÂÇÎÒÃÇ¿ÉÄÜ»áÓжàÉÙ¸öͬʱÁ¬½Óµ½Êý¾Ý¿âµÄ²¢·¢Óû§£¬²¢¼ÓÉϺǫ́½ø³ÌµÄ½ø³ÌÊý£¬×îºó³ËÓë1.1.

±ÈÈç˵£¬¹À¼ÆϵͳÖпÉÄÜ»áͬʱÓÐ100¸öÓû§Á¬½Óµ½Êý¾Ý¿â£¬ÄÇô£¬ÄãµÄsession×îÉÙÓ¦¸ÃΪ

(100 + 10 ) * 1.1 = 121

µ±Êý¾Ý¿âÁ¬½ÓµÄ²¢·¢Óû§ÒѾ­´ïµ½Õâ¸öֵʱ£¬ÓÖÓÐÐÂsessionÁ¬½øÀ´£¬¾Í»á±¨´í

00018, 00000, "maximum number of sessions exceeded"
// *Cause: All session state objects are in use.
// *Action: Increase the value of the SESSIONS initialization parameter.


2. Processes

ºÍSessionsÊÇÀàËƵÄÊÇprocessesÕâ¸ö²ÎÊý¡£

Processes²ÎÊýÖ¸¶¨ÁËInstanceÔÚOS²ãÃæËùÄÜͬʱÔËÐеĽø³ÌÊý¡£»ùÓÚºÍsessionsÉ趨ͬÑùµÄ¿¼ÂÇ£¬ÎÒÃÇÔÚÉ趨processesʱ£¬Ò²Ó¦¿¼ÂÇÎÒÃÇ¿ÉÄÜ»áÓжàÉÙ¸öͬʱÁ¬½Óµ½Êý¾Ý¿âµÄ²¢·¢Óû§£¬²¢¼ÓÉϺǫ́½ø³ÌµÄ½ø³ÌÊý¡£

µ±È»£¬ÔÚMTS(shared server)µÄÅäÖÃÏ£¬Õâ¸öÖµµÄÈ·¶¨»áÓÐËù²»Í¬¡£Ó¦¸ÃÊÇÆÕͨºǫ́½ø³Ì+×î´ó¹²Ïí·þÎñÆ÷µÄ½ø³ÌÊý(max_shared_servers) + ×î´óDispatcher½ø³ÌÊý(max_dispatchers).

ÁíÍ⣬ÓÉÓÚÔÚwindowƽ̨ÖУ¬OracleÊÇÒÔµ¥Ò»Ò»¸ö½ø³ÌµÄÐÎʽ´æÔÚ£¬Processes ²ÎÊý±ä³ÉÁËÏÞÖÆOracle½ø³ÌÀïµÄÏß³ÌÊýÁË¡£

µ±OracleÐèÒªÆô¶¯ÐµÄprocess¶øÓÖÒѾ­´ïµ½processes²ÎÊýʱ£¬¾Í»á±¨´í£º

00020, 00000, "maximum number of processes (%s) exceeded"
// *Cause: All process state objects are in use.
// *Action: Increase the value of the PROCESSES initialization parameter.
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ