一点一滴努力,满仓满谷收成

原文连接：https://blog.51cto.com/zhanky/2153331

1 查看PDB信息（在CDB模式下）

show pdbs   --查看所有pdb
select name,open_mode from v$pdbs;  --v$pdbs为PDB信息视图
select con_id, dbid, guid, name , open_mode from v$pdbs;

阅读全文…

1、统计某一个库中各表空间占用多少MB

use information_schema;

SELECT TABLE_NAME,
       CONCAT(TRUNCATE(DATA_LENGTH / 1024 / 1024, 2), ' mb') AS DATA_SIZE,
       CONCAT(TRUNCATE(INDEX_LENGTH / 1024 / 1024, 2), ' mb') AS INDEX_SIZE
  FROM INFORMATION_SCHEMA.TABLES
 WHERE TABLE_SCHEMA = 'zabbix'
 GROUP BY TABLE_NAME
 ORDER BY DATA_LENGTH DESC;

阅读全文…