RE: MGMT_DB_SIZE_GTT trunc 10g

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

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