SQL> select name, type, value from V$SYSTEM_PARAMETER where name = ‘processes’ or name=’sessions’; NAME TYPE VALUE —————————————- ———- —————————————- processes 3 40 sessions 3 49 ※SESSIONS 기본값 = (11 × PROCESSES) + 5 SPFILE확인하기
SQL> select value from v$system_parameter where name ='spfile'; VALUE ---------------------------------------------------------------------------------------------------- C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA변경하기
alter system set sessions=201 scope=spfile; alter system set processes=201 scope=spfile;※Oracle 재시작인 필요함. 그외 유용한 쿼리
SQL> select * from v$license; SQL> SELECT * FROM V$RESOURCE_LIMIT WHERE RESOURCE_NAME = 'processes' OR RESOURCE_NAME = 'sessions';참고사이트: http://d.hatena.ne.jp/teraliso/20080526]]>