https://blog.youkuaiyun.com/lgzcczh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/lgzcc/article/details/8497096https://blog.youkuaiyun.com/lgzcc/article/details/8497096lgzccSat, 12 Jan 2013 22:05:18 +0800https://blog.youkuaiyun.com/lgzcc/article/details/8233032https://blog.youkuaiyun.com/lgzcc/article/details/8233032lgzccWed, 28 Nov 2012 09:46:34 +0800https://blog.youkuaiyun.com/lgzcc/article/details/7426746https://blog.youkuaiyun.com/lgzcc/article/details/7426746lgzccWed, 04 Apr 2012 22:52:26 +0800https://blog.youkuaiyun.com/lgzcc/article/details/7397108https://blog.youkuaiyun.com/lgzcc/article/details/7397108lgzccMon, 26 Mar 2012 23:12:39 +0800https://blog.youkuaiyun.com/lgzcc/article/details/7302015https://blog.youkuaiyun.com/lgzcc/article/details/7302015lgzccTue, 28 Feb 2012 14:20:12 +0800https://blog.youkuaiyun.com/lgzcc/article/details/5832219https://blog.youkuaiyun.com/lgzcc/article/details/5832219lgzccMon, 23 Aug 2010 16:16:00 +0800select df.tablespace_name "表空间名称",totalspace "空间大小/M",freespace "剩余空间/M",round((1-freespace/totalspace)*100,2) "表空间使用率%"
from
(select tablespace_name,round(sum(bytes)/1024/1024) totalspace
from dba_data_files
group by tablespa]]>https://blog.youkuaiyun.com/lgzcc/article/details/5739463https://blog.youkuaiyun.com/lgzcc/article/details/5739463lgzccFri, 16 Jul 2010 13:03:00 +0800查看session：
 
　　select * from v$session where username is not null
　　select username,count(username) from v$session where username is not null group by username
　　当前连接数：
　　select count(*) from v$process
　　查看连接数参数的设置情况
https://blog.youkuaiyun.com/lgzcc/article/details/5637786https://blog.youkuaiyun.com/lgzcc/article/details/5637786lgzccMon, 31 May 2010 21:11:00 +0800当我们需要将一个数据库备份导入到某个用户某个表空间时需要先创建表空间然后在创建用户
创建表空间的方法：
利用SQLplus输入命令：
create tablespace 表空间名 datafile '表空间存放路径' size 3000m; 3000m指的是3000MB；
创建用户的方法：
create user 用户名 identified by 密码 default tablespace 用户想用的表空间;
修改用户的权限：