OS환경 : Oracle Linux6.8(64bit)
DB 환경 : Oracle Database 11.2.0.4
방법 : 오라클 세션수 및 프로세스수 변경하기
기존 파라미터 값 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | col name for a10 col type for 99 col value for a10 select name, type, value from V$SYSTEM_PARAMETER where name in ('processes','sessions'); NAME TYPE VALUE ---------- ---- ---------- processes 3 150 sessions 3 247 또는 select * from v$resource_limit where resource_name in ('processes','sessions'); RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE ------------------------------ ------------------- --------------- -------------------- -------------------- processes 40 55 150 150 sessions 50 77 247 247 |
spfile 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | col value for a50 select value from v$system_parameter where name ='spfile'; VALUE ------------------------------------------------------------ /orcl/oracle/app/11.2.0/db/dbs/spfileORCLDB1.ora 또는 show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /orcl/oracle/app/11.2.0/db/dbs/spfileORCLDB1.ora |
변경하기
1 2 3 | alter system set sessions=200 scope=spfile; alter system set processes=200 scope=spfile; |
db 재시작
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. startup ORACLE instance started. Total System Global Area 320306616 bytes Fixed Size 740792 bytes Variable Size 285212672 bytes Database Buffers 33554432 bytes Redo Buffers 798720 bytes Database mounted. Database opened. |
변경 후 파라미터 값 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | col name for a10 col type for 99 col value for a10 select name, type, value from V$SYSTEM_PARAMETER where name in ('processes','sessions'); NAME TYPE VALUE ---------- ---- ---------- processes 3 200 sessions 3 225 또는 select * from v$resource_limit where resource_name in ('processes','sessions'); RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE ------------------------------ ------------------- --------------- -------------------- -------------------- processes 40 55 200 200 sessions 50 77 225 225 |
참조 :
'ORACLE > Sql' 카테고리의 다른 글
비정상 종료 후 복구 시간 모니터링(X$KTUXE) (0) | 2018.12.12 |
---|---|
dba_jobs 로 실패한 job 확인 (0) | 2018.12.06 |
유저별 Object 조회쿼리 (0) | 2018.12.05 |
oracle awr 스냅샷 snapshot 확인 및 주기 변경 (0) | 2018.11.16 |
oracle 지난달, 다음달 구하기 (0) | 2018.11.08 |