Database Administration (MOSC)

MOSC Banner

Memory consumption issues with Database 19c on Windows?

in Database Administration (MOSC) 28 commentsAnswered

Hello everyone,

We have been having a problem ever since migrating our database from 12.1 on Windows 2008 to 19c (patched to 19.15) on Windows 2016. For whatever reason, after a couple of weeks, the RAM usage of our oracle.exe process is approaching 15 GB even though our memory targets in Oracle are configured to 8 GB. There are also a ridiculous number of "handles" open by oracle.exe when viewing the process usage in Task Manager or Process Explorer - I've seen it get over 3 million.

Once oracle.exe has been running long enough and is using around 15 GB of RAM and has over 3 million handles open, it will eventually hang and/or crash. The odd thing is that so far every time it has hung/crashed was when our daily RMAN backup tried to run while oracle.exe was in this bloated state. Nothing else to this point has triggered it. RMAN starts, and usually right at the beginning of the backup, database performance starts to falter and eventually either crashes or has to be restarted.

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