给表空间添加了一个数据文件,total pages涨了,但是free pages没有涨,如何让free pages扩大啊?
命令:alter tablespace cncainfo add (file '/datastore/cncainfo/CNCA03.DAT' 2715040)
表空间的信息:
Tablespace ID = 3
Name = CNCAINFO
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x10000000
Detailed explanation:
DMS rebalancer is active
Total pages = 5430080
Useable pages = 5429984
Used pages = 2714976
Free pages = 215040
High water mark (pages) = 2714976
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 96
Number of containers = 3
Minimum recovery time = 2010-08-09-00.35.04.000000
收起