Patch Reviews - DB (MOSC)

MOSC Banner

19.9 - Patch 31719903: WINDOWS DATABASE BUNDLE PATCH 19.9.0.0.201020

edited Jan 29, 2021 11:18AM in Patch Reviews - DB (MOSC)

We are running Oracle Enterprise 19.7 on 64 bit Windows and applied the 19.9 patch.

This had a quite severe detrimental effect on the performance of quite a few critical application SQL statements

This main symptom of the problem was many SQL statements waiting on "PGA memory operation"

At one stage this accounted for 90% of all DB Time which crippled our systems

Be very careful when applying this patch and be prepared to pin specific SQL statements to know good plans which have good execution times. It may be worth creating a SQL Tuning Set prior to applying the patch.

We ended up rolling back the patch but still had to pin specific SQL statements to know good plans as the patch rollback did not reverse the bad optimizer performance

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center