- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle user memory consumption
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
тАО12-27-2001 05:08 AM
тАО12-27-2001 05:08 AM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-27-2001 05:24 AM
тАО12-27-2001 05:24 AM
Re: Oracle user memory consumption
Oracle documentation defines SGA as the 'a group of shared memory structures that contain data and control information for one Oracle database instance. If multiple users are concurrently connected to the same instance, the data in the instance's SGA is "shared" among the user'
Apart from it each user process uses an area called PGA 'it is a memory region containing data and control information for a single process (server or background). Consequently, a PGA is sometimes called a "process global area."
A PGA's size is fixed and operating-system specific.
And HPUX I am not sure what this fixed value is.
Hope ths helps
...BPK...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-27-2001 05:41 AM
тАО12-27-2001 05:41 AM
SolutionThe amount of memory a databaseconnection consumes depends on the oracle version AND what the connection is doing. In my experience (and I'm looking at glance right now) this is not a static number. Also take into account that part of this use is "shared". That part is static. You will indeed find that most processes consume +/- 3Mb. Only +/- 1.5 Mb is private, the rest is shared. In "normal" online transactions (and I'm looking at a heavily used database right now) processes will not go above 10Mb. In batch transactions (or Datawarehouse queries) this can be a lot more. You would benefit from "dissecting" a couple of oracleprocesses with the "Memory Regions" menu in glance to learn more about this.
Hope this helps,
Tom Geudens
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-27-2001 09:38 AM
тАО12-27-2001 09:38 AM
Re: Oracle user memory consumption
I'm sure that you are aware that there is no real answer to this question except 'it depends'. You really violated Rule Number One - Never believe the vendor. The amount of memory that each client consumes depends very heavily upon the application. The good news is that much of the memory tends to be shared text. Whenever I am sizing systems, I always allow 5MB per client plus the estimated SGA plus the estimated size of the server executables. At 5MB per client, I have yet to be burned and my rule of thumb is always buy more memory than you think you will need.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-27-2001 03:33 PM
тАО12-27-2001 03:33 PM
Re: Oracle user memory consumption
*they* were perhaps talking about "shared servers", but you are using "dedicated servers" (as most of us do)?
Just my $0.02,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-27-2001 04:09 PM
тАО12-27-2001 04:09 PM
Re: Oracle user memory consumption
If oracle told you that, then I agree with clay, and as I like to say: all salespeople are pond scum.
With resource pigs like oracle, I like to make sure I have more memory than I think I need (usually I calculate amount needed, then multiply by 1.5), the same goes for CPU's.
live free or die
harry