#_disable_streams_pool_auto_tuning

[ocptechnology]

Streams AQ: enqueue blocked on low memory Oracle wait event

Streams AQ: enqueue blocked on low memory Oracle wait event #oracle #oracledba #oracledatabase

In this article, we are going to discuss the oracle wait event “Streams AQ: enqueue blocked on low memory” due to this wait event we are facing a performance issue in the export backup, today my export backup was in a hung state and it takes a very long time. ideally, the export backup was completed between one to two hours. We try to resolve this issue by increasing the SGA size, but it didn’t…