Monday, April 10, 2017

Fidelity - Performance Tuning Interview Questions


What is AWR, ADDM, ASH
What is the difference between AWR, ADDM
Tell a scenaio when u have used AWR
What are the different wait events
What db sequential file read, db scattered read events, and its difference.
What is a cursor.
what are its attributes
what is type , rowtype
what is bulk collect
how do u identify the limit set to bulk collect
What is the difference between btree and bitmap index.
There is an sql statement that ran fine in  the morining, but in the evening its taking long time. How do u identify the issue and tune the statement.
How do u find the difference in SQL plans of the same statement if there is a change in the SQL plan.

1 comment :

  1. Nice post. I learn something new and challenging on sites I stumbleupon everyday. It’s always helpful to read through articles from other writers and practice a little something from their websites.

    Please Read More: Download Ebook: Ultimate Guide To Job Interview Questions Answers:

    Best rgs

    ReplyDelete