Database Administration (MOSC)

MOSC Banner

why oracle has 3 segments?

edited Apr 4, 2024 9:52AM in Database Administration (MOSC) 6 commentsAnswered ✓

Oracle 11gR2, Oracle Linux 7.9

sga: 700M, shmmax: 4398046511104, ram: 4G

sga fit in large pages.

Per process system memlock (soft) limit = 128 GB

Large page usage restricted to processor group "user.slice"

Total Shared Global Region in Large Pages = 702 MB (100%)

WARNING:
The parameter _linux_prepage_large_pages is explicitly disabled.
Oracle strongly recommends setting the _linux_prepage_large_pages
parameter since the instance is running in a Processor Group. If there is
insufficient large page memory, instance may encounter SIGBUS error
and may terminate abnormally.

Large Pages used by this instance: 351 (702 MB)
Large Pages unused in Processor Group user.slice = 0 (0 KB)
Large Pages configured in Processor Group user.slice = 351 (702 MB)

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