Path Infotech Interview Questions, Process, and Tips

SGA is a shared memory area that stores data and control information for Oracle instance. Shared pool is a part of SGA that stores SQL statements and data dictionary cache.

• SGA is a fixed size memory area allocated at instance startup

• SGA contains database buffer cache, redo log buffer, shared pool, etc.

• Shared pool stores frequently used SQL statements and data dictionary cache

• Shared pool can be resized dynamically using

Buffer cache stores frequently accessed data in memory. Old archive logs can be deleted using RMAN commands.

• Buffer cache is a portion of memory used to store frequently accessed data to reduce disk I/O

• Oracle automatically manages the buffer cache size based on system resources and workload

• To delete old archive logs in RMAN, use the DELETE ARCHIVELOG command with options like 'ALL' or 'COMPLETED BEFORE'

• Example: DELETE A...read more