How to set sga_max_size in oracle 11g?

Asked by Calico Charly

Report
in progress 114
7 Answers 228 views

Leave a reply to Calico Charly : set sga_max_size in oracle 11g


Answers ( 7 )

  1. Anna

    When using Automatic Memory Management, what value should SGA_MAX_SIZE be? Should it be 0? These are my current settings, and I'm unsure whether to leave SGA_MAX_SIZE
    Read More

    Ratings : 12 %   

      
  2. Rebellious Francis

    I have 2 oracle 11g databases with 2 different character set db1 character set is WE8ISO8859P1 db2 character set is AL16UTF16 I need to change db2 character to
    Read More

    Ratings : 24 %   

      
  3. Long Samuel

    The following notes provide the information about how to export the user’s schemas from the oracle database. You can also export number of specified users by adding
    Read More

    Ratings : 21 %   

      
  4. Penny

    Increase the Oracle SGA_MAX_SIZE setting in your pfile that you created from your spfile. Then in SQL*Plus start up the database using that pfile as follows.
    Read More

    Ratings : 42 %   

      
  5. Lame Francis

    Configure the system for oracle 11g Release 1 Installation. Now is the time to install oracle 11g R1 in a separate home directory from the oracle 10g.
    Read More

    Ratings : 58 %   

      
  6. Old Oliver

    Changed deprecated parameter on Oracle Database 11g R2 :

    how to set sga_max_size in oracle 11g

    Ratings : 18 %