Oracle Trouble Shooting Interview Question

1. What are dynamic performance views?
 
  • Dynamic performance views are also called V$ views. These views provided information about the sessions.
  • Any Oracle user can get information from dynamic performance views if the user has the select any table privilege. This privilege is generally granted through the SELECT_CATALOG_ROLE etc.
 
Your Name Your Email-ID
Your Answer
2. What is the STATSPACK tool?
 
  • The STATSPACK tool is an ORACLE supplied tool to monitor database performance.
  • It can be used to diagnose instance wide problems both proactively and reactively.
 
Your Name Your Email-ID
Your Answer
3. What is db file sequential read wait event?
  The db file sequential read wait event performs single block read operations against indexes, tables, control files, rollback segments and data file headers. It has three parameters: file#, firstblock# and block count.
 
Your Name Your Email-ID
Your Answer
4. Explain wait events?
 
  • Wait event occurs when a user process is kept waiting because of some problem, such as an I/O bottleneck or a busy CPU.
  • The information about wait event is available in the V$SYSTEM_WAIT and V$SESSION_WAIT dynamic performance views.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 1 of 10