Answering to the question where can you get the description of the v$tables, do the following

on the sql prompt

SQL> desc v$session

would list all the columns in the V$session view. "desc" means describe.

Sam