oracle 的一些常用操作

查看所有用户
select * from all_users;
select * from dba_users;

查看所有表空间 和数据文件
select * from V$TABLESPACE
select name from v$datafile;
select * from dba_tablespaces where TABLESPACE_NAME='表空间名';

session管理
select SID, SERIAL#, USERNAME from v$session;
13, 8';

删除用户
drop user xmhidev cascade;
删除表空间
drop tablespace XMDEVTS INCLUDING CONTENTS ;

向存储过程里传递数组参数
参考
http://blog.csdn.net/moonsliver/archive/2008/12/09/3482123.aspx
http://www.itpub.net/thread-366580-1-1.html
http://read.newbooks.com.cn/info/171741.html
http://ganqing1234.javaeye.com/blog/322415
http://www.blogjava.net/jiangjf/articles/121559.html