SQL Performance (MOSC)

MOSC Banner

Program Running slow

edited Aug 26, 2016 5:00AM in SQL Performance (MOSC) 9 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center