Oracle Database Administration from Zero to Hero - Practice - Managing Database Memory (Part 1 of 2)

The video tutorial covers memory management in Oracle databases, focusing on Automatic Memory Management (AMM) and Automatic Shared Memory Management (ASMM) on SRB one. It guides through implementing AMM, setting memory parameters, and handling errors. The tutorial also explains configuring shared memory, using memory advisors, and monitoring memory usage. Finally, it discusses restoring the VM and verifying memory settings.

What are the two memory management techniques discussed in the video?

• AMM and ASMM

• Cache and Buffer

• RAM and ROM

• SGA and PGA

What is the minimum value required for the MEMORY_TARGET parameter?

• 1600 MB

• 6400 MB

• 3200 MB

• 800 MB

Why was there an error when starting the database after changing the memory settings?

• The database was not properly shut down.

• The VM was not restarted.

• The SP file was corrupted.

• The shared memory was less than the memory target.

What tool is used to monitor memory component sizes in the database?

• Oracle VirtualBox Manager

• SQL Developer

• V$ memory dynamic components view

• Task Manager

What is the purpose of the automatic memory advisor?

• To increase the CPU speed

• To optimize memory target settings

• To backup the database

• To manage user accounts

What happens to the memory settings after restoring the VM from a snapshot?

• They are reset to default values.

• They are doubled.

• They remain unchanged.

• They are set back to the snapshot values.

Which parameter values are saved into the SP file header?

• CPU and Disk usage

• SGA and PGA target

• User permissions

• Network settings