SOLVED

ORA-02394: Exceeded Session Limit On IO Usage

Asked by OracleDba••14 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
To fix it , Increase the value of LOGICAL_READS_PER_SESSION IN USER PROFILE.

ALTER PROFILE TEST LIMIT LOGICAL_READS_PER_SESSION UNLIMITED;

Hope it Helps!
OracleDba•

Post Your Solution