Navicat for oracle to connect to a remote database, every moment will be submitted to the oracle database not connected, only to restart

CodePudding user response:

Should be in oracle profile connect_time limits, the maximum connection time, first look at what this parameter is
Select * from dba_profiles

CodePudding user response:

Select * from dba_profiles where RESOURCE_NAME=upper (' connect_time ');

CodePudding user response:

PROFILE LIMIT
The DEFAULT CONNECT_TIME KERNEL UNLIMITED
MONITORING_PROFILE CONNECT_TIME KERNEL DEFAULT

CodePudding user response:

See MONITORING_PROFILE zha configuration inside, your users whether to use this profile

CodePudding user response:

Select the username, profile from DBA_USERS

CodePudding user response:

Is being used when disconnected, or for a while you will not disconnect?

CodePudding user response:

For the user's profile is default,,, it is about 20 minutes or so do not use will be broken, restart to connect

CodePudding user response:

Using PLSQL won't disconnect

CodePudding user response:

I also encountered this problem, my colleagues with plsqldeveloper is completely normal, change the connection tools!

CodePudding user response:

This problem should be how to solve? The solution? O method

CodePudding user response:

reference 5 floor js14982 reply:

select the username, profile from DBA_USERS

have this table

CodePudding user response:

Connection properties - senior - keep connection between 240.
over

CodePudding user response:

refer to 12 floor qq_38054119 reply:

connection properties - senior - keep connection between 240.
Over

Feel the answer, I will try later