Home » RDBMS Server » Performance Tuning » sga (11g,solaris 9)
sga [message #446558] Tue, 09 March 2010 05:53 Go to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
Can i use alter session set sga_max_size=1830785680 syntax
without having sys or system privilege

Report message to a moderator

Re: sga [message #446561 is a reply to message #446558] Tue, 09 March 2010 05:56 Go to previous message
Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"alter session set sga_max_size=" is not a valid statement.

It is only on ALTER SYSTEM and you must have ALTER SYSTEM privilege.

Regards
Michel

Report message to a moderator

Previous Topic: Tune "where col in (val1,val2,val3)
Next Topic: Explicit cursor data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 11 08:02:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.