Pokazywanie postów oznaczonych etykietą shmmax. Pokaż wszystkie posty
Pokazywanie postów oznaczonych etykietą shmmax. Pokaż wszystkie posty
czwartek, 17 października 2013
PostgreSQL SHMMAX, SHMALL calculation
8GB = memory=8589934592
python pgtune \ -i /etc/postgresql/9.2/main/postgresql.conf \ -o postgresql.conf \ --memory=8589934592 \ --type=Desktop \ --connections=10
---------------------------------------------------------------------
http://dbasolutions.wikispaces.com/SHMMAX+and+SHMALL
Subskrybuj:
Posty (Atom)
-
Problem solved ;) Client tool's installer does not provide all the required libraries, so the message: " sawjniapi643r.dll: Can... -
http://www.ritzyblogs.com/OraTalk/PostID/104/How-to-configure-stunnel-for-Oracle-with-example How to configure stunnel for Oracle with...
-
1) Sprawdzamy do jakiego profilu należy dany user: SELECT profile FROM dba_users WHERE username = 'DBF' 2) Sprawdzanie jakie są...
Configuring SHMMAX and SHMALL for Oracle in Linux
SHMMAX and SHMALL -
SHMMAX is the maximum size of a single shared memory segment set in “bytes”.
silicon:~ # cat /proc/sys/kernel/shmmax536870912
536870912 = 512 kB -> (512 * 1024 * 1024)
SHMALL is the total size of Shared Memory Segments System wide set in “pages”.silicon:~ # cat /proc/sys/kernel/shmall
1415577
==============================================================================================The key thing to note here is the value of SHMMAX is set in "bytes" but the value of SHMMALL is set in "pages".==============================================================================================