Re: MGMT_DB_SIZE_GTT trunc 10g

I remember a couple of posts just a few days ago about a lot of overhead associated with gtt's. But maybe that was deleting the tables, and not truncating them.
I'm trying to see how much overhead this is causing, but it's difficult with only a test user load.
Thanks, Brandon.

On 9/8/05, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> Not familiar with the specifics, but in general TRUNCATE TABLE is a pretty
> low-overhead operation - much less than a DELETE because there is no redo or
> undo generated (not positive on that - someone correct me if I'm wrong). I
> wouldn't expect it to cause you any trouble.
> Regards,
> Brandon
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org]*On Behalf Of *Barbara Baker
> *Sent:* Thursday, September 08, 2005 1:48 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* MGMT_DB_SIZE_GTT trunc 10g
>
> Solaris 9; Oracle 10.1.0.3 <http://10.1.0.3>
>
> Now I remember some of the reasons why I detest OEM so very much.
> User DBSNMP is truncating table MGMT_DB_SIZE_GTT twice every 30 minutes.
> The only reference I can find to this is metalink note 292280.1, which
> seems to indicate that this is expected behavior. (Gee, I didn't expect it!)
> I wouldn't think that truncating a global temp table every 30 minutes would
> be so very good for performance.
>
> Anyone else seen this? Is it causing production problems for you? (We're
> not yet live with this system)
> Thanks!
> Barb
>
> (Here's a snipet from my audit log:)
>
> USERID TIMEST Action name Obj Name SES_ACTIONS
> ------------ ------------------ -------------- --------------------
> -----------
> DBSNMP 08-Sep-2005 10:54 TRUNCATE TABLE MGMT_DB_FILE_GTT
> DBSNMP 08-Sep-2005 10:54 TRUNCATE TABLE MGMT_DB_SIZE_GTT
> DBSNMP 08-Sep-2005 11:24 TRUNCATE TABLE MGMT_DB_FILE_GTT
> DBSNMP 08-Sep-2005 11:24 TRUNCATE TABLE MGMT_DB_SIZE_GTT
> DBSNMP 08-Sep-2005 11:54 TRUNCATE TABLE MGMT_DB_FILE_GTT
> DBSNMP 08-Sep-2005 11:54 TRUNCATE TABLE MGMT_DB_SIZE_GTT
> DBSNMP 08-Sep-2005 12:24 TRUNCATE TABLE MGMT_DB_FILE_GTT
> DBSNMP 08-Sep-2005 12:24 TRUNCATE TABLE MGMT_DB_SIZE_GTT
> DBSNMP 08-Sep-2005 12:54 TRUNCATE TABLE MGMT_DB_FILE_GTT
> DBSNMP 08-Sep-2005 12:54 TRUNCATE TABLE MGMT_DB_SIZE_GTT
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.

>

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