Oracle Database Logging/Nologging Durumları

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