Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-73057

Huge data in AO_733371_EVENT_PARAMETER has impact on undo space of Oracle DB

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Unresolved
    • None
    • Email notifications
    • None
    • 2
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      The customer is using Oracle DB in production environment. They encountered a problem that Undo space in almost full.

      It is identified that the deletion of AO_733371_EVENT_PARAMETER caused this problem.

      SQL_ID：7z8pmm0qmhmhf
delete from "AO_733371_EVENT_PARAMETER" where "AO_733371_EVENT_PARAMETER"."EVENT_ID" in (select "AO_733371_EVENT"."ID" from "AO_733371_EVENT" "AO_733371_EVENT" where "AO_733371_EVENT"."CREATED" <= :1 )

      It should be due to  too much data written to AO_733371_EVENT_PARAMETER table.

      In order to avoid the impact to undo space, the customer wish we can reduce the writing to AO_733371_EVENT_PARAMETER. 

       

      Note

      One cause is  below existing issue. Seems the table keeps growing bigger, though batched mail is disabled as mentioned.

      • JSWSERVER-20794: Disable populating the database table AO_733371_EVENT_PARAMETER table when Batching feature is disabled

      It is better to check any other cause which contribute to too much data in AO_733371_EVENT_PARAMETER.

            [JRASERVER-73057] Huge data in AO_733371_EVENT_PARAMETER has impact on undo space of Oracle DB

            Gonchik Tsymzhitov added a comment -

            Any news around that?

            Gonchik Tsymzhitov added a comment - Any news around that?

            Gonchik Tsymzhitov added a comment -

            +1

            Gonchik Tsymzhitov added a comment - +1

              Unassigned Unassigned
              rli@atlassian.com Rick Li
              Votes:
              6 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated: