¿À¶óŬ ¼¼±×¸ÕÆ® (SEGMENT)
-. ¿À¶óŬ ÆÄÀÏ ±¸¼º
LOGICAL : DATABASE > TABLESPACE > SEGMENT > EXTENT > BLOCK
PHYSICAL : DATA FILE OS FILE BLOCK
¿À¶óŬ block »çÀÌÁî°¡ 4K ÀÌ°í OS block »çÀÌÁî°¡ 512B¶ó¸é OS block 4°³·Î ¿À¶óŬ blockµéÀÌ ±¸¼ºµÇ¾î ÀÖ´Ù
-. ¿À¶óŬ ¿ÀºêÁ§Æ®
create ¹®À¸·Î »ý¼º °¡´ÉÇÑ °Íµé
non-schema object¿Í schema object·Î ³ª´©¾î Áø´Ù
non-schema object |
schema object (= user object) |
database | table* |
table space* | index* |
user | view |
rollback segment* (9i ºÎÅÍ ÀÚµ¿°ü¸®) | sequence |
... | synonym |
function | |
procedure | |
package |
* : segment (¶¥ÀÌ ÇÊ¿äÇÔ)
ÀÌÁß ¹°¸®Àû ¿µ¿ªÀÌ ÇÊ¿äÇÑ object¸¦ segment¶ó ÇÑ´Ù
SEGMENT_TYPE COUNT(*)
CACHE 1
CLUSTER 10
INDEX 1527
INDEX PARTITION 131
LOBINDEX 52
LOBSEGMENT 52
NESTED TABLE 1
ROLLBACK 1
TABLE 1623
TABLE PARTITION 59
TYPE2 UNDO 12