2022-01-06T13:59:20.965999+09:00
KILL SESSION for sid=(1356, 24250):
Reason = profile limit idle_time
Mode = KILL SOFT -/-/NO_REPLAY
Requestor = PMON (orapid = 2, ospid = 44123, inst = 1)
Owner = Process: USER (orapid = 234, ospid = 39534)
Result = ORA-0
IDLE_TIME 셋팅값 확인 필요 ..
select PROFILE
, RESOURCE_NAME
, RESOURCE_TYPE
, LIMIT
, COMMON
from dba_profiles
where profile = 'DEFAULT'
order by 1,2;
ALTER PROFILE DEFAULT LIMIT IDLE_TIME UNLIMITED;
늘려줘야 할지 말지는 고민이됨~~