- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Memory available for a single Oracle instance
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
тАО10-25-2001 04:19 PM
тАО10-25-2001 04:19 PM
Memory available for a single Oracle instance
I think I know Oracle very well - but unfortunatly, I'm a complete rookie to HP-UX. Normaly we use Oracle-Databases with Windows NT or 2K. My Problem: I've got an Oracle 8.1.6i 64Bit on HP-UX 11.0 with 4 GBs of RAM. There's just on Instance on the System. When I try to set the amount of RAM for db_block_buffers to use more then about a 3rd of the total Memory, my Oracle replies "not enough Memory".
I think, it's because I can't give nearly the whole Memory to one Process - so that might by a simple Kernel-Parameter.
As I heard, there are Limitations about that on 32Bit-Systems, but not on 64Bit.
Can anybody help me?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-25-2001 04:26 PM
тАО10-25-2001 04:26 PM
Re: Memory available for a single Oracle instance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-25-2001 04:48 PM
тАО10-25-2001 04:48 PM
Re: Memory available for a single Oracle instance
Another one is a good Unix admin.
You will recreate kernel to set maxdsiz_64 and many other parameters, semaphores, nfiles, nproc .....
Sorry... It is 03:00 AM here, and it seems i am tired.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-25-2001 08:01 PM
тАО10-25-2001 08:01 PM
Re: Memory available for a single Oracle instance
Your kernel seems to need some resizing(increase) of its parameters. The default
kernel param values are low for handling
a oracle database instance. They need
to be increased and even oracle install
guides recommend it.
Your problem seems related with maxdsiz_64
value, though other parameters too would
help with some increase.
The best way to go about this would be
to run SAM and select the database parameter set, which is a set of kernel parms for
a database system. I don't remember the
exact name of the "set", but it can be
seen in SAM.
This would need a reboot of the box.
HTH
raj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-25-2001 09:30 PM
тАО10-25-2001 09:30 PM
Re: Memory available for a single Oracle instance
if you go for the "Monolithic Database Server" template then be sure to change the parameter "timeslice" back to "10", the "1" in the template is contra-productive (and plain silly).
When you apply the template you can easily see what parameters are changed, so make a note to remember those, as you will have to modify those individually later on, perhaps.
Good luck,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-26-2001 07:51 AM
тАО10-26-2001 07:51 AM
Re: Memory available for a single Oracle instance
Increasing following kernel parameters using SAM might help you.
maxdsize-64 and maxtsize-64.
The default for both is 64MB.
Thanks.
Prashant.