Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Gather table stats frees sga!

Re: Gather table stats frees sga!

From: Steve Holdoway <steve_at_itemfront.ltd.uk>
Date: Thu, 17 Jul 2003 07:56:40 +0000 (UTC)
Message-ID: <pllchvke3vbsc5u0eua11hp753euimvof7@4ax.com>


On Wed, 16 Jul 2003 20:20:53 +0200, Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote:

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

Well, it's a third party application, and they do use bind vars heavily. Unfortunately, they seem to have forgotten that if there's a single space different in the query, and it is stored as a separate definition...
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address
Many thanks/erg bedankt for the info,

Steve Received on Thu Jul 17 2003 - 02:56:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US