SELECT s.sid, s.serial#, s.status, p.spid
 FROM v$session s, v$process p
WHERE s.username = 'MARINA'
and p.addr(+) = s.paddr;

--ALTER SYSTEM KILL SESSION '7, 39';

drop user marina cascade;
create user marina identified by marina default tablespace marina temporary tablespace temp;
grant dba to marina;



select 'ALTER VIEW '||VIEW_NAME||' COMPILE;' from all_views where owner = 'MARINA';