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.

No comments :

Post a Comment