Explain iostat, vmstat and netstat.

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

100. Explain iostat, vmstat and netstat.

Iostat reports on terminal, disk and tape I/O activity. Vmstat reports on virtual memory statistics for processes, disk, tape and CPU activity. Netstat reports on the contents of network data structures.

(Continued on next question...)

Other Job Interview Questions

• What is a DBA?
• How can you gather statistics on a table?
• You are using hot backup without being in archivelog mode, can you recover in the event of a failure? Why or why not?
• What is the use of Control File?
• How do you add a data file to a tablespace?
• What does the term panel refer to with regarda to pages?
• What is a Schema?
• How is link tool operation different bet. reports 2 & 2.5?
• Find out nth highest salary from emp table
• To execute row from being displayed that still use column in the row which property can be used?
• More...