Session Monitoring Scripts--Active Sessions

SELECT SID,SERIAL#,USERNAME,STATUS,SCHEMANAME,OSUSER,PROCESS,PROGRAM,
PQ_STATUS "PARALLEL",TO_CHAR(LOGON_TIME,'DD-MM-YYYY HH24:MI:SS')
FROM V$SESSION ;
WHERE TYPE <>'BACKGROUND'
AND STATUS='ACTIVE';