ORACLE automatically disconnects the database

Method 1: directly modifying the resource configuration file is completed in the sqlplus environment in three steps. Step 1: query the resource file and find the profile name of CONNECT_TIME. Select resource_name, profile from dba_profiles; Step 2, use the alter command to modify the value in the profile; alter profile MONITORING_PROFILE limit connect_time unlimited; (or follow a time value, such as 1000, in minutes) alter profile MONITORING_PROFILE limit idle_time unlimited; step 3, run the following command to view the values in profile: select resource_name, limit from dba_profiles where profile = 'monitoring _ PROFILE '; Method 2: you can create a resource configuration file and allocate it to users. The SQL plus environment is completed in three steps. [This method does not affect other database connection users] Step 1: view and modify the resource_limit status. Www.2cto.com SQL> show parameter resource_limit; if it is FALSE, change it to TRUE; otherwise, the configuration will not take effect: SQL> alter system set resource_file = true; Step 2, use the create profile command to create a new profile file: SQL> create profile [profile file name] limit connect_time unlimited idle_time unlimited; [Example: create profile test_profile limit connect_time unlimited idle_time unlimited;] step 3: Assign the new configuration file to the user: SQL> alter user [user_name, such as ROOT_QY] profile [profile file name]; [Example: alter user root_qy profile test_profile;] author chengyue2007