Database Tuning (MOSC)

MOSC Banner

PGA use increasing over time for persistent connections

edited Jan 8, 2019 10:19AM in Database Tuning (MOSC) 17 commentsAnswered

Oracle 12.1.0.2 Not RAC

pga_aggregate_limit        25769803776 24G

pga_aggregate_target     12884901888 12G

sga_max_size                    80G

sga_target                          80G

Linux  2.6.32-696.20.1.el6.x86_64

Mem:  126080164k total, 124091952k used,  1988212k free,  1315544k buffers

Swap: 16775164k total,        0k used, 16775164k free, 16012504k cached

We have experienced swapping problems in the last couple of months.  We had one extended outage due to constant swapin/swapout activity (shutdown abort and killing processes I hate that).

I've found that the total PGA being used increases over time.  The application uses connection pooling (for the most part) and the connections are persistent for weeks at a time.  The use of swap seems to be associated with the increased PGA use.

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