 Logical Reads rising.... [message #150072] |
Tue, 06 December 2005 02:28  |
Efrem
Messages: 6
Registered: August 2004
|
Junior Member |
|
|
Hi everybody,
I have problem with a job that returns the following error:
"ORA-02394:exceeded session limit on IO usage, you are being logged off".
I tried to increase the value of logical read per session in the profile but nothing changed.
It could be an Oracle bug, that afflicts my oracle version.
Unfortunately I can't upgrade my oracle version so I have to find another workaround.
A solution could be set te RESOURCE_LIMIT parameter to false.
Now my question is: Which problems could I have doing this action?
The logical reads rising which database behaviours could change?
Hope I have explained well the problem.
Thanks to everybody.
Hi.
|
|
|
|
|
|
| Re: Logical Reads rising.... [message #150100 is a reply to message #150093] |
Tue, 06 December 2005 05:28  |
Efrem
Messages: 6
Registered: August 2004
|
Junior Member |
|
|
| Mahesh Rajendran wrote on Tue, 06 December 2005 04:42 |
by setting RESOURCE_LIMIT=FALSE, you disable all your resource settings.
Many of your PROFILE settings may not work.
>>Unfortunately I can't upgrade my oracle version so I have to find another workaround.
Unfortunately you have not provided the oracle version you are talking about. My guess is 8.0.X .
Did you also try setting LOGICAL_READS_PER_SESSION to unlimited?
In 9i even this may not work ( known bug).
|
My version is 8.1.7. I have already tried to set the LOGICAL_READS_PER_SESSION to unlimited but it didn't work (I know about the bug); that's why I asked information about setting the resource limit parameter.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
