August 7, 2013

Oracle Apps DBA RDBMS Interview Questions/FAQs Part2

Oracle Apps DBA EBS (E-Business Suite)
RDBMS Interview Questions/FAQs Part2

21. How to enable trace for other session?
Ans : exec sys.dbms_system.set_sql_trace_in_session(sid,serial#,true/false)
To enable trace for sql session
SQL> exec sys.dbms_system.set_sql_trace_in_session(66,2321,true);

To disable trace
SQL> exec sys.dbms_system.set_sql_trace_in_session(66,2321,false);

22.What is the location of init.ora ?

23. What is that trace files contains and the utility used to read them?
Ans : Trace file contains the detail diagnostics of a sql statement like explain plan, physical reads, logical reads, buffer gets etc. TKPROF utility is used to convert trace file into readable format.

24. What is the syntax for tkprof?
Ans: tkprof explain=apps/ sys=no

25. What is a view and how do you recreate a view which becomes invalid when you recreate a patch?
• View is used for accessing a particular portion of a table.
• A view is also called as virtual table.
• For recreating the view you can search for the view name in the SQL directory.
• We can recreate the views running scripts located in the Product top/patch/115/sql directory.
• Most views are recreated using sql script.

Related Articles:  Oracle DBA Interview Questions/FAQs  Oracle RAC Interview Questions  Oracle Exadata Interview Questions