Oracle Apps DBA EBS (E-Business Suite)
RDBMS Interview Questions/FAQs Part2
RDBMS Interview Questions/FAQs Part2
21. How to enable trace for other session?
Answer :
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 ?
Answer :
$RDBMS_ORACLE_HOME/dbs
23. What is that trace files contains and the utility used to read them?
Answer :
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?
Answer :
• 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.
26. You need to run autoconfig on Apps and DB tiers. Which tier will you run first?
27. Can you run auto config in DB tier while the database is up? Why?
28. What is a customization? How do you know there are customizations in your system?
29. How to preserve customizations?
30. Do you need to bring down your database while running auto config? Why or why not?
31. How to find Database version?
Answer :
SQL> select * from v$version;
32. How to find opatch Version?
Answer :
opatch is utility to apply database patch, to find opatch version execute ”$ORACLE_HOME/OPatch/opatch version”
You can check OPatch -lsinventory
Good blog you have here.. It?s difficult to find
ReplyDeletehigh-quality writing like yours nowadays. I seriously appreciate people like you!
Take care!!