Hello Oracle Community
I'm running a Oracle Database (primarly used as a Reporting DB with a DB Link to the production system).
Over the DB Link, I issue a lot of Queries (also over night via Jobs) and right now, after a month or so in production, I can see that the CJQ0 process along with the WXXX Processes are growing with regards of the PGA. (see below)
All the queries do access tables, views etc. over the db link. Some queries operate with JSON/XML Files and I'm aware of the fact that this is sometimes a source for PGA leaks, but I have checked and pretty sure that everything is fine.
Even a shutdown and start of the CDB is not resetting the PGA, only a complete restart of the OS will do so.
The Database itself runs in NOCARCHIVE mode.
Any idea what could be a cause of that? (Its a 12 db)
Best Regards
Sebastian
