- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Max SGA limit?
Operating System - HP-UX
1748209
Members
2802
Online
108759
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Go to solution
Topic Options
- 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
тАО11-23-2005 09:02 PM
тАО11-23-2005 09:02 PM
This is Oracle 9.0.1.4 on HP Tru64 5.1B. The physical memory is 10GB. How to know the max SGA limit? Is there a solution to avoid the limit?
Thanks
Eric
Thanks
Eric
Solved! Go to Solution.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2005 09:15 PM
тАО11-23-2005 09:15 PM
Re: Max SGA limit?
Hi Eric,
In your situation, the SGA limit is the RAM you have on your system (10Gb) but you should consider lower values.
Best Regards,
Eric
In your situation, the SGA limit is the RAM you have on your system (10Gb) but you should consider lower values.
Best Regards,
Eric
Each and every day is a good day to learn.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2005 09:23 PM
тАО11-23-2005 09:23 PM
Re: Max SGA limit?
hi eric,
for 9.0.1, the maximum SGA recommended by Oracle is to set the kernel settings:
SHM_MAX 4278190080 (4 GB less 16MB)
to check current SGA:
SQL> show sga
regards.
for 9.0.1, the maximum SGA recommended by Oracle is to set the kernel settings:
SHM_MAX 4278190080 (4 GB less 16MB)
to check current SGA:
SQL> show sga
regards.
what you do not see does not mean you should not believe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-24-2005 02:53 PM
тАО11-24-2005 02:53 PM
Solution
Hi Eric,
Until oracle 8i the System Global Area (SGA) has been static. Since Oracle9i it allows the DBA to modify the SGA size dynamically. This provides an SGA that will grow and shrink in response to a DBA command. SGA_MAX_SIZE specifies the maximum size of SGA for the lifetime of the instance.
This feature implements an infrastructure to allow the Oracle server to change the SGA configuration without shutting down the instance. The Oracle Server can modify the physical address space use to respond to the operating system's use of physical memory.
Begining with Oracle9i, the dynamic SGA infrastructure will allow for the sizing of the Buffer Cache, Shared Pool and the Large Pool without having to shutdown the database. The dynamic SGA infrastructure also allows the limits to be set at run time on how much physical memory will be used for the SGA. The instance will be started under-configured and will use as much memory as the operating system gives it.
For more details refer to Note:148495.1 in Metalink. And also Note:69119.1 describes the components of SGA.
Indira A
Until oracle 8i the System Global Area (SGA) has been static. Since Oracle9i it allows the DBA to modify the SGA size dynamically. This provides an SGA that will grow and shrink in response to a DBA command. SGA_MAX_SIZE specifies the maximum size of SGA for the lifetime of the instance.
This feature implements an infrastructure to allow the Oracle server to change the SGA configuration without shutting down the instance. The Oracle Server can modify the physical address space use to respond to the operating system's use of physical memory.
Begining with Oracle9i, the dynamic SGA infrastructure will allow for the sizing of the Buffer Cache, Shared Pool and the Large Pool without having to shutdown the database. The dynamic SGA infrastructure also allows the limits to be set at run time on how much physical memory will be used for the SGA. The instance will be started under-configured and will use as much memory as the operating system gives it.
For more details refer to Note:148495.1 in Metalink. And also Note:69119.1 describes the components of SGA.
Indira A
Never give up, Keep Trying
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP