查询Oracle的所有表空间 我有Oracle的权限,想知道怎样查询其中的所有表空间是sqlplus的,没有可视化的窗口 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT tablespace_name,file_name FROM dba_data_files; select * from dba_tablespaces SQL> select name from v$tablespace;NAME------------------------------SYSTEMUNDOTBS1SYSAUXUSERSTEMPEXAMPLE6 rows selected. select * from dba_tablespace; select * from dba_tablespaces 凑个热闹..SELECT F.TABLESPACE_NAME, TO_CHAR ((T.TOTAL_SPACE - F.FREE_SPACE),'999,999') "USED (MB)", TO_CHAR (F.FREE_SPACE, '999,999') "FREE (MB)", TO_CHAR (T.TOTAL_SPACE, '999,999') "TOTAL (MB)", TO_CHAR ((ROUND ((F.FREE_SPACE/T.TOTAL_SPACE)*100)),'999')||' %' PER_FREE FROM ( SELECT TABLESPACE_NAME, ROUND (SUM (BLOCKS*(SELECT VALUE/1024 FROM V\$PARAMETER WHERE NAME = 'db_block_size')/1024) ) FREE_SPACE FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME ) F, ( SELECT TABLESPACE_NAME, ROUND (SUM (BYTES/1048576)) TOTAL_SPACE FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME ) T WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME AND (ROUND ((F.FREE_SPACE/T.TOTAL_SPACE)*100)) < 80; 8个DBA最常用的监控Oracle数据库的常用shell脚本http://blog.csdn.net/tianlesoftware/archive/2009/11/10/4792798.aspx oracle 数据库几种导出方法的区别 关于下面时间的解释 Oracle 事务嵌套[if(true)then insert1 end if; insert2] oracle的问题 求助:请问怎么把多个表的建表语句导到sql脚本中? 多条sql语句一起执行问题(在线等) oracle第一个存储过程,编译时其出错 如何把SQL2000中的数据库导入到orcale中??? 谁能给我一个toad,可以有debug功能的谢谢 求助:在删除Oracle81的过程中oci.dll文件删除不了 sqlplus Oracle 行变列
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP
EXAMPLE6 rows selected.
凑个热闹..SELECT F.TABLESPACE_NAME,
TO_CHAR ((T.TOTAL_SPACE - F.FREE_SPACE),'999,999') "USED (MB)",
TO_CHAR (F.FREE_SPACE, '999,999') "FREE (MB)",
TO_CHAR (T.TOTAL_SPACE, '999,999') "TOTAL (MB)",
TO_CHAR ((ROUND ((F.FREE_SPACE/T.TOTAL_SPACE)*100)),'999')||' %' PER_FREE
FROM (
SELECT TABLESPACE_NAME,
ROUND (SUM (BLOCKS*(SELECT VALUE/1024
FROM V\$PARAMETER
WHERE NAME = 'db_block_size')/1024)
) FREE_SPACE
FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME
) F,
(
SELECT TABLESPACE_NAME,
ROUND (SUM (BYTES/1048576)) TOTAL_SPACE
FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME
) T
WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME
AND (ROUND ((F.FREE_SPACE/T.TOTAL_SPACE)*100)) < 80; 8个DBA最常用的监控Oracle数据库的常用shell脚本
http://blog.csdn.net/tianlesoftware/archive/2009/11/10/4792798.aspx