How does one allocate more OS memory to the SGA?

Login as Oracle, and then:

  • $ORACLEINS - choose option RECONFIGURE EXISTING PRODUCTS
  • Prompt for default directory - accept or specify new directory
  • Prompt for the location of the SAVE SET - accept or specify new directory
  • Display "Doing some setup" will appear - when finished press ENTER
  • Choose Software Installation and Upgrade Menu
  • Choose Build Configuration Options
  • Choose RDBMS Option
  • Modify the value for SGA PAD
  • When back at prompt choose REBUILD
  • Exit (E option)
  • Choose option Build Selected Products
  • When relinking is finished exit out of the menu

Contributed by: