Error while running BIP report (0ORA-10260: limit size (1048576) of the PGA heap set by event 10261

Question

Content

Hi,

We are getting an below error while working on BIP report to fetch Person data in HCM module. Any idea what could be the cause..?  Thanks!

ORA-10260: limit size (1048576) of the PGA heap set by event 10261 exceeded

Any help is highly appreciated.

~ GK ~ · Answer

Thanks Aravind. We are following this approach and simplifying the complex unions.

Aravind Ragul-4349 · Answer

Hi Gaurav,

Even we faced the same issue where the code worked in one instance and ran into error in another instance where I wanted it to run :)

As a work around we ran the code with multiple datasets(we split the unions to different datasets) and designed the template accordingly so we have the output in a single file.

Let me know if this helps

Thanks,

Arav

~ GK ~ · Answer

Thanks all. Yes, you all are right, it has to do with the complex SQL. Our SQL is 2000+ lines of code with outer joins and Unions. Surprisingly when same SQL is execute on the other customer POD it is executing like charm. We are on Saas when raised SR we got the same standard answer , it is custom SQL and we need to tune the query. We are tuning the query now.

Thanks again for your response.

Thanks

~ GK ~