Re: Huge memory consumption during hot backup

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 18 Sep 2004 06:43:05 +1000
Message-ID: <414b4c54$0$20127$afc38c87@news.optusnet.com.au>

Paolo wrote:

> Hello Howard,
> I tried to use the scripts you wrote
> (http://www.dizwell.com/html/scripted_backups.html), but I'm
> experiencing the same available memory decrease (from 750 Mb to 250
> Mb), while the scripts execute the "objFS.COPYFile strInput,
> strOutput" command on a 2 Gb datafile (I've about 10 datafiles sized 2
> Gb).

OK, thank you for the feedback. Clearly, since two rather different backup scripts produce the same outcome, it's very likely an attribute as you say of Windows file cache management.

Useful to know. I see Brian has unearthed an MS paper that might help there. (Thanks Brian!).

> I think that it is a problem related to Windows file cache management,
> even if I don't know how to manage it. As I wrote, I've already tried
> to change the the "File and Printer Sharing for Microsoft Networks"
> properties but with no success.
>
> I'll try with RMAN ASAP...

That, ultimately, is your best bet, without a doubt.

Regards
HJR Received on Fri Sep 17 2004 - 15:43:05 CDT