| table online move 진행 시 작동 순서를 확인하기 위한 테스트 - tab1 테이블 ts01 -> ts02 로 move online - move 작업 중 다른세션에서 1초 마다 10건씩 insert - TEMPORARY 테이블은 기존(tab1) 테이블 이동하는 것이고 SYS_ 테이블은 변경분 저장용도 |
####################################
Sun Nov 22 16:21:07 KST 2020
OWNER SEGMENT_NAME TABLESPACE_NAME SEGMENT_TYPE BLOCKS BYTES
------------------------------ ------------------------------ ------------------------------ ------------------ ---------- ----------
SK TAB1_IX1 USERS INDEX 95232 780140544
SK SYS_IOT_TOP_73929 TS01 INDEX 8 65536
SK TAB1 TS02 TABLE 262144 2147483648
SK SYS_RMTAB$$_H73667 TS02 TABLE 6656 54525952
SK 5.138 TS01 TEMPORARY 33792 276824064
####################################
Sun Nov 22 16:21:09 KST 2020
OWNER SEGMENT_NAME TABLESPACE_NAME SEGMENT_TYPE BLOCKS BYTES
------------------------------ ------------------------------ ------------------------------ ------------------ ---------- ----------
SK TAB1_IX1 USERS INDEX 95232 780140544
SK SYS_IOT_TOP_73929 TS01 INDEX 8 65536
SK TAB1 TS02 TABLE 262144 2147483648
SK SYS_RMTAB$$_H73667 TS02 TABLE 7424 60817408
SK 5.138 TS01 TEMPORARY 37888 310378496
####################################
Sun Nov 22 16:22:34 KST 2020
OWNER SEGMENT_NAME TABLESPACE_NAME SEGMENT_TYPE BLOCKS BYTES
------------------------------ ------------------------------ ------------------------------ ------------------ ---------- ----------
SK TAB1_IX1 USERS INDEX 95232 780140544
SK SYS_IOT_TOP_73929 TS01 INDEX 8 65536
SK TAB1 TS02 TABLE 262144 2147483648
SK SYS_RMTAB$$_H73667 TS02 TABLE 51200 419430400
SK 5.138 TS01 TEMPORARY 262144 2147483648
-- 2.313474 temp 세그먼트 생성되고 SYS_RMTAB$$_H73667 사이즈 만큼 증가
-- 2.313474 , SYS_RMTAB$$_H73667 사라지고 PK_SYS_RMTAB$$_I73667 생성됨
####################################
Sun Nov 22 16:22:48 KST 2020
OWNER SEGMENT_NAME TABLESPACE_NAME SEGMENT_TYPE BLOCKS BYTES
------------------------------ ------------------------------ ------------------------------ ------------------ ---------- ----------
SK TAB1_IX1 USERS INDEX 95232 780140544
SK SYS_IOT_TOP_73929 TS01 INDEX 8 65536
SK TAB1 TS02 TABLE 262144 2147483648
SK SYS_RMTAB$$_H73667 TS02 TABLE 51200 419430400
####################################
Sun Nov 22 16:22:50 KST 2020
OWNER SEGMENT_NAME TABLESPACE_NAME SEGMENT_TYPE BLOCKS BYTES
------------------------------ ------------------------------ ------------------------------ ------------------ ---------- ----------
SK TAB1_IX1 USERS INDEX 95232 780140544
SK SYS_IOT_TOP_73929 TS01 INDEX 8 65536
SK TAB1 TS02 TABLE 262144 2147483648
SK SYS_RMTAB$$_H73667 TS02 TABLE 51200 419430400
SK 2.313474 TS02 TEMPORARY 1408 11534336
####################################
Sun Nov 22 16:23:43 KST 2020
OWNER SEGMENT_NAME TABLESPACE_NAME SEGMENT_TYPE BLOCKS BYTES
------------------------------ ------------------------------ ------------------------------ ------------------ ---------- ----------
SK TAB1_IX1 USERS INDEX 95232 780140544
SK SYS_IOT_TOP_73929 TS01 INDEX 8 65536
SK TAB1 TS02 TABLE 262144 2147483648
SK SYS_RMTAB$$_H73667 TS02 TABLE 51200 419430400
SK 2.313474 TS02 TEMPORARY 55296 452984832
####################################
Sun Nov 22 16:23:45 KST 2020
OWNER SEGMENT_NAME TABLESPACE_NAME SEGMENT_TYPE BLOCKS BYTES
------------------------------ ------------------------------ ------------------------------ ------------------ ---------- ----------
SK TAB1_IX1 USERS INDEX 95232 780140544
SK SYS_IOT_TOP_73929 TS01 INDEX 16 131072
SK TAB1 TS02 TABLE 262144 2147483648
SK PK_SYS_RMTAB$$_I73667 TS02 INDEX 56320 461373440
-- 인덱스 리빌드 시작
####################################
Sun Nov 22 16:24:40 KST 2020
OWNER SEGMENT_NAME TABLESPACE_NAME SEGMENT_TYPE BLOCKS BYTES
------------------------------ ------------------------------ ------------------------------ ------------------ ---------- ----------
SK TAB1_IX1 USERS INDEX 95232 780140544
SK SYS_IOT_TOP_73929 TS01 INDEX 16 131072
SK TAB1 TS02 TABLE 262144 2147483648
SK PK_SYS_RMTAB$$_I73667 TS02 INDEX 56320 461373440
SK 7.474 USERS TEMPORARY 1280 10485760
####################################
Sun Nov 22 16:24:42 KST 2020
OWNER SEGMENT_NAME TABLESPACE_NAME SEGMENT_TYPE BLOCKS BYTES
------------------------------ ------------------------------ ------------------------------ ------------------ ---------- ----------
SK TAB1_IX1 USERS INDEX 95232 780140544
SK SYS_IOT_TOP_73929 TS01 INDEX 16 131072
SK TAB1 TS02 TABLE 262144 2147483648
SK PK_SYS_RMTAB$$_I73667 TS02 INDEX 56320 461373440
SK 7.474 USERS TEMPORARY 3584 29360128
-- 작업 완료
####################################
Sun Nov 22 16:25:27 KST 2020
OWNER SEGMENT_NAME TABLESPACE_NAME SEGMENT_TYPE BLOCKS BYTES
------------------------------ ------------------------------ ------------------------------ ------------------ ---------- ----------
SK TAB1_IX1 USERS INDEX 95232 780140544
SK SYS_IOT_TOP_73929 TS01 INDEX 16 131072
SK TAB1 TS02 TABLE 262144 2147483648
SK PK_SYS_RMTAB$$_I73667 TS02 INDEX 56320 461373440
SK 7.474 USERS TEMPORARY 94208 771751936
####################################
Sun Nov 22 16:25:29 KST 2020
OWNER SEGMENT_NAME TABLESPACE_NAME SEGMENT_TYPE BLOCKS BYTES
------------------------------ ------------------------------ ------------------------------ ------------------ ---------- ----------
SK TAB1_IX1 USERS INDEX 95232 780140544
SK TAB1 TS01 TABLE 262144 2147483648'DBMS > ORACLE' 카테고리의 다른 글
| 리스너에 IP/포트 여러개 등록 (0) | 2023.07.26 |
|---|---|
| WITH 이용한 TEMP TABLE 사용 테스트 (0) | 2023.07.21 |
| 테이블 nologging / append insert 복구 불가(ORA-26040) (0) | 2023.07.05 |
| ASM, spfile 환경 control file 다중화 (0) | 2023.07.01 |
| DBCA delete database 작업 시 목록 안보이는 경우 (0) | 2023.06.22 |
댓글