This example uses the same table and COLLECT STATISTICS request as Example: Logging an XML Plan with VERBOSE EXPLAIN and DETAILED STATSUSAGE Collections.
Log Object, SQL, Step Details, Verbose Explain, Statistics Details, and Statistics Usage information on user_1:
BEGIN QUERY LOGGING WITH VERBOSE XMLPLAN, DETAILED STATSUSAGE ON user_1;
Update the employee table, setting the salary for employee John to $40,000:
UPDATE employee SET SALARY=40000 WHERE emp_name='John';
This request reports Verbose XMLPLAN, Statistics Details, and Statistics Usage rules as TRUE:
SHOW QUERY LOGGING ON user_1;
Terminate logging on user_1:
END QUERY LOGGING ON user_1;