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';