Re: Flashback log file sync

"Mladen Gogala" <gogala.mladen_at_gmail.com> wrote in message news: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:
|

When puzzled I always look at the output from dbms_metadata in case something I had forgotten about has sneaked into the definition.

 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)) ;
|

As a test, create the LOB as CACHE.

Did you check the session stats to see what your reads were ?

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com
Oracle Core (Apress 2011)
http://www.apress.com/9781430239543