myfile
**************************************************** File Name : a.sql **************************************************** create or replace view ats_dba_waiters as select /*+ all_rows */ w.session_id waiting_session, h.session_id holding_session, w.lock_type, h.mode_held, w.mode_requested, w.lock_id1, w.lock_id2 from ats_dba_lock w, ats_dba_lock h where h.blocking_others = ‘Blocking’ and h.mode_held != ‘None’ and h.mode_held != ‘Null’ and w.mode_requested != ‘None’ and w.lock_type = h.lock_type and w.lock_id1 = h.lock_id1 and…