概述 了解一下ORACLE数据库每天,每周的数据增长情况,如何快速查询呢?今天分享一个脚本,帮你快速了解自己数据库的情况脚本内容SETLINESIZE200SETPAGESIZE200COLDatabaseSizeFORMATa13COLUsedSpaceFORMATa11COLUsedinFORMATa11COLFreeinFORMATa11COLDatabaseNameFORMATa13COLFreeSpaceFORMATa12COLGrowthDAYFORMATa11COLGrowthWEEKFORMATa12COLGrowthDAYinFORMATa16COLGrowthWEEKinFORMATa16SELECT(selectmin(creationtime)fromvdatafile)CreateTime,(selectnamefromvdatabase)DatabaseName,ROUND((SUM(USED。BYTES)10241024),2)MBDatabaseSize,ROUND((SUM(USED。BYTES)10241024)ROUND(FREE。P10241024),2)MBUsedSpace,ROUND(((SUM(USED。BYTES)10241024)(FREE。P10241024))ROUND(SUM(USED。BYTES)10241024,2)100,2)MBUsedin,ROUND((FREE。P10241024),2)MBFreeSpace,ROUND(((SUM(USED。BYTES)10241024)((SUM(USED。BYTES)10241024)ROUND(FREE。P10241024)))ROUND(SUM(USED。BYTES)10241024,2)100,2)MBFreein,ROUND(((SUM(USED。BYTES)10241024)(FREE。P10241024))(selectsysdatemin(creationtime)fromvdatafile),2)MBGrowthDAY,ROUND(((SUM(USED。BYTES)10241024)(FREE。P10241024))(selectsysdatemin(creationtime)fromvdatafile)ROUND((SUM(USED。BYTES)10241024),2)100,3)MBGrowthDAYin,ROUND(((SUM(USED。BYTES)10241024)(FREE。P10241024))(selectsysdatemin(creationtime)fromvdatafile)7,2)MBGrowthWEEK,ROUND((((SUM(USED。BYTES)10241024)(FREE。P10241024))(selectsysdatemin(creationtime)fromvdatafile)ROUND((SUM(USED。BYTES)10241024),2)100)7,3)MBGrowthWEEKinFROM(SELECTBYTESFROMVDATAFILEUNIONALLSELECTBYTESFROMVTEMPFILEUNIONALLSELECTBYTESFROMVLOG)USED,(SELECTSUM(BYTES)ASPFROMDBAFREESPACE)FREEGROUPBYFREE。P;三、输出展示