Re: Flashback log file sync

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 12 May 2012 18:08:32 +0000 (UTC)
Message-ID: <pan.2012.05.12.18.08.31_at_gmail.com>

On Sat, 12 May 2012 07:26:46 +0100, Jonathan Lewis wrote:

> What's the full DDL for the table (use dbms_metadata.get_ddl) - are the
> LOBs nocache nologging, for example, and can this affect the flashback
> rate.

Jonathan, no need for DBMS_METADATA. I have the DDL:

create table bin_files(
fileno number(4,0),
filename varchar2(256),
content BLOB)
LOB(content) store as (tablespace test_lob disable storage in row nocache) tablespace test_tbs
/

It was late when I started working on the test, I forgot the nologging clause. I re-created the table, the DDL now looks like this:

CREATE TABLE "SCOTT"."BIN_FILES"

   (	"FILENO" NUMBER(4,0), 
	"FILENAME" VARCHAR2(256), 
	"CONTENT" BLOB

   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)   TABLESPACE "TEST_TBS"
 LOB ("CONTENT") STORE AS BASICFILE (
  TABLESPACE "TEST_LOB" DISABLE STORAGE IN ROW CHUNK 8192 RETENTION   NOCACHE NOLOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ; The tablespace is a standard ASSM tablespace.

-- 
http://mgogala.byethost5.com

Received on Sat May 12 2012 - 13:08:32 CDT