- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: DBA Claim: Increasing SGA will reusult in more...
Operating System - HP-UX
1748150
Members
3663
Online
108758
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
тАО03-08-2007 02:06 AM
тАО03-08-2007 02:06 AM
Re: DBA Claim: Increasing SGA will reusult in more CPU Activity. True or False?
Hi Nelson,
In this case, a good idea would be to use the formula twice - at day and at night - and calculate the average of those 2 numbers. If you can do this and give us some feedback it would be nice.
Best Regards,
Eric
In this case, a good idea would be to use the formula twice - at day and at night - and calculate the average of those 2 numbers. If you can do this and give us some feedback it would be nice.
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
тАО03-08-2007 03:20 AM
тАО03-08-2007 03:20 AM
Re: DBA Claim: Increasing SGA will reusult in more CPU Activity. True or False?
Eric, that's what others are leaning.. make statspak analysis during batch, during online and during hybrid operation periods and get NOT the average but the biggest cache requirement.
And that's what I am leaning too. We've money to burn, we can even grow the partition to double the RAM (128GB to 256GB) .. why not increase SGA significantly so during our problematic "hybrid" operation hours -- those DSS like queries and jobs are effectively addressed.
Your thoughts?
And that's what I am leaning too. We've money to burn, we can even grow the partition to double the RAM (128GB to 256GB) .. why not increase SGA significantly so during our problematic "hybrid" operation hours -- those DSS like queries and jobs are effectively addressed.
Your thoughts?
Hakuna Matata.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2007 08:55 PM
тАО03-08-2007 08:55 PM
Re: DBA Claim: Increasing SGA will reusult in more CPU Activity. True or False?
Nelson,
Probably you will get more SGA requirements in the hybrid period but, as I said before, it is a good idea to check this within each period and tune the SGA accordingly for the most demanding period (yes, not the average as I said before...).
Executing the queries above or the one in Metalink Note 105813.1 - "SCRIPT TO SUGGEST MINIMUM SHARED POOL SIZE" you will get a minimum SGA. Add some overhead to it but don't overshoot it:
- An undersized SGA database will be poor in performance;
- An overshooted SGA database will more likely cause ORA-04031 errors due to high fragmentation (see Note 396940.1 - "FAQ: ORA-4031").
Finally, if you are on 10g, you may have advantages in using Automatic Shared Memory Management (SGA_TARGET parameter)...
Best Regards,
Eric Antunes
Probably you will get more SGA requirements in the hybrid period but, as I said before, it is a good idea to check this within each period and tune the SGA accordingly for the most demanding period (yes, not the average as I said before...).
Executing the queries above or the one in Metalink Note 105813.1 - "SCRIPT TO SUGGEST MINIMUM SHARED POOL SIZE" you will get a minimum SGA. Add some overhead to it but don't overshoot it:
- An undersized SGA database will be poor in performance;
- An overshooted SGA database will more likely cause ORA-04031 errors due to high fragmentation (see Note 396940.1 - "FAQ: ORA-4031").
Finally, if you are on 10g, you may have advantages in using Automatic Shared Memory Management (SGA_TARGET parameter)...
Best Regards,
Eric Antunes
Each and every day is a good day to learn.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2007 09:07 PM
тАО03-08-2007 09:07 PM
Re: DBA Claim: Increasing SGA will reusult in more CPU Activity. True or False?
Nelson,
One more thing. What is your shared_pool_reserved_min_alloc?
Best Regards,
Eric Antunes
One more thing. What is your shared_pool_reserved_min_alloc?
Best Regards,
Eric Antunes
Each and every day is a good day to learn.
- « Previous
-
- 1
- 2
- Next »
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