Topic : PGA

What happens when a user process fails?


  • PMON performs process recovery.
  • SMON performs ICR
  • SMON frees resources held by user process.
  • Oracle Updates a controlfile.

Answer :

PMON performs process recovery.

Show Answer Discuss

What is a Program Global Area[PGA]?


Answer :

PGA is a memory buffer that contains data and control informations for a server process.

Show Answer Discuss