1 2 3 4 5 6 |
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확인하기
1 2 3 4 5 |
SQL> select value from v$system_parameter where name ='spfile';
VALUE
----------------------------------------------------------------------------------------------------
C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA |
변경하기
1 2 |
alter system set sessions=201 scope=spfile;
alter system set processes=201 scope=spfile; |
※Oracle 재시작인 필요함.
그외 유용한 쿼리
1 2 |
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