跟你的用户profile里的connet_time时间有关吧 select username,profile from dba_users alter profile profile_name connet_time 600; 试一试
超时了,或者会话被kill掉了或者网络原因 掉线了
如何设置不超时或者不被kill。
你看下数据库的配置文件profile里的idle_time这个参数呢?通过这个参数可以实现,对数据库空闲一定时间的session自动断开。 idle_time: Specify the permitted periods of continuous inactive time during a session, expressed in minutes. Long-running queries and other operations are not subject to this limit.
select username,profile from dba_users
alter profile profile_name
connet_time 600;
试一试
idle_time:
Specify the permitted periods of continuous inactive time during a session, expressed in minutes. Long-running queries and other operations are not subject to this limit.
或者配置文件的问题 找dba 看看你用户的配置文件