- 论坛徽章:
- 0
|
如何知道device的剩余空间是多少?
1> sp_helpdevice
2> go
device_name physical_name
description
status cntrltype device_number
low
high
------------------------------ ----------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------ --------- -------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
master /opt/sybase1254/data/master.dat
special, dsync on, default disk, physical disk, 30.00 MB
3 0 0
0
15359
sysprocsdev /opt/sybase1254/data/sysprocs.dat
special, dsync on, physical disk, 132.00 MB
16386 0 1
16777216
16844799
systemdbdev /opt/sybase1254/data/sybsysdb.dat
special, dsync on, physical disk, 1.00 MB
16386 0 2
33554432
33554943
tapedump1 /dev/nst0
disk, dump device
16 2 0
0
20000
tapedump2 /dev/nst1
tape, 625 MB, dump device
16 3 0
0
20000
xhb_dev /opt/sybase1254/data/xhb_dev.dat
special, dsync on, physical disk, 2048.00 MB
16386 0 3
50331648
51380223
xhb_log_dev /opt/sybase1254/data/xhb_log_dev.dat
special, dsync on, physical disk, 2048.00 MB
16386 0 4
67108864
68157439
(7 rows affected)
(return status = 0)
1> sp_helpdb
2> go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
------------------
------------------------------------------------------------------------------------------------------
master 6.0 MB sa 1
Jul 13, 2010
mixed log and data
model 2.0 MB sa 3
Jul 13, 2010
mixed log and data
sybsystemdb 3.0 MB sa 31513
Jul 13, 2010
mixed log and data
sybsystemprocs 132.0 MB sa 31514
Jul 13, 2010
trunc log on chkpt, mixed log and data
tempdb 3.0 MB sa 2
Jul 13, 2010
select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data
xhb 240.0 MB sa 4
Jul 13, 2010
no options set
(1 row affected)
(return status = 0)
1>
如上结查xhb_dev和xhb_log_dev都是2048M
而数据库xhb是240M,如何知道xhb_dev和xhb_log_dev分别的剩余空间? |
|