Hi Ram,
For increasing the size of SGA, you have to change the SGA_MAX_SIZE, JAVA_POOL_SIZE in your init.ora file only.
You cannot change the JAVA_POOL_SIZE and SGA_MAX_SIZE using the SQL command.
It is recommanded that JAVA_POOL_SIZE must be less than the Shared_pool_size and it's depend on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.