This is an old revision of the document!

Comprobar usuario bloqueado:

select username,account_status,profile from dba_users where username='jose'

USERNAME		       ACCOUNT_STATUS			PROFILE
------------------------------ -------------------------------- ------------------------------
jose			       LOCKED(TIMED)			DEFAULT

Desbloquear usuario:

ALTER USER username ACCOUNT UNLOCK;

Comprobar parámetros perfil usuario:

SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile='DEFAULT';

RESOURCE_NAME			 RESOURCE LIMIT
-------------------------------- -------- ----------------------------------------
COMPOSITE_LIMIT 		 KERNEL   UNLIMITED
SESSIONS_PER_USER		 KERNEL   UNLIMITED
CPU_PER_SESSION 		 KERNEL   UNLIMITED
CPU_PER_CALL			 KERNEL   UNLIMITED
LOGICAL_READS_PER_SESSION	 KERNEL   UNLIMITED
LOGICAL_READS_PER_CALL		 KERNEL   UNLIMITED
IDLE_TIME			 KERNEL   UNLIMITED
CONNECT_TIME			 KERNEL   UNLIMITED
PRIVATE_SGA			 KERNEL   UNLIMITED
FAILED_LOGIN_ATTEMPTS		 PASSWORD 10
PASSWORD_LIFE_TIME		 PASSWORD UNLIMITED
PASSWORD_REUSE_TIME		 PASSWORD UNLIMITED
PASSWORD_REUSE_MAX		 PASSWORD UNLIMITED
PASSWORD_VERIFY_FUNCTION	 PASSWORD NULL
PASSWORD_LOCK_TIME		 PASSWORD 1
PASSWORD_GRACE_TIME		 PASSWORD 7

Activar auditoria:

Una vez activada, se busca los errores con la consulta:

select * from dba_audit_session where username='usuario' and returncode != 0 order by timestamp desc;

Para vaciar la tabla:

truncate table aud$