vanishke / blog-comments

blog-comments
0 stars 0 forks source link

Oracle查看表空间使用情况 | vanishke个人技术博客 #5

Open vanishke opened 3 years ago

vanishke commented 3 years ago

https://hexo-sigma-eight.vercel.app/Oracle/blogs/Oracle%E6%9F%A5%E7%9C%8B%E8%A1%A8%E7%A9%BA%E9%97%B4%E4%BD%BF%E7%94%A8%E6%83%85%E5%86%B5/

统计SELECT a.tablespace_name "表空间名",a.bytes / 1024 / 1024 "表空间大小(M)",(a.bytes - b.bytes) / 1024 / 1024 "已使用空间(M)",b.bytes / 1024 / 1024 "空闲空间(M)",round(((a.bytes