Why IDLE_TIME profile option does not have any effect???
To reduce peoblems of having too many INACTIVE sessions, I have set IDLE_TIME profile option in the DEFAULT profile with the value of 720 minutes i.e 12 hours. RESOURCE_LIMIT is also set to TRUE in the init.ora file and database has been bounced since then.
Still, I do not see if this really is working because I can still see old inactive sessions still sitting there. Some of them are even 4-5 days old.
Could anyone help me please?
Thanks in Adv..