一个设备文件大小与段显示不一致问题
设置用户数据库的扩展,ext1~10的扩展system为4G,logsegment是1Gext11~15的扩展system为8G,logsegment是2G,并已经alter database
现场查询日志端出现以下问题,是什么情况啊?
$ isql -Usa -P
1> use smss
2> go
1> sp_helpsegment system
2> go
segment name status
------- ------------------------------ ------
0 system 0
device size free_pages
------------------------------ ---------------------- -----------
smss_dat 8000.0MB 58077
smss_ext10_dat 4000.0MB 1020000
smss_ext11_dat 8000.0MB 2040000
smss_ext12_dat 8000.0MB 2040000
smss_ext13_dat 8000.0MB 2040000
smss_ext14_dat 8000.0MB 2040000
smss_ext15_dat 8000.0MB 2040000
smss_ext1_dat 4000.0MB 8
smss_ext2_dat 4000.0MB 1594
smss_ext2_log 1000.0MB 8
smss_ext3_dat 2000.0MB 638
smss_ext3_log 500.0MB 0
smss_ext4_dat 1500.0MB 485
smss_ext5_dat 4000.0MB 32
smss_ext6_dat 4000.0MB 212060
smss_ext7_dat 4000.0MB 2138
smss_ext8_dat 4000.0MB 14399
smss_ext9_dat 4000.0MB 546393
页:
[1]