Program Running slow
Hi Team,
I have just one question which I wanted to post here in this community.
The question is that I have attended 3 technical interviews till now and one most common question being asked by the interviewer is that :
one application job(or concurrent request) is running for longer time then expected. What are the things you will check as a DBA.
And I get generally stuck by saying that ""as a DBA I'll enable trace then will generate tkprof, will check on which event it's waiting for more time and then will investigate accordingly investigate"", but the interviewer doesn't get much convinced with this answer and says wait events are fine, and there are no locks too from DB end. What else you'll check