Automatically disconnects after a database is started (about 10 minutes)
method One, directly modify the resource configuration file
Three steps to complete in a sqlplus environment.
The first step is to query the resource file and find the profile name where Connect_time is located.
Select Resource_name,profile from Dba_profiles;
The second step is to modify the value in the profile with the ALTER command;
Alter profile monitoring_profile limit Connect_time unlimited; (or with a time value, such as 1000, in minutes)
Alter profile monitoring_profile limit Idle_time unlimited;
The third step is to view the values in the profile with the following command;
Select Resource_name,limit from Dba_profiles where profile= ' monitoring_profile ';
method Two: It is done by creating a resource profile and assigning the user.
Three steps to complete in a sqlplus environment. [This method does not affect other database connection users]
The first step is to view and modify the status of the Resource_limit.
Sql>show parameter resource_limit; If False, it is modified to true, otherwise the configuration will not take effect:
Sql>alter system set Resource_file=true;
In the second step, create a new profile file with the Creation Profiles command:
Sql>create profile [profile filename] limit connect_time unlimited Idle_time unlimited;
[Example: Create profile Test_profile limit Connect_time unlimited Idle_time Unlimited;]
The third step is to assign this new profile to the user:
Sql>alter user [user_name, such as root_qy] profile [profile filename];
[Example: Alter user ROOT_QY profile Test_profile;]
Oracle automatically shuts down database connections