This content has been marked as final. Show 4 replies
You could use memory advisors1 person found this helpful
i dont have any db console installed.this is required while installation.
You can set AMM and database automatically select the correct value for SGA and PGA:
Specify Configuration Options: Provide the following configuration information, and click Next: Memory: The Enable Automatic Memory Management option is selected by default. This option enables the database to automatically distribute memory between SGA and PGA. If you deselect this option, then the SGA and PGA must be sized manually.
In addition to AMM, you should consider whether it is shared server or dedicated server.1 person found this helpful
the UGA is in the PGA in dedicated server
the UGA is in the SGA (large pool if configured, shared pool otherwise) in shared server
but the UGA is the UGA - your user global area, your session specific information, that data that must be available for the life of your session (like plsql variable values, cursor state information, etc)