Oracle新建用户和表,查询杀死session

登陆

> sqlplus / as sysdba

 

//创建表空间
create tablespace TbSpace_data
logging
datafile '/u01/oracle/TbSpace/tbspace_data01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;

//创建用户并指定表空间
create user weiming identified by weiming
default tablespace TbSpace_data;

 

//给用户授予权限
grant dba to weiming;
grant connect,resource to weiming;

 

 

 

杀掉session

alter system kill session 'sid,serial';

查看session
select saddr, sid, serial#, paddr, username, status, PROGRAM, EVENT
  from v$session
 where username = 'XXT';