1.select count(*) from v$session where status in ('ACTIVE','INACTIVE')

2.SELECT username,
       extended_timestamp,
       owner,
       obj_name,
       action_name
FROM   dba_audit_trail
WHERE  owner = 'AUDIT_TEST'
ORDER BY timestamp;