| LAST_CALL_ET of VSESSION [message #61363] |
Sat, 17 April 2004 02:16  |
Sujit Sarkar
Messages: 40
Registered: September 2003
|
Member |
|
|
Hi,
Can any body tell me the meaning of LAST_CALL_ET column of V$SESSION view in detail. What is the significance of this column in DBA activities.
Any Examples are highly appreciated.
Note: I had gone through a post of this in orafaq but i could not understand the meaning sorry.
Sujit
|
|
|
|
| Re: LAST_CALL_ET of VSESSION [message #61365 is a reply to message #61363] |
Sat, 17 April 2004 06:01  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
V$SESSION.LAST_CALL_ET is the elapsed time (in
seconds) since the last Oracle function call was
executed for a particular session.
People normally use this value to identify and kill
idle database sessions. For example, to identify
session that are idle for more than 30 minutes:
SELECT sid, serial#, username, logon_time,
(last_call_et / 60) "Minutes Inactive"
FROM v$session
WHERE username IS NOT NULL
AND (last_call_et / 60) > 30
AND status = 'INACTIVE';
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
