- 07 Dec, 2023
- 0 Comments
- 28 Secs Read
ORA-02394: Exceeded Session Limit On IO Usage
Problem
SQL> select count(*) from dba_objects; select count(*) from dba_objects * ERROR at line 1: ORA-02394: exceeded session limit on IO usage, you are being logged off
This error comes, when the sessions exceeds the value of LOGICAL_READS_PER_SESSION defined in user profile. To fix it , We need to increase the value of LOGICAL_READS_PER_SESSION in the user profile.
Solution :
To fix it , Increase the value of LOGICAL_READS_PER_SESSION IN USER PROFILE.ALTER PROFILE TEST LIMIT LOGICAL_READS_PER_SESSION UNLIMITED;