Logging / Nologging Durumları
Logging Tablespace
CREATE TABLESPACE LOGGING_TBS DATAFILE ‘/u01/app/oracle/oradata/oradb12/LOGGING_TBS01.dbf’ SIZE 101M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING DEFAULT NO INMEMORY ONLINE EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK OFF; |
Logging Table
CREATE TABLE SYS.TAB_LOGGING_TEST ( OWNER VARCHAR2(128 BYTE), NAME VARCHAR2(128 BYTE), TYPE VARCHAR2(12 BYTE), LINE NUMBER, TEXT VARCHAR2(4000 BYTE), ORIGIN_CON_ID NUMBER ) TABLESPACE LOGGING_TBS PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE; |
Deneme1: logging ts&table Redo Size
set autotrace on statistics; insert into tab_logging_test select * from dba_source ; commit;
|
Deneme2: append kullanılarak nologging ts ve nologging tabloda redo size
set autotrace on statistics; insert into /*+ APPEND */ tab_logging_test select * from dba_source ; commit;
|
Deneme3: logging ts ve logging tabloda arch oluştu
insert into tab_logging_test select * from dba_source ; commit; |
Deneme4: append kullanılarak logging ts ve logging tabloda arch olusmadı
insert into /*+ APPEND */ tab_logging_test select * from dba_source ; commit; |
Table Space Mode |
Tablo Mode |
Append Kullanımı |
Redo Uretimi |
Nologging |
NoLogging |
Yok |
Yok |
Logging |
Logging |
Yok |
Var |
Logging |
Logging |
Var |
Yok |
Nologging |
Logging |
Yok |
Yok |
Logging |
Nologging |
Yok |
Var |
Logging |
Nologging |
Var |
Var |
TS Force Logging Mode Tablosu Durumu
Table Space Mode |
Tablo Mode |
Append Kullanımı |
Redo Üretimi |
Force Logging |
Nologging |
Yok |
Var |
Force Logging |
Nologging |
Var |
Var |