1 2 3 Previous Next 36 Replies Latest reply on Jan 5, 2016 1:48 PM by JuanM

    SGA,PGA exceeds the memory and oracle is not working

    Hussien Sharaf

      Hi,

      I have wrongly set the following:

      ALTER system SET sga_max_size=1500M scope=spfile;

      ALTER system SET SGA_TARGET=1400M scope=spfile;

      ALTER SYSTEM SET PGA_AGGREGATE_TARGET = 9000M scope=spfile;

      My total memory is 16 GB, Win8

      When I restarted the oracle , it couldn't startup and I m sure 100% that these memory sizes are the problem.

      Now I can't login to the DB to fix these memory sizes.

      How can I modify the SGA, PGA while the whole oracle is down? It is not only the DB instance that is nt working. It s the whole oracle.

       

      Is there a way to modify the spfile from a text editor?

       

      I d appreciate your fast replies.

      Regards,

      Hussien Sharaf

       

      Message was edited by: 3008910

        1 2 3 Previous Next