Oracle su windows fix problemi login

BEGIN
  FOR sess IN (SELECT sid,serial# FROM v$session WHERE status<>'INACTIVE')
  LOOP
      EXECUTE IMMEDIATE 'alter system kill session ''' || sess.sid  || ','
        || sess.serial# || ''' immediate';
  END LOOP;
END;

SELECT * FROM V$SESSION

ALTER SYSTEM KILL SESSION WHERE status LIKE '%active%';


SELECT 'ALTER SYSTEM KILL SESSION '''||sid||','||serial#||''' IMMEDIATE;' FROM v$session;

ALTER SYSTEM KILL SESSION '10,57840' IMMEDIATE;

SELECT * FROM DBA_USERS WHERE USERNAME LIKE '%system%';

SELECT RESOURCE_NAME,LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT' AND RESOURCE_NAME='IDLE_TIME';

ALTER PROFILE DEFAULT LIMIT IDLE_TIME 1;

SELECT * FROM DBA_USERS;

CREATE USER test IDENTIFIED BY 123;

ALTER SESSION SET container
CREATE USER test IDENTIFIED BY 123;