oracle表空间

最新推荐文章于 2024-10-10 11:43:49 发布

weixin_42394794

最新推荐文章于 2024-10-10 11:43:49 发布

阅读量415

点赞数 3

文章标签： oracle 数据库

本文链接：https://blog.csdn.net/weixin_42394794/article/details/140696195

版权

错误1：unable to extend index U_WSXNPG.AUDITPROJECT_IDX by 128

登录服务器root,切换到oracle: su - oracle , 执行语句：sqlplus / as sysdba

https://www.cnblogs.com/zhuwenjoyce/p/7489794.html

空间大小
SELECT tablespace_name, sum(bytes) / (1024 * 1024) free_space_mb FROM dba_free_space GROUP BY tablespace_name;

空间使用率
SELECT a.tablespace_name,
(a.total_mb - nvl(b.free_space_mb, 0)) used_mb,
round(((a.total_mb - nvl(b.free_space_mb, 0)) / a.total_mb) * 100, 2) || '%' used_pct
FROM (SELECT tablespace_name, sum(bytes) / (1024 * 1024) total_mb
FROM dba_data_files
GROUP BY tablespace_name) a,
(SELECT tablespace_name, sum(bytes) / (1024 * 1024) free_space_mb
FROM dba_free_space
GROUP BY tablespace_name) b
WHERE a.tablespace_name = b.tablespace_name(+);

获取数据文件dbf路径
select tablespace_name, file_id,file_name, round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name;

alter tablespace TS_CT_WSXNPG_DATA add datafile '/u01/app/oracle/oradata/ctdb/XXX_DATA03.dbf' size 32760m autoextend on next 1024m maxsize unlimited;

alter tablespace TS_CT_WSXNPG_DATA add datafile '/u01/app/oracle/oradata/ctdb/XXX_IDX02.dbf' size 5120m autoextend on next 1024m maxsize unlimited;

alter tablespace TS_CT_WSDAGD_DATA add datafile '/u01/app/oracle/oradata/ctdb/XXX_DATA03.dbf' size 32760m autoextend on next 1024m maxsize unlimited;