Database Administration (MOSC)

MOSC Banner

Oracle database alert log AVAILABLE_PAGES

edited May 1, 2019 1:45PM in Database Administration (MOSC) 9 commentsAnswered ✓

Hi

Oracle 12.1.0.2.0

Alert log has following info:

....Wed May 01 16:24:47 2019Dump of system resources acquired for SHARED GLOBAL AREA (SGA)Wed May 01 16:24:47 2019 Per process system memlock (soft) limit = UNLIMITEDWed May 01 16:24:47 2019 Expected per process system memlock (soft) limit to lock SHARED GLOBAL AREA (SGA) into memory: 15GWed May 01 16:24:47 2019 Available system pagesizes:  4K, 2048KWed May 01 16:24:47 2019 Supported system pagesize(s):Wed May 01 16:24:47 2019  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)Wed May 01 16:24:47 2019        4K       Configured               9               9        NONEWed May 01 16:24:47 2019     2048K             9214            7681            7681        NONEWed May 01 16:24:47 2019**********************************************************************....

Where does this 9214 comes from..?

(sga_target=15G)

I have 15360 huge pages set.

$ grep Huge /proc/meminfoAnonHugePages:         0 kBHugePages_Total:   15360HugePages_Free:     6027HugePages_Rsvd:     4494HugePages_Surp:        0Hugepagesize:       2048 kB

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