This request logs statistics usage data for all DML requests executed by user_1:
BEGIN QUERY LOGGING WITH STATSUSAGE ON user_1;
This request logs statistics usage data and detailed query plan information for all DML and selected DDL requests executed by user user_1:
BEGIN QUERY LOGGING WITH XMLPLAN, STATSUSAGE ON user_1;