| |
You are here: Experts > Computing/Technology > Oracle > Oracle > Inactive/Active session
Oracle - Inactive/Active session
Expert: Peter Choi - 8/28/2008
Question
Hi Peter,
i have a doubt,can you please inform/clarify if an Databae Inactive session having last_call_et as 40 Mins+ getting actvie again or any sid which is Inactive can it become active again.
Thanks
Rajiv.
Answer
Hi Rajiv,
The LAST_CALL_ET column indicates how long the session has been idle. So yes it is possible for it to become active again and for that column to be reset.
Another thing that might be possible, is a extended batch programming is running. Sometimes a batch program that is involved in performing complex calculations can consume CPU resources and hardly any DB resources.
Hope this helps.
Peter
Add to this Answer
Ask a Question
|
|
