Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inactive sessions accumulate exceed the max session

797608Nov 15 2010 — edited Nov 15 2010

Hi All,

once i checked the v$session, always find lots of inactive session.nearly after two month it will exceed the max session value in the init.ora profile.

I have check the sqlnet.ora profile and the value of expire_time is 10 minuter, while not sure why so many inactive session? and if i need to kill all inactive session?

Best Regards,
Chelsea

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 13 2010

Added on Nov 15 2010

#general-database-discussions, #session

2 comments

548 views