Oracle 部分SQL整理记录-随时更新

#解锁用户

alter user XXX account unlock;

#修改密码

alter user XXX identified by passwd;

#切换pdb容器

alter session set container=xxxpdb;

#重启Oracle 服务

shutdown immediate

startup

#启动、停止监听

lsnrctl start

lsnrctl stop

 #修改最大连接数

alter system set processes = 1000 scope = spfile;

#查询最大连接数

select value from v$parameter where name = 'processes'；

 

#修改密码有效期 无限制

 

SELECT username,PROFILE FROM dba_users;

SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;