- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- psuedo swap and oracle relationship
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
тАО05-07-2002 11:51 PM
тАО05-07-2002 11:51 PM
I have three instances of database, 1GB, 400MB and 14MB SGA size.
Understands that Oracle requires contiguous memory to startup a database.
I have no issue starting the 1GB db instance, but when it comes to the 400MB instance, oracle complains not enough memory.
Will turning off the psuedo swap increase the chances of having more contigous memory, since psuedo swap in my case is not really neccessary.
With this change, will it increase the probability of starting the remaining two instance of 400MB and 14MB.
Thanks!
Yew Meng
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-08-2002 12:05 AM
тАО05-08-2002 12:05 AM
Re: psuedo swap and oracle relationship
No, turning off pseudo-swap will not 'increase your chances'.
Your problem is caused by the fact that you are using 32 bit Oracle and the system has alimit of 1.75Gb for shared memory.
If you can't upgrade to 64 bit Oracle then I suggest that you investigate Memory Windows (provided you are running HP-UX 11.00). There's an overview document on 11.00 servers at /usr/share/doc/mem_wndows.txt and lots of threads in this forum.
Regards,
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-08-2002 12:25 AM
тАО05-08-2002 12:25 AM
Re: psuedo swap and oracle relationship
I understand your point of the max of 1.75Gb of shared mem.
but the thing is that
1Gb + 400MB + 14MB= 1.414GB share mem.
There is still a certain allowance from the limit of 1.75GB.
I am on K450 with 4CPU and 4GB of RAM running on HP-11.00 (32bits) due to limitation on the H/W.
Therefore I am stuck with Oracle 32bits.
FYI, when psudo swap is turn on, 3GB of MEM is allocated for psuedo swap. What is in always in use by the swap is actually 1.2GB out of 3GB.
Therefore if I turned off the psuedo swap, the 1.2GB possibly contiguous can be use for the oracle instance since I have yet to hit the 1.75GB limit.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-08-2002 12:33 AM
тАО05-08-2002 12:33 AM
Re: psuedo swap and oracle relationship
Pseudo-swap does NOT USE any of your physical memory for swapping.
What pseudo-swap does is just to tell the system to not enforce such strict swap reservation rules as it esle would upon proces creation.
With this HP-UX is allowed to reserve more swap space than there infact is configured on the system (up to 75 % of physical memory)
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-08-2002 01:03 AM
тАО05-08-2002 01:03 AM
Re: psuedo swap and oracle relationship
You can check what shared memory segments exist with ipcs -am.
According to Metalink, Oracle doesn't need contiguous shared memory, it can also operate in contiguous multi-segment, and non-contiguous multi-segment mode.
What version of Oracle are you using and what ORA error do you get?
Regards,
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-08-2002 05:45 PM
тАО05-08-2002 05:45 PM
Re: psuedo swap and oracle relationship
I got your point.
The shared memory is actually for all processes. That is where I miss the point.
The system has a PRECISE process that takes up 400MB of share Memory.
which explains why the second instance of 400MB unable to startup.
FYI, my oracle is running 8.1.6. shmmax defined in the kernal is 600MB.
and in the ipcs -am, the 1GB db instance have two oracle entries, 600MB and 400MB.
John, Can we define the SGA size to be bigger than 1GB but leser than the 1.75GB limit.
I don't really get your point on the contigous multi segment and the non-contiguous multi-segment mode.
It will be great if you can elobrate slightly further or guide me to the relevant site for information.
Thanks!
Yew Meng
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-08-2002 07:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-08-2002 10:09 PM
тАО05-08-2002 10:09 PM
Re: psuedo swap and oracle relationship
You have clarified a lot of my doubts and answered most of my questions.
Thanks!
Yew Meng