Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question.

Asked: October 06, 2018 - 11:53 am UTC

Last updated: October 08, 2018 - 1:27 am UTC

Version: 12c R2

Viewed 10K+ times! This question is

You Asked



Trans 1) One temporary table which hold approx 45000 rows fill using cursor.
Trans 2) Now that temporary table update with query which also call using cursor

So when Trans 1 is call at that time following wait event fine "PGA memory operation"
so procedure takes time to run.
How to solve this?

and Connor said...

This event occurs when we need to grab more (or release some) memory for the operation currently being performed. Of course, the action of getting/releasing memory has always been inside Oracle - it is just than in more recent releases, we expose the event so you can see it.

To solve it - tune your SQL. That might sound vague...but its only as vague as the information you've given us :-)

If you really want to dig into the details, check out Frits's blog

https://fritshoogland.wordpress.com/2017/03/01/oracle-12-2-wait-event-pga-memory-operation/



Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database