Home » RDBMS Server » Server Administration » how to create best profile?
how to create best profile? [message #578803] Tue, 05 March 2013 05:45 Go to next message
compuscience
Messages: 33
Registered: September 2012
Member
how to create best profile for huge user in oracle database
user which take lagre uga memory

thanks
Re: how to create best profile? [message #578804 is a reply to message #578803] Tue, 05 March 2013 05:47 Go to previous messageGo to next message
Michel Cadot
Messages: 59757
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Define 'best".
Maybe with composite_limit and private_sga unlimited.

Regards
Michel
Re: how to create best profile? [message #578813 is a reply to message #578804] Tue, 05 March 2013 07:29 Go to previous messageGo to next message
compuscience
Messages: 33
Registered: September 2012
Member
what i mean i need to make profile to run huge user on it
Re: how to create best profile? [message #578815 is a reply to message #578813] Tue, 05 March 2013 07:39 Go to previous messageGo to next message
Michel Cadot
Messages: 59757
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Define "huge" user.

Regards
Michel
Re: how to create best profile? [message #578839 is a reply to message #578815] Tue, 05 March 2013 12:26 Go to previous messageGo to next message
compuscience
Messages: 33
Registered: September 2012
Member
i mean user that use big value for UGA
Re: how to create best profile? [message #578841 is a reply to message #578839] Tue, 05 March 2013 12:47 Go to previous message
BlackSwan
Messages: 23037
Registered: January 2009
Senior Member
>i mean user that use big value for UGA
at what value does user go from being normal to being "big"?
how big is "big value for UGA"?

http://www.orafaq.com/wiki/UGA

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

http://www.orafaq.com/forum/t/88153/0/
Previous Topic: ASM instance
Next Topic: upgrade from 9.2.0.8 2 node RAC to 11.2.0.3 2 node RAC.. please review plan
Goto Forum:
  


Current Time: Mon Nov 24 10:27:27 CST 2014

Total time taken to generate the page: 0.11462 seconds