OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » about sga

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

about sga [message #582941]

Tue, 23 April 2013 10:25

compuscience
Messages: 97
Registered: September 2012

Member

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

Report message to a moderator

Re: about sga [message #582943 is a reply to message #582941]

Tue, 23 April 2013 10:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>and what about db_buffer_cache
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!

http://docs.oracle.com/cd/E11882_01/server.112/e25789/toc.htm

[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

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Regards
Michel

Report message to a moderator

Re: about sga [message #585211 is a reply to message #582941]

Thu, 23 May 2013 00:46

deeplydrink
Messages: 14
Registered: May 2013
Location: Beijing

Junior Member

Hi:

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

Report message to a moderator

Previous Topic:	About Oracle ReDo log groups
Next Topic:	Max process

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 16 03:05:08 CDT 2025