What is the difference between process and session in Oracle? So a process is a process and a session is a session. A session eventually needs a process, is not tied to a single process. A process can have zero one or more sessions using it.
What is inactive session in Oracle? It just means that someone is logged in but not executing SQL right at that instant. Your very own session is “INACTIVE” everytime you are in the process of typing in a query via sqlplus.
What is Last_call_et in V session? LAST_CALL_ET. NUMBER. 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.
How do I find an inactive user in Oracle? Select Inactive Users from the navigation pane. The View settings determine the period during which users were inactive. If you want to view the number of inactive users for a particular date, click View and then click the calendar icon below Last login to select a date, and then click Apply.