今天导入了22幅sid影像数据，数据量在本地大概99M左右，
可是用SDE导入Oracle后，数据量狂大！
信息如下:
SQL> desc user_segments;
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
SEGMENT_NAME VARCHAR2(81)
PARTITION_NAME VARCHAR2(30)
SEGMENT_TYPE VARCHAR2(18)
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
EXTENTS NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
BUFFER_POOL VARCHAR2(7)
SQL> select segment_name, segment_type, bytes / 1024 / 1024 "MB", blocks from user_segments;
SEGMENT_NAME SEGMENT_TYPE MB BLOCKS
--------------------------------------------------------------------------------- ------------------ ---------- ----------
DJ1 TABLE .0625 4
F2 TABLE .0625 4
S2 TABLE .0625 4
SDE_RAS_2 TABLE .0625 4
SDE_BND_2 TABLE .0625 4
SDE_AUX_2 TABLE .0625 4
SDE_BLK_2 TABLE 5062 323968
TESTICAT TABLE .0625 4
I51H132012 TABLE .0625 4
F3 TABLE .0625 4
S3 TABLE .0625 4
SEGMENT_NAME SEGMENT_TYPE MB BLOCKS
--------------------------------------------------------------------------------- ------------------ ---------- ----------
SDE_RAS_3 TABLE .0625 4
SDE_BND_3 TABLE .0625 4
SDE_AUX_3 TABLE .0625 4
SDE_BLK_3 TABLE 232 14848
R40_SDE_ROWID_UK INDEX .0625 4
F2_UK1 INDEX .0625 4
F2_AREA_IX2 INDEX .0625 4
F2_LEN_IX3 INDEX .0625 4
S2_IX1 INDEX .0625 4
S2_IX2 INDEX .0625 4
A2_IX1 INDEX .0625 4
SEGMENT_NAME SEGMENT_TYPE MB BLOCKS
--------------------------------------------------------------------------------- ------------------ ---------- ----------
SDE_RAS_2_UK INDEX .0625 4
SDE_BND_2_UK1 INDEX .0625 4
SDE_BND_2_UK2 INDEX .0625 4
SDE_AUX_2_UK INDEX .0625 4
SDE_BLK_2_UK INDEX 6 384
SDE_RIX_2 INDEX .0625 4
SYS_IL0000019477C00009$$ LOBINDEX .0625 4
PK_TESTICAT INDEX .0625 4
IX_ENV_TESTICAT INDEX .0625 4
R41_SDE_ROWID_UK INDEX .0625 4
F3_UK1 INDEX .0625 4
SEGMENT_NAME SEGMENT_TYPE MB BLOCKS
--------------------------------------------------------------------------------- ------------------ ---------- ----------
F3_AREA_IX2 INDEX .0625 4
F3_LEN_IX3 INDEX .0625 4
S3_IX1 INDEX .0625 4
S3_IX2 INDEX .0625 4
A3_IX1 INDEX .0625 4
SDE_RAS_3_UK INDEX .0625 4
SDE_BND_3_UK1 INDEX .0625 4
SDE_BND_3_UK2 INDEX .0625 4
SDE_AUX_3_UK INDEX .0625 4
SDE_BLK_3_UK INDEX .3125 20
SDE_RIX_3 INDEX .0625 4
SEGMENT_NAME SEGMENT_TYPE MB BLOCKS
--------------------------------------------------------------------------------- ------------------ ---------- ----------
SYS_LOB0000019477C00009$$ LOBSEGMENT 16 1024
45 rows selected.
查看一下影像金字塔数据量：
SQL> select RRD_FACTOR, count(*) from SDE_BLK_2 group by RRD_FACTOR;
RRD_FACTOR COUNT(*)
---------- ----------
0 119814
1 30096
2 7920
3 1980
4 594
5 264
6 66
7 rows selected.
不明白啊！
只有SDE_BLK_2数据狂大，SDE_BLK_2对应的是DJ1，是个RasterCatalog！所有的sid文件就上载到这里!
阅读(1133) | 评论(0) | 转发(0) |
