Topic : System Global Area(SGA)

Which of the following does not affect the size of the SGA


  • Database buffer
  • Redo log buffer
  • Stored procedure
  • Shared pool

Answer :

Stored procedure

Show Answer Discuss

Which SGA memory structure cannot be resized dynamically after instance startup?


  • Database Buffer Cache
  • Java Pool
  • Large pool
  • Log buffer
  • Shared Pool

Answer :

Log buffer

Show Answer Discuss