- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: ORA-27102 out of memory error
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2004 08:35 AM
тАО04-22-2004 08:35 AM
The machine we have is HPUX 9000 64 bits 11i server, only have one oracle instance. The oracle version is 9.2.0.1.
Here are my server kernel information, inlcuding oracle SGA size. The answers I got from Oracle is: I need to increase the size of my maxdsiz, maxssiz. Also i need to apply the 9.2.0.4 patches on my server.
SQL> show sga
Total System Global Area 969501240 bytes
Fixed Size 735800 bytes
Variable Size 251658240 bytes
Database Buffers 716800000 bytes
Redo Buffers 307200 bytes
SQL>
Parameter Current Dyn Planned Module Version
===============================================================================
dbc_max_pct 50 - 50
dbc_min_pct 5 - 5
default_disk_ir 0 - 0
desfree - - 0
max_async_ports 50 - 50
max_fcp_reqs 512 - 512
max_mem_window 0 - 0
max_thread_proc 256 - 256
maxdsiz 1073741824 - 1073741824
maxdsiz_64bit 2147483648 - 2147483648
maxfiles 60 - 60
maxfiles_lim 1024 Y 1024
maxqueuetime - - 0
maxssiz 134217728 - 134217728
maxssiz_64bit 1073741824 - 1073741824
maxswapchunks 16384 - 16384
maxtsiz 0x4000000 Y 0X4000000
maxtsiz_64bit 0x40000000 Y 0X40000000
maxuprc 3686 Y ((NPROC*9)/10)
maxusers 32 - 32
maxvgs 10 - 10
mesg 1 - 1
minfree - - 0
modstrmax 500 - 500
msgmap 4098 - (2+MSGTQL)
msgmax 8192 Y 8192
msgmnb 16384 Y 16384
msgmni 4096 - (NPROC)
msgseg 32767 - 32767
msgssz 8 - 8
msgtql 4096 - (NPROC)
semaem 16384 - 16384
semmap 4098 - (SEMMNI+2)
semmni 4096 - 4096
semmns 8192 - (SEMMNI*2)
semmnu 4092 - (NPROC-4)
semmsl 2048 Y 2048
semume 10 - 10
semvmx 32768 - 32768
sendfile_max 0 - 0
shmem 1 - 1
shmmax 2147483648 Y 2147483648
shmmni 512 - 512
shmseg 32 Y 32
Anyone could tell me how big I should increase?
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2004 09:15 AM
тАО04-22-2004 09:15 AM
Solutionchange:
dbc_max_pct 50 - 50
dbc_min_pct 5 - 5
dbc_max_pct 7 - 7
dbc_min_pct 5 - 5
Thats a kernel change, if you are new, get your sysadmin to do it with sam.
Next:
swapinfo -tam
Do you have enough swap. If you are utilizing a lot of swap, you need more. Maybe you want to increase it. Post the results.
ipcs
See that you have adequate shmmax and shmseg(also a kernel deal).
There is also an Oracle patch that takes 9.2.0.1 to 9.2.0.4
You need to get that installed, it involves a data conversion.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2004 02:06 PM
тАО04-22-2004 02:06 PM
Re: ORA-27102 out of memory error
You must have read Metalink Note: 169706.1?
On the Kernel Parameter settings on the HP-UX 11.11 (64bit), to run 9.2.0 :
KSI_ALLOC_MAX (NPROC*8)
MAX_THREAD_PROC 256
MAXDSIZ 1073741824 bytes
MAXDSIZ_64BIT 2147483648 bytes
MAXSSIZ 134217728 bytes
MAXSSIZ_64BIT 1073741824
MAXSWAPCHUNKS 16384
MAXUPRC ((NPROC*9)/10)
MSGMAP (MSGTQL+2)
MSGMNI NPROC
MSGSEG 32767
MSGTQL NPROC
NCALLOUT (NKTHREAD+16)
NCSIZE ((8*NPROC+2048)+VX_NCSIZE)
NFILE (15*NPROC+2048)
NFLOCKS 4096
NINODE (8*NPROC+2048)
NKTHREAD (((NPROC*7)/4)+16)
NPROC 4096
SEMMAP (SEMMNI+2)
SEMMNI 4096
SEMMNS (SEMMNI*2)
SEMMNU (NPROC - 4)
SEMVMX 32768
SHMMAX AvailMem
SHMMIN 1
SHMMNI 512
SHMSEG 32
VPS_CEILING 64
which you should have follow.
May I know what is the size of your physical memory?
regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2004 03:05 PM
тАО04-22-2004 03:05 PM
Re: ORA-27102 out of memory error
Make sure your
#ulimit
is unlimited.
make sure you have higher values for the shared memory (SHMMAX) and semaphore kernel parameters.
Bring down your dbc_max_pct.THis is dynamic buffer cache.By default it is 50% of memory value.Bring down to a percentage where the value is around 300MB.
REvert on the server model,its configuration and the kernel parameters
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2004 01:01 AM
тАО04-23-2004 01:01 AM
Re: ORA-27102 out of memory error
HP-UX pics01a B.11.11 U 9000/800 110434670 unlimited-user license
CPU Count: 4
CPU Speed: 875 MHz
CPU HW Support: 64-bit
Kernel Support: 64-bit
RAM Size: 2048 MB
bufpages: 336 MB
maxuprc: 3686
maxvgs: 10
maxfiles: 60
max_thread_proc: 256
nfile: 63498
nflock: 4096
nproc: 4096
ninode: 34816
shmmax: 1073741824
shmmni: 512
dbc_max_pct: 50
Thanks
Leah
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2004 01:31 AM
тАО04-23-2004 01:31 AM
Re: ORA-27102 out of memory error
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2004 01:34 AM
тАО04-23-2004 01:34 AM
Re: ORA-27102 out of memory error
For a small db you can also setup the following parameters:
maxfiles 1024
maxfiles_lim 2048
have a nice WE