Oracle³£ÓÃÃüÁî»ã¼¯

²éѯ±í¿Õ¼äÐÅÏ¢£º
select * from dba_tablespaces;
select tablespace_name from dba_tablespaces;
select   *   from   dba_tablespaces   where   TABLESPACE_NAME='±í¿Õ¼äÃû';     £¨±í¿Õ¼äÃûÒª´óд£©
²éѯÓû§ÐÅÏ¢£º
select * from dba_users;
select username,default_tablespace from dba_users;
²é¿´¸÷¸ö±í¿Õ¼äÕ¼ÓôÅÅÌÇé¿ö.sql£º
select
b.file_id ÎļþIDºÅ,
b.tablespace_name ±í¿Õ¼äÃû,
b.bytes/1024/1024||'M'×Ö½ÚÊý,
(b.bytes-sum(nvl(a.bytes,0)))/1024/1024||'M' ÒÑʹÓÃ,
sum(nvl(a.bytes,0))/1024/1024||'M' Ê£Óà¿Õ¼ä,
100 - sum(nvl(a.bytes,0))/(b.bytes)*100 Õ¼ÓðٷֱÈ
from dba_free_space a,dba_data_files b
where a.file_id=b.file_id
group by b.tablespace_name,b.file_id,b.bytes
order by b.file_id
²é¿´Óû§Ä¬Èϱí¿Õ¼äʹÓÃÇé¿öµÄsqlÓï¾ä£º
Select *
from
      (select username,default_tablespace from dba_users) ut,
      (select
      --b.file_id ÎļþIDºÅ,
      b.tablespace_name ±í¿Õ¼äÃû,
      b.bytes/1024/1024||'M'×Ö½ÚÊý,
      (b.bytes-sum(nvl(a.bytes,0)))/1024/1024||'M' ÒÑʹÓÃ,
      sum(nvl(a.bytes,0))/1024/1024||'M' Ê£Óà¿Õ¼ä,
      100 - sum(nvl(a.bytes,0))/(b.bytes)*100 Õ¼ÓðٷֱÈ
      from dba_free_space a,dba_data_files b
      where a.file_id=b.file_id
      group by b.tablespace_name,b.file_id,b.bytes
      order by b.file_id ) tsu
Where ut.default_tablespace = tsu.±í¿Õ¼äÃû
orDER BY ut.username
select * from all_users;                ##²é¿´ËùÓÐÓû§
select name from v$database;             ##²é¿´µ±Ç°Êý¾Ý¿â
database test