PLSQL often automatically disconnects and loses connections-mysql tutorial

This is the case. many development colleagues use PLSQL for 8 hours at work. sometimes, after they go out to smoke or finish their meals at noon, when they come back to PLSQL, an error is reported and no response is returned.

This is the case. many development colleagues use PLSQL for 8 hours at work. sometimes, after they go out to smoke or finish their meals at noon, when they come back to PLSQL, an error is reported and no response is returned.

Problem background:

This is the case. many developers work 8 hours on PLSQL. sometimes, after they go out to smoke or finish lunch, they will return an error and report no response when they come back to PLSQL, after getting stuck for a long time, I had to log on to plsql again to make it take effect. I guess this is because the connection is invalid. this situation often happens and does not affect work efficiency and mood.

1. check the connection time of the following CONNECT_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>

How can we find the profile that the powerdesk user belongs? 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>

We can see that CONNECT_TIME is UNLIMITED and there is no limit. why is the plsql connection unresponsive?

2. use sqlplus for connection verification in cmd.

Sqlplus connection, no operation in the past 30 minutes, Operation again connected to the db, normal use, it seems this has nothing to do with Oracledb, should look at the plsql settings

3. set it in plsql.

Go to Tools of plsql, go to Preferences, select Connection type on the left, and select Check connection, as shown in 1.png:

This will be a little more stable. of course, you may not need to use PLSQL for one day. if you enter it again, it will be delayed for a while, but it will not fail in a short time.

PS: For subsequent problems, PLSQL keeps connecting. However, if you close the previously opened execution file or SQL window, it will still get stuck and report unresponded information, in this case, you only need to forcibly close PLSQL and re-open the login.

After Oracle 10g is installed, restart the system. if PLSQL is used for connection, no listening is reported.

ORA-03114 PLSQL process compilation disconnection error

Simple configuration of PLSQL connection to Oracle

Detailed description on performance improvement of PLSQL batch Forall operations

Use Oracle SQLDeveloper to connect to the database and create a user

Oracle PL/SQL Developer import and export data

Install the Oracle 11g and Oracle SQL Developer clients in 64-bit Windows 7

This article permanently updates the link address: