Plsql often automatically disconnects the lost connection resolution process

Issue background:

This is the case, a lot of development colleagues plsql working hours open for 8 hours, sometimes they go out after smoking or after lunch, come back in Plsql above the error is not responding, and then stuck for a half-day to move, have to re-login plsql to take effect, I guess is because of the connection failure, Often encountered this situation, has not affected the efficiency and the work mood.

1, check out the followingConnect_timeThe connection time

Sql> SELECT * from Dba_profiles t wheret.resource_name= ' connect_time ';

Profile Resource_name Resource_type LIMIT

-------------------------------------------------------------- ------------------------------------------------- ----

DEFAULT connect_time KERNEL UNLIMITED

Monitoring_profile connect_time KERNEL DEFAULT

Tmpopt connect_time KERNEL DEFAULT

Myprofile connect_time KERNEL DEFAULT

Sql>

See there 4 one, how to find PowerDesk The one that the user belongs to Profile it? To view the current user's connect_time

Sql> select * from User_resource_limits;

Resource_name LIMIT

------------------------------------------------------------------------

Composite_limit UNLIMITED

Sessions_per_user UNLIMITED

Cpu_per_session UNLIMITED

Cpu_per_call UNLIMITED

Logical_reads_per_session UNLIMITED

Logical_reads_per_call UNLIMITED

Idle_time UNLIMITED

Connect_time UNLIMITED

PRIVATE_SGA UNLIMITED

9 Rows selected

Sql>

See Connect_time is unlimited, there is no limit, then why Plsql connection will appear unresponsive phenomenon?

Original Blog Address: http://blog.csdn.net/mchdba/article/details/48298577, did not pass the Bo Master agreed, declined reprint.

2,cmduse it inside.SqlplusConnection Verification

Sqlplus connection, the past 30 minutes do not operate, re-operation of the connection db, normal use, it seems this and oracledb irrelevant, should go to see Plsql set up

3, GoPlsqlinside Set

Enter Plsql tools, then enter preferences, then select Connection selection on the left, select Check Connection, as shown in 1.png:

This will be more stable, of course, you may plsq open a day without, then go in will delay a while, but the short time inside will not malfunction.

PS : Follow-up questions, Plsql Keep the connection open, but you close the previously opened execution file or SQL The window will still be stuck, reported not responding to the situation, this as long as forcibly closed Plsql re-opened the login.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Plsql often automatically disconnects the lost connection resolution process