Oracle inactive session (Last_call_et)

Note the value of the Last_call_et,

Select s.status,s.last_call_et,s.* from v$session s where username= ' DDD ';

In this example, a sqlplus is opened and a select * from Big_table is performed on a large table;

Can be opened until the results are shown.

But when viewing v$session you can see that status has been inactive.

At the same time open another session, do not do anything. (Last_call_et has been increasing)

The Session,last_call_et in query only changes between 0 and 1.

Oracle Doc:

LAST_CALL_ET	NUMBER	If the session STATUS is currently ACTIVE , then the value represents the elapsed time in seconds since the session has becom E Active. If the session STATUS is currently INACTIVE , then the value represents the elapsed time in seconds since the session have BEC ome inactive.

In conclusion, when judging the session is inactive, we should observe the value of last_call_et, otherwise it is possible to manslaughter.

Oracle Inactive session (Last_call_et)