EXPDP backup began to take a long time. It used to just take 15 minutes at first, then all of a sudden it started requiring 90 minutes, delaying the start of EOD. We received a trouble ticket from the application team with the same issue.
top of page
To see this working, head to your live site.
EXPDP/IMPDP has a performance issue due to “Streams AQ: enqueue blocked on low memory”
EXPDP/IMPDP has a performance issue due to “Streams AQ: enqueue blocked on low memory”
1 answer0 replies
Like
1 Comment
bottom of page
EXPDP takes longer to operate due to a memory shortage in the streams pool.
Move from automatic memory to manual memory in order to fix this problem and assigned 200 MB to the streams pool. After making modifications to the RAM setup, EXPDP performance returned to normal.