List of all states from COMPOSITE_INSTANCE, CUBE_INSTANCE, DLV_MESSAGE tables
- by Deepak Arora
In many of my engagements I
get asked repeatedly about the states of the composites in 11g and how
to decipher them, especially when we are troubleshooting issues around
purging. I have compiled a list of all the states from the
COMPOSITE_INSTANCE, CUBE_INSTANCE, DLV_MESSAGE and MEDIATOR_INSTANCE tables. These are the
primary tables that are…