摘要:用語法查詢SQL DB SIZE
MSSQL
use 'database_name'
-- SQL 2000
SELECT name, size, filename from dbo.sysfiles
-- SQL 2005
SELECT name, size, physical_name from sys.database_files
Oracle
select
"Reserved_Space(MB)", "Reserved_Space(MB)" - "Free_Space(MB)" "Used_Space(MB)","Free_Space(MB)"
from(
select
(select sum(bytes/(1014*1024)) from dba_data_files) "Reserved_Space(MB)",
(select sum(bytes/(1024*1024)) from dba_free_space) "Free_Space(MB)"
from dual
)
參考連結:
dbo.sysfiles
sys.database_files
dba_data_files
dba_free_space