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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms