Identify the two types of PL/SQL programs for which you consider setting the compilation method to native mode.
(Choose two.)
A.
PL/SQL programs that are still in the debugging phase of development
B.
PL/SQL programs that have computation-intensive procedural operations
C.
A PL/SQL program, which is called with the same parameters by multiple sessions
D.
PL/SQL programs that spend most of their execution time in executing SQL statements
i don’t think that both answers are true
C is Incorrect Answer.
D Is correct :because Native method spend most of time in Running and execution of SQL.
–Ref from Author Books: Matthew Morries.
I dont think so:
“Because native compilation applies only to PL/SQL statements, a PL/SQL unit that only calls SQL statements might not run faster when natively compiled, but it will run at least as fast as the corresponding interpreted code.”
https://docs.oracle.com/html/B28370_05/tuning.htm#BABIBCBE
B, C
http://www.oracle.com/technetwork/articles/sql/11g-plsql-091775.html
A wrong because native compilation is not useful in development stage of application
D SQL makes run times higher when native comp is used
B, C
whoah this blog is magnificent i love reading your articles. Keep up the good work! You know, many people are searching around for this information, you can aid them greatly.
http://highprofilecallgirlsindelhi.in/rohinicallgirls.html