首页 > 数据库 > Oracle > 正文

oracle表空间

2019-11-02 15:53:51
字体:
来源:转载
供稿:网友

   1. 查看表空间是否自增长

  SELECT FILE_NAME, TABLESPACE_NAME, AUTOEXTENSIBLE FROM DBA_DATA_FILES;

  2. 查看表空间大小

  select tablespace_name, sum(bytes) / 1024 / 1024 as MB from dba_data_files group by tablesp

搞笑段子[www.62-6.com]
ace_name;

  3. 查看表空间使用情况

  select tablespace_name,count(*) as extends,round(sum(bytes) / 1024 / 1024, 2) as MB,sum(blocks) as blocks from dba_free_space group by tablespace_name;

  4. 查看当前用户默认表空间

  select username,default_tablespace from user_users;

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表