Process inactive sessions

Session 1 in inactive state. Session status description: You can view the session status in the status column of the v $ session view.

SQL code STATUS VARCHAR2 (8) Status of the session: ACTIVE-Session currently executing SQL INACTIVE KILLED-Session marked to be killed CACHED-Session temporarily cached for use by Oracle * XA SNIPED-Session inactive, waiting on the client

 

2. Set the expire_time parameter 2.2 in the sqlnet. ora file for inactive processing. Set the idle_time parameter of the user profile to enable idle_time. Enable the RESOURCE_LIMIT parameter first. The default value is False.

SQL code show parameter resource; ALTER SYSTEM SET RESOURCE_LIMIT = TRUE SCOPE = BOTH; select * from dba_profiles; select username, profile from dba_users where username = 'cqcproduct '; alter profile default limit idle_time 10; -- restart oracle