- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 9i uses almost 2 times that of Oracle 8i 32...
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
тАО03-22-2004 11:58 AM
тАО03-22-2004 11:58 AM
Recently we upgraded from Oracle from 8i 32-bit to 9i 64-bit. All the background process are now using 2 twice the amount of memory as compared to Oracle 8i. We have more than 1000 shadow process which also show increase in memory utilization.
Currently we have 8400 with 16 CPU and 6 GB of RAM with 11i. All I want is better understanding why the increase and how should I be able to project the increase number of memory. We need to annouce it to our customer and need exact answer. I would appreciate any information or if someone can point me to the right location (documentation).
Thanks
Sushil Singh
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2004 12:45 PM
тАО03-22-2004 12:45 PM
SolutionAs a 32bit app, Oracle could not easily address more than 950megs of RAM, a bit more if relinked with different options. But all 32bit apps occupy the same shared memory area. Your DBAs may wish to increase SGA to several gigabytes in which case 12Gb would be very useful. You can run your entire app in just 2Gb (with 10Gb of swap space) if you like, but paging (swapping) would degrade performance as much as 100:1.
You could leave the RAM as is and just monitor page out rates with vmstat. If the po column begins to hit double digits, you need more RAM. If it hits triple digits, you need to double RAM to maintain reasonable performance.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2004 12:59 PM
тАО03-22-2004 12:59 PM
Re: Oracle 9i uses almost 2 times that of Oracle 8i 32-bit
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=48089
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-24-2004 02:49 AM
тАО03-24-2004 02:49 AM
Re: Oracle 9i uses almost 2 times that of Oracle 8i 32-bit
In the case of ora_xxx processes, there are nothing that you can do.
In the case of oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-24-2004 03:05 AM
тАО03-24-2004 03:05 AM
Re: Oracle 9i uses almost 2 times that of Oracle 8i 32-bit
I think Bill's answer is the one to focus on. You want it to use more memory. It will provide you better, more reliable performance.
I would add that there are some bugs with resource locking in the Oracle 9i .0 releases. Before you go production you need to get the latest major oracle patch set in.
This patch set converts the data so it does require some downtime.
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
тАО03-24-2004 11:25 AM
тАО03-24-2004 11:25 AM
Re: Oracle 9i uses almost 2 times that of Oracle 8i 32-bit
I wouldn't worry about what the background processes show as being taken by memory. Overall, you are going to see the processes holding a larger amount of memory, however the memory shown is going to be part of the shared memory block that oracle itself is using.
The memory being taken by Oracle should not exceed your sga_max_size. One thing to note however, is that your pga_aggregate_target can grow if it is not set correctly (provided you are using this parameter, which I would recommend).
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-24-2004 09:54 PM
тАО03-24-2004 09:54 PM
Re: Oracle 9i uses almost 2 times that of Oracle 8i 32-bit
Have you opted for manual or auto memmory management ?
The fact that Oracle has a larger adressable space doesn't mean that it's memmory usage will be double !!!
The difference you see lies in your setting, it is not an Oracle database design flaw.
I'm very suprise with all previous answers !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2004 01:33 PM
тАО03-25-2004 01:33 PM
Re: Oracle 9i uses almost 2 times that of Oracle 8i 32-bit
Thank you all for the response. Its was a great insite to my problem. I did little bit more digging and got the following.
Oracle 9i uses 1GB of Large Virtual Memory Page Size and in 8i it used 4 KB. By reducing the page size, I was able to reduce 16% of memory utilization. Going below certain number could increase CPU utiliazation.
Thanks again for great input
Sushl Singh