SQL> SQL> CREATE VIEW session_log AS 2 SELECT * 3 FROM v$session 4 WHERE username = USERNAME; SQL> SQL> select * from session_log; SQL> SQL> SQL> SELECT username, sid, serial#, module, action 2 FROM session_log; SQL> SQL> SQL> drop view session_log;