Q3. A database is slow after restart. What Oracle memory component would you check first?

✅ Answer

Check the SGA components, especially:

• Shared Pool
• Buffer Cache

Reason:

After restart, caches are empty → queries take longer.

DBA Check:

SHOW SGA;

SELECT * FROM v$sgastat;

Fix:

Increase shared pool or buffer cache if reloads are high.