查看那些用户连接到当前的数据库信息:
select osuser, a.username,cpu_time / executions / 1000000 || 's', sql_fulltext, machine from v$session a, v$sqlarea b
where a.sql_address = b.address order by cpu_time / executions desc;
如果连接的电脑不是自己的,修改密码错误锁死限制次数。查看用户的状态sql
select username,account_status,lock_date from dba_users;
查看密码错误次数锁死信息
select * from dba_profiles where resource_name like 'FAILED_LOGIN_ATTEMPTS%';
修改该次数
alter profile default limit FAILED_LOGIN_ATTEMPTS 50;
也可以改为不限制(安全考虑,不建议)
alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;
解锁被锁定的用户
alter user username account unlock;