My Oracle Support Banner

What Type of Information is Stored in Beehive TM_CHANGED_COMPOSITES and TM_COMPOSITES Tables? (Doc ID 2293188.1)

Last updated on AUGUST 15, 2017

Applies to:

Beehive - Version 2.0.1.8.0 and later
Information in this document applies to any platform.

Goal

When investigating the root cause for an issue with redo logs and attempting to find out the reason for redo log to be much larger than usual and the high transaction rate.

The top sql queries found are:

delete from "BEE_DATA"."TM_CHANGED_COMPOSITES"
insert into "BEE_DATA"."TM_CHANGED_COMPOSITES"("COMPOSITE_EID","COMPOSITE_TYPE","COMPOSITE_SITE_ID","ENTERPRISE_ID","CREATED_ON")
update "BEE_DATA"."TM_COMPOSITES" set "MEMBERSHIP_NEEDED"
update "BEE_DATA"."TM_COMPOSITES" set "COMPOSITE_SESSIONID"


What type of actions in Beehive will cause these deletes / inserts / updates in the TM_CHANGED_COMPOSITES and TM_COMPOSITES tables?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.