0

As my question title, Is there any view or table to show how long a session have been in IDLE state in Oracle ?

So that I can monitor how long this session have been in IDLE state.

It doesn't mean how to set session expired-time.

1 Answer 1

3

Yes, v$session stores this information.

v$session.LAST_CALL_ET:

If the session STATUS is currently ACTIVE, then the value represents the elapsed time in seconds since the session has become active. If the session STATUS is currently INACTIVE, then the value represents the elapsed time in seconds since the session has become inactive.

Documentation link.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.