¹ØÓÚoracle session - Oracle / ¿ª·¢
½ñÌ챨Á˸öÒì³£ java.sql.SQLException: ORA-00018: maximum number of sessions exceeded
ÏëÖªµÀ oracle ÔÚʲôʱºò´´½¨session ʲôʱºò ¹Ø±Õsession Ϊʲô»á³öÕâ¸öÎÊÌâ
ÎÒдµÄÊǸö ÎÞÏÞÑ»· ´´½¨Á¬½ÓÔÚÑ»·ÍâÃæ´´½¨µÄ¡£¡£
¹â¿´ÄãÏÖÔÚµÄÒì³££¬Ó¦¸ÃÊÇÄã³ÌÐò´´½¨µÄsessionÊý£¬³¬¹ýÁËoracleµÄ×î´óÁ¬½ÓÊýprocesses¡£
SQL code:
SQL> show parameter sessions
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
sessions integer 203
shared_server_sessions integer
SQL> alter system set sessions = 300;
alter system set sessions = 300
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL> alter system set sessions = 300 scope = spfile;
System altered.
ÄãÐèÒªÐÞ¸ÄÄãµÄ»á»°Êý
È»ºó
shutdown immediate
startup
ÁíÍâ¿ÉÒÔ¿¼ÂÇÔÚ´´½¨sessionǰ×öһЩÅжϺʹ¦Àí
ÒòΪsession¶àÉÙÒª¸ù¾ÝÖ÷»úµÄÓ²¼þÅäÖþö¶¨£¬²»ÊÇ¿ÉÒÔËæÒâÔö¼ÓµÄ
²»ÄÜ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇ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 ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......
SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from t_out_logon) A WHERE ROWNUM <= 30)WHERE RN >= 21
SELECT A.* from (SELECT t.*,rownum rn from t_out_logon t WHERE ROWNUM <= 30) A WHERE ......