ESP dSeries Workload Automation

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

What role does esp_subscription and esp_manager_inq in WADE?

  • 1.  What role does esp_subscription and esp_manager_inq in WADE?

    Posted Apr 27, 2020 08:32 AM
      |   view attached
    What is the role of the esp_subscription table?
    This table has 10 million inserts and 10 million deletes per day.
    As a result, excessive redolog is occurring.
    What role does esp_subscriptions and esp_manager_inq  Table?

    Thanks


  • 2.  RE: What role does esp_subscription and esp_manager_inq in WADE?
    Best Answer

    Broadcom Employee
    Posted Apr 28, 2020 08:01 AM
    Hi,

    ESP_MANAGER_INQ - It contains all the incoming messages to the server. 
    ESP_SUBSCRIPTIONS - It contains the job dependencies information

    The number of inserts/ deletes depends on the workload. It is better to raise a ticket to investigate it.

    Ravi Kiran
    Original Message