2019-02-28から1日間の記事一覧
Oracle select * from dba_segments;select * from user_segments; select d.tablespace_name, d.gbytes "total[GB]", NVL(f.gbytes,0) "free[GB]",d.gbytes - NVL(f.gbytes,0) "used[GB]",(1 - (NVL(f.gbytes,0)/d.gbytes))*100 "used_percent"from(SELECT …