- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Shared memory problem with oracle 8.0.6
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
тАО02-28-2001 08:39 AM
тАО02-28-2001 08:39 AM
K460, HP-UX 10.20,Oralce 8.0.6,1.8GB mem, with 85% memory utilization.
We are getting following errors...SQL*Plus: Release 8.0.6.0.0 - Production on Mon Feb 26 16:50:37 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","BEGIN
DBMS_OUTPUT.DISABLE; E...","PL/SQL MPCODE","BAMIMA: Bam Buffer")
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","BEGIN
DBMS_APPLICATION_INFO....","PL/SQL MPCODE","BAMIMA: Bam Buffer")
any help.. any suggestions.....Thanks in advance.....
Chris.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-28-2001 08:55 AM
тАО02-28-2001 08:55 AM
Solution04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s")"
// *Cause: More shared memory is needed than was allocated in the shared
// pool.
// *Action: Either use the dbms_shared_pool package to pin large packages,
// reduce your use of shared memory, or increase the amount of
// available shared memory by increasing the value of the
// init.ora parameter "shared_pool_size".
Looks like your SGA needs tuning.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-28-2001 10:45 PM
тАО02-28-2001 10:45 PM
Re: Shared memory problem with oracle 8.0.6
On the HP-UX 10.20 you should not exceed an SGA size of 1.75 GB. This is limited by the 32-bit OS you are using.
If you have several databases running on that machine, all the SGA's added should not exceed
that magic number. For the tuning first use the pinning. That takes a lot of load away from the memory.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2001 01:50 AM
тАО03-01-2001 01:50 AM
Re: Shared memory problem with oracle 8.0.6
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2001 05:20 AM
тАО03-01-2001 05:20 AM
Re: Shared memory problem with oracle 8.0.6
As mentioned by another user, I should increase the SGA of oracle by modifying the initXXX.ora file. For a database with some gigs of info, you could set it to 50Mb.
Sometimes (with Oracle Reports) it is required to change the kernel parameter MAXDSIZ to 256 Mb.
Regards,
Dieter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2001 06:26 AM
тАО03-01-2001 06:26 AM
Re: Shared memory problem with oracle 8.0.6
We don't have SGA more than 1.75, as total memory is 1.8 and currently 85%+ used.
Do you have any links where we can look for tunning stuff, you mentioned.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2001 07:23 AM
тАО03-01-2001 07:23 AM
Re: Shared memory problem with oracle 8.0.6
Look at the message titled 'Attention Dragan Krnic'.
I posted a message with an attachment to pin packages.
If you have any questions, email me at :
Alexander_Ermes@web.de
Rgds
Alexander M. Ermes