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: 97
Registered: September 2012
Member
how to create best profile for huge user in oracle database
user which take lagre uga memory

thanks

Report message to a moderator

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: 68786
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Define 'best".
Maybe with composite_limit and private_sga unlimited.

Regards
Michel

Report message to a moderator

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: 97
Registered: September 2012
Member
what i mean i need to make profile to run huge user on it

Report message to a moderator

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: 68786
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Define "huge" user.

Regards
Michel

Report message to a moderator

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: 97
Registered: September 2012
Member
i mean user that use big value for UGA

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
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/

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Oct 14 22:12:03 CDT 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.