Oracle Apps DBA interview questions and Core DBA interview questions
Imp Questions: Most of them are open questions that I can think of , they have multiple correct answers, we need to choose the best one we can explain,this questions are sourced from multiple interviews are attended and multiple blogs,If anyone needs credit for any information,I will email ⦁ What if client reports db is slow, what will you do ⦁ what if client reports a conc prog is runnning slow without any changes made 1. check for locks and check for that perticular table locks used by the concurrent program 2. check the concurrent manager log and out files and delete them if occupying lot of space to check report based locks:- you know that conc req id.. by using that select * from v$session where process in(select os_process_id from fnd_concurrent_requests where request_id='<Req Id>') from this u will get SID take that sid and find object_id's from below command select * from v$locked_objects where session_id='SID' no take all the ...