Re: Gather table stats frees sga!

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 16 Jul 2003 20:20:53 +0200
Message-ID: <hn5bhv03f3hgubuina0h1963etne37k6lv@4ax.com>

On Wed, 16 Jul 2003 17:19:59 +0000 (UTC), Steve Holdoway <steve_at_itemfront.ltd.uk> wrote:

>Hi There,
>
>I run a little job weekly to get the stats updated on all the user
>tables and indexes. On one of my databases, this also frees up about
>100MB from the SGA.
>
>Can anyone suggest a reason for this, and also whether it's something
>to worry about??
>
>Cheers,
>
>
>Steve

Depending on what the 'little job' exactly is, your 'little' job performs DDL. So it will invalidate parts of the datadictionary, and invalidate all SQL statements associated with the object in analysis. If you need to worry, you need to worry about the fact you have 100 Mb of statements in your SGA. Looks like you don't use bind variables

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jul 16 2003 - 13:20:53 CDT