Home » RDBMS Server » Server Administration » about sga
about sga [message #582941] Tue, 23 April 2013 10:25 Go to next message
Messages: 33
Registered: September 2012
dear friends
i think that pga is allocate it's size in server ram
not depend's on sga

and what about db_buffer_cache

thank you
Re: about sga [message #582943 is a reply to message #582941] Tue, 23 April 2013 10:29 Go to previous messageGo to next message
Messages: 24177
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:


>and what about db_buffer_cache
It works fine & lasts a long time.

Rather than flail around asking random question I suggest that your time would be better spent by Reading The Fine Manual below!


[Updated on: Tue, 23 April 2013 10:29]

Report message to a moderator

Re: about sga [message #582945 is a reply to message #582941] Tue, 23 April 2013 10:30 Go to previous messageGo to next message
Michel Cadot
Messages: 61941
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All these questions are answered in Database Concepts.
You should read it and ONLY then post questions about points you are not clear.

Re: about sga [message #585211 is a reply to message #582941] Thu, 23 May 2013 00:46 Go to previous message
Messages: 14
Registered: May 2013
Location: Beijing
Junior Member

please give the version of your db?

if it was 10g, you can use the sga_target to manage the sga automatically and pga_xxx_target to manage pga automatically
Previous Topic: About Oracle ReDo log groups
Next Topic: Max process
Goto Forum:

Current Time: Wed Oct 07 15:13:50 CDT 2015

Total time taken to generate the page: 0.06976 seconds