What is the cause for the change?

You enabled PL/SQL tracing in a user session using the following command:
SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ALL_CALLS);
View Exhibit1 to examine the output. After some time, the query produces a different result as
shown in Exhibit2.

What is the cause for the change?

You enabled PL/SQL tracing in a user session using the following command:
SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ALL_CALLS);
View Exhibit1 to examine the output. After some time, the query produces a different result as
shown in Exhibit2.

What is the cause for the change?

A.
The FOO procedure has been executed more than once.

B.
The PLSQL_DEBUG parameter is set to FALSE for the user session.

C.
The FOO procedure has been compiled with the DEBUG option, and executed.

D.
Schema level statistics have been gathered by the database administrator (DBA).



Leave a Reply 1

Your email address will not be published. Required fields are marked *