V$SESSION

[Sofiane]

Hello,

Anyone could give me more information about the following columns in the v$session view :

FIXED_TABLE_SEQUENCE :
LAST_CALL_ET :


Thanks in advance

Sofiane

[sambavan]

Fixed_table_sequence : this contains a number that increases every time the session completes a call to the database ans there has been an intervening select from a dynamic performance table. This is used by performance monitor to monitor statistics in the database. Each time the Perf. monitor looks at the database, it only needs to look at the sessions that are currently active or have a higher value in this column than the highest value that the performance monitor saw the last time.

LAST_CALL_ET: as the name suggest it holds the last call.


I hope this would help you.

Sam