Database Memory & 4030/4031 (MOSC)

MOSC Banner

PGA 'kol vstring'

edited Mar 24, 2020 9:30AM in Database Memory & 4030/4031 (MOSC) 5 commentsAnswered

Hello,

we mitgratet from Oracle Database 11.2.0.3 SE1 to 19.3.

We are observing a constantly growing PGA consumption for all our processes that run as PL/SQL package. In average it is 10 MB more per day.

We use dedicated server connections. OS is now Linux CentOS 7.6 and was CentOS 6.1 before. The old system wir 11g R2 had no problems in terms of memory consumption.

Investigations revealed that 'kol vstring' is growing constantly. Here the biggest heap buffers of one of our process:

SELECT TO_CHAR (RATIO_TO_REPORT(bytes) OVER () * 100, '90D0') "%", category, name, heap_name, TO_CHAR (bytes, '999G999G000') "Bytes"

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center