ORACLE DBA INTERVIEW QUESTIONS (L3)
How good you are at performance tuning? A user has reported that they are facing slowness for a certain sql, what will be your approach to identify the issue? You see that plan hash value of a sql plan has changed and you have already a good plan available in AWR, how will you use that plan? What do you look in AWR report to identify the issue? As a DBA, when and how you reach out to conclusion that a certain issue could be related to network and not database. What is buffer busy wait event? What is log file sync wait event? What other wait event you have observed in your environment which was problematic, can you please describe the situation and remedy that you performed to resolve that issue? What is direct path read event in database, in what scenario this occurs? What is difference between logical and physical reads? What is DB file scattered read and parallel read? If you have to read 100G of data from database using one sql and it has to run 100 times, what method you will prefe