My Oracle Support Banner

Parameter PHYSICAL_MEMORY_BYTES Not Available In V$osstat After Migration 11g --> 19c (Doc ID 3026579.1)

Last updated on JULY 03, 2024

Applies to:

Oracle Database - Standard Edition - Version 19.3.0.0.0 and later
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

To determine the available RAM and set automatically the DB parameters depending on the result, in 11g (Standard and Enterprise) the following is used?

Starting the migration process for multiple installations to 19c via the Oracle migration tool. After the first two real migrations it was found that the parameter PHYSICAL_MEMORY_BYTES is missing in v$osstat: in 11gthe parameter was seen but after the migration it disappears in 19c.

Do you know, what happens there? How can the parameter be restored?

Changes

Moved to 19c database.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.