Fw: flashback buf free by RVWR waits and LOB caching

From: <Laimutis.Nedzinskas_at_seb.lt>
Date: Mon, 28 Feb 2011 16:15:01 +0200
Message-ID: <OF733406EE.5E920ADE-ONC2257845.004DCC97-C2257845.004E4736_at_seb.lt>

Sorry for my misunderstanding.

Innitially I thought the redo increase for small LOBs is caused by bug 6168063 but according to 66431.1 it is a feature. As for a bug then it is valid for 10.2.0.3 while we are on 10.2.0.4. Hope 10204 is not affected by it.

But again, 66431.1 explains quite a lot about possible causes of flashback waits. Specially keeping in mind insufficient write performance (including redo and flash recovery area) we have on our storage.

Thanks everyone for answers,
Laimis N

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 28 2011 - 08:15:01 CST

This message: [ Message body ]
Next message: Niall Litchfield: "Re: Patch "oracle.rdbms.partitioning" is missing in the patchset "oracle.patchset.db-10.2.0.5.0"
Previous message: David Robillard: "Re: database monitoring tools - splunk?"
Maybe in reply to: Laimutis.Nedzinskas_at_seb.lt: "flashback buf free by RVWR waits and LOB caching"
Next in thread: D'Hooge Freek: "RE: 11.2.0.2 clusterware haip - different ip - different switch"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message