oracle数据库常用命令整理

select username,account_status from dba_users;

select * from dba_roles;

alter user XXX account lock;

useradd -d /home/XXX -s /usr/bin/ksh -m XXX
passwd XXX

useradd -d /home/XXX -g users -s /bin/bash -m XXX -G users 
passwd XXX

userdel -r XXX

ps -e|grep ***
kill -9 ***(PID)

lsb_release -a

grant debug any procedure, debug connect session to prodb;

select username,password from dba_users;

drop user XXX cascade;

shutdown immediate;
startup restrict;
drop user *** cascade;
alter system disable restricted session;

lsnrctl start

即可启动

ctrl+backspace

sqlplus 用户名/密码@10.10.10.10：1521/orcl

select t1.name, t2.name  from v$tablespace t1, v$datafile t2 where  t1.ts# = t2.ts#;

drop tablespace **** including contents and datafiles;

insert into table_A(X,X,X,X) select X,X,X,X from table_B where XXX

GRANT debug any procedure, debug connect session TO USER XXX;

select username,count(username) from v$session where username is not null group by username;

select t."SQL_TEXT",t."SQL_FULLTEXT",t."LAST_ACTIVE_TIME" from v$sqlarea t where t.PARSING_SCHEMA_NAME in ('XXX') and t."SQL_TEXT" like '%XXX%' and t.LAST_ACTIVE_TIME > to_date('201707130623', 'yyyymmddhhmi') order by t.LAST_ACTIVE_TIME;