重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: oracle数据库因用户会话超过idle_time限制报错：ORA-0 [打印本页]

作者: ZhangQi 时间: 2025-7-18 19:17
标题: oracle数据库因用户会话超过idle_time限制报错：ORA-0
告警日志有如下报错：2025-07-15T11:11:46.313459+08:00
KILL SESSION for sid=(2833, 41138):
  Reason = profile limit idle_time
  Mode = KILL SOFT -/-/NO_REPLAY
  Requestor = PMON (orapid = 2, ospid = 2857, inst = 1)
  Owner = Process: USER (orapid = 195, ospid = 1000139)
  Result = ORA-0
2025-07-15T11:15:58.359455+08:00
KILL SESSION for sid=(5660, 4182):
  Reason = profile limit idle_time
  Mode = KILL SOFT -/-/NO_REPLAY
  Requestor = PMON (orapid = 2, ospid = 2857, inst = 1)
  Owner = Process: USER (orapid = 110, ospid = 1015076)
  Result = ORA-0
2025-07-15T11:32:46.550009+08:00
KILL SESSION for sid=(1924, 59330):
  Reason = profile limit idle_time
  Mode = KILL SOFT -/-/NO_REPLAY
  Requestor = PMON (orapid = 2, ospid = 2857, inst = 1)
  Owner = Process: USER (orapid = 194, ospid = 1033510)
  Result = ORA-0

告警日志多次出现报错，原因为Oracle数据库因用户会话超过idle_time限制（profile配置的空闲超时），由PMON进程自动终止了该会话，建议检查并调整用户的profile空闲时间限制.

查看该参数，发现设置为15，可以将它设置得更高或者直接UNLIMITED，如下图所示