- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: oracls SGA
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
тАО02-27-2008 07:26 AM
тАО02-27-2008 07:26 AM
oracls SGA
Thanks,
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2008 11:03 AM
тАО02-27-2008 11:03 AM
Re: oracls SGA
My guess is that it's because that number is used to set the sga_max_size to something *larger* than the default. Since you're not there, it would have no impact.
That's just my guess as to how this could happen. But - you can standup a 600M sized database without indicating the sga_max_size at all.
I don't know what the default is, but I know that I if I don't have mine set large enough, I can't bring up the database. However, my SGA sizes are much larger than what we are talking here.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2008 11:30 AM
тАО02-27-2008 11:30 AM
Re: oracls SGA
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2008 12:37 PM
тАО02-27-2008 12:37 PM
Re: oracls SGA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2008 06:19 PM
тАО02-27-2008 06:19 PM
Re: oracls SGA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-28-2008 08:42 AM
тАО02-28-2008 08:42 AM
Re: oracls SGA
Find out if the default is higher by looking it up in the running instance:
show parameter sga
select name,value from v$parameter where
name like '%sga%'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-29-2008 11:35 AM
тАО02-29-2008 11:35 AM
Re: oracls SGA
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 487551400
1* select name,value from v$parameter where name like '%sga%'
NAME
----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
sga_max_size
487551400
pre_page_sga
FALSE
lock_sga
FALSE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-29-2008 11:52 PM
тАО02-29-2008 11:52 PM
Re: oracls SGA
what does the query below show?
show parameter sga_target
revert
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2008 08:54 AM
тАО03-01-2008 08:54 AM
Re: oracls SGA
This is 64 bit oracle right, or still using 32 bit?
Anyway, here are some thoughts...
Check out metalink 171634.1:
"Spfile Parameter SGA_MAX_SIZE can be Smaller than SGA Size"
...
"The SGA_MAX_SIZE parameter is used to limit the dynamic sizing of SGA
parameters. If the SGA_MAX_SIZE parameter value in the spfile is smaller than
the addition of all SGA components, then the dynamic value of SGA_MAX_SIZE
instance parameter is automatically set by Oracle to the SGA size."
You may also want to check out # 148495.1 "Dynamic SGA" it explains how there will be 16MB granules.
600MB is not divisible by 16, so it may round up to 38*16*1024*1024 = 637534208, but that's still not 655331328
Good luck,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2008 10:54 AM
тАО03-03-2008 10:54 AM
Re: oracls SGA
I am returned a blank like w/ that query.
Hein van den Heuvel,
We had memory pressure do to the increase to 600mb and we have reverted to 450. 29*16*1024*1024 = 486539264 (464mb) seems to make sense now but still can't explain what was going on at 650mb. I'll let this go for now. Thanks for everyone's involvement.
Mike