Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-3756

Track Oracle session PGA memory consumption


    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 1.7.0.Alpha1
    • 1.6.0.Final
    • oracle-connector
    • None


      As mentioned in the above discussion, a user is reporting that the aggregate PGA limit is being reached in their environment. They provided their number of log switches and it seems their switch count fell drastically over the recent days before the error. It could be related to the fact that lower log switches mean a longer running ad-hoc session which might be why they experienced the issue.

      As proposed in the discussion, the following would be considered:

      • Add a JMX metric where we capture the PGA memory consumption for the session
      • Periodically log the PGA memory consumption in the logs

      If determined that the PGA memory consumption is growing under this situation, then it would be advisable to introduce a PGA threshold configurable option that users can set to specify a point in which the connector should terminate the current session & re-start if the memory consumption grows beyond the configured value.

            ccranfor@redhat.com Chris Cranford
            ccranfor@redhat.com Chris Cranford
            0 Vote for this issue
            3 Start watching this issue