Not really. Saw issues with improper management but not with chaotic change of value for init.ora parameter. I bet someone changed it in some way. Changed directly in init.ora or spfile? Or maybe someone did increase back then with scope=memory (or even spfile wasn't used)? On 8/13/07, Robert Freeman <robertgfreeman@xxxxxxxxx> wrote: > I'm working on a Standard Edition database on XP, 10g. > I'm seeing the FRA size change. In July it was set to > 200GB, and now, as if by magic, it's changed to some > lower value, which of course it trouble!! The alert > log does not show any alter system commands that would > have downsized this parameter. > > Has anyone seen anything like this? > > RF > > Robert G. Freeman > Author: > Now Available for Pre-Sales on Amazon.com!!!! > ************************************************** > Oracle Database 11g New Features (Oracle Press) > ************************************************** > Portable DBA: Oracle (Oracle Press) > Oracle Database 10g New Features (Oracle Press) > Oracle9i RMAN Backup and Recovery (Oracle Press) > Oracle9i New Feature > Blog: http://robertgfreeman.blogspot.com/s (Oracle Press) > -- > //www.freelists.org/webpage/oracle-l > > > -- Alex Gorbachev, Oracle DBA Brewer, The Pythian Group http://www.pythian.com/blogs/author/alex http://www.oracloid.com BAAG party - www.BattleAgainstAnyGuess.com -- //www.freelists.org/webpage/oracle-l