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: 25
Registered: September 2012
Junior 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: 54247
Registered: March 2007
Location: Nanterre, France, http://...
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: 25
Registered: September 2012
Junior 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: 54247
Registered: March 2007
Location: Nanterre, France, http://...
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: 25
Registered: September 2012
Junior 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: 20111
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/

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: Sat May 25 23:18:44 CDT 2013

Total time taken to generate the page: 0.11396 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.