Home » RDBMS Server » Performance Tuning » sga (11g,solaris 9)
sga [message #446558] Tue, 09 March 2010 05:53 Go to next message
Messages: 95
Registered: May 2006
Location: KOLKATA
Can i use alter session set sga_max_size=1830785680 syntax
without having sys or system privilege
Re: sga [message #446561 is a reply to message #446558] Tue, 09 March 2010 05:56 Go to previous message
Michel Cadot
Messages: 63920
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.

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

Current Time: Tue Oct 25 04:04:45 CDT 2016

Total time taken to generate the page: 0.23586 seconds