为什么数据库设备有些空间用不完?
example 一:device_fragments size usage created free kbytes
slice_dev 32767.0 MB data only Sep6 20079:26AM 0
syb_log1 4096.0 MB log only Sep6 20079:26AM not applicable
slice_dev1 32767.0 MB data only Sep6 20079:26AM 0
data_dev08 32767.0 MB data only Sep 27 20078:53AM 0
data_dev11 32767.0 MB data only Oct 12 2007 10:20AM 0
data_dev16 32767.0 MB data only Nov 26 20071:59PM 0
data_dev19 32767.0 MB data only Feb 26 2008 12:59PM 0
data_dev30 32767.0 MB data only Apr 15 20084:29PM 0
data_dev33 32767.0 MB data only Jun 11 20085:10PM 17111536
而下面的例子中free kbytes 却不为0,为什么?
example 二:
device_fragments size usage created free kbytes
new2s_dev 32766.0 MB data only Sep4 20079:19AM 795440
new2s_dev 1.0 MB data only Sep4 20079:19AM 1020
data_log 2048.0 MB log only Sep4 20079:19AM not applicable
new2s_dev1 2045.0 MB data only Sep4 20079:19AM 2085900
new2s_dev1 30722.0 MB data only Sep4 20079:19AM 811958
data_dev01 32767.0 MB data only Sep4 20079:19AM 886606
data_dev02 32767.0 MB data only Sep8 2007 10:33AM 883624
data_dev03 32767.0 MB data only Sep 13 20071:51PM 881048
希望那位兄弟或姐妹能够解惑,不胜感激! 为啥研究这个,有啥影响吗?
好像后面的速度会好点吧。 磁盘空间不够用,总想多找点空间来用 实在不够加增加点设备吧。 数据量不足以用完空间,如此而已
页:
[1]