Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Per Process system memlock and huge page

j_DBA_souravMay 1 2015 — edited May 3 2015

Hello All,

I noticed in our new environment while database starts It shows the dump of system resource information for SGA. This is showing us few information of which I am confused.

It says,

--

Per process system memlock (soft) limit =193g

Expected per process system memlock (soft) limit to lock.

Shared Global  area into memory 4096M.

Available system page size

4K, 2048k

Supported system pagesize:

pagesize =4K, available_pages=configured, expected_pages=1048581, Allocated pages=1048581 and No errors.

Reasons, for not supporting certain system pagesizes:

2048K- Dynamic allocate and free memory regions

--
Now I am not understanding where from 193G is coming!

cat /proc/meminfo | grep -i Huge

AnonHugePages:     407552 kb

Hugepages_total:     0

Hugepages_free:     0

Hugepages_rsvd;     0

Hugepages_Surp:     0

Hugepagesize:          2048 Kb

cat /etc/sysctl.conf | grep -i huge     says nothing.

shmmni=4096

shmall =1835008

shmmax= 6388763852

sem = 250 32000 100 128

Could you please help me to understand where from getting the value 193g?

Oracle versoin: 12.1.0.2.0 and RHEL 6.6

Regards,

J_DBA_Sourav

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2015
Added on May 1 2015
8 comments
2,626 views