Oracle 12c DBA Interview Questions and Answers - 1

Question: 1

What is OERR?

OERR is a utility provided on the UNIX platform.

It can be used to retrieve more information about an error message.

This utility cannot work on Windows because it needs awk command to function; however, some workgrounds are available to use this utility in Windows.

Question: 2

Explain the iostat, vmstat, and netstat commands?

The iostat command reports on terminal, disk and tape I/O activity;

The vmstat command reports on virtual memory statistics for processes, disk, tape and CPU activity; the netstat commands reports on the contents of network data structures.

Question: 3

Give the command to display space usage on the UNIX system.

The df –lk command

Question: 4

What is dynamic Intimate shared Memory (DISM)?

DISM in Solaris is similar to huge pages in Linux. It provides larger chunks of memory for System Global Area (SGA) to avoid paging.

It is very helpful to use DISM for SGA to improve the performance of Oracle database.

DISM can support up to 4 MB page size.

Question: 5

Give the command to list the files in the UNIX directory to list hidden files?

The ls –ltra