-- permissoes  
SELECT * FROM USER_SYS_PRIVS; 
SELECT * FROM USER_TAB_PRIVS;
SELECT * FROM USER_ROLE_PRIVS;

-- hostaname  
select host_name from v$instance;

SELECT DISTINCT 'ALTER SYSTEM KILL session '''||s.sid||','||S.SERIAL#||',@'||S.INST_ID||''' immediate;' 
FROM gv$session s --gv$lock l
,GV$SQL SA
WHERE username LIKE  ('%FIES_PREINSCRICAO%');