BEGIN QUERY LOGGING
[ WITH with_item [,...] ]
[ MODE = m ]
[ LIMIT limit_item [ AND limit_item ] ]
ON on_items [;]
Syntax Elements
-
with_item
-
{ ALL |
EXPLAIN |
LOCK = n |
NONE |
[ NO COLUMNS ] OBJECTS |
PARAMINFO |
FEATUREINFO |
SQL |
[ DETAILED ] STATSUSAGE |
STEPINFO |
USECOUNT |
UTILITYINFO |
[ VERBOSE ] XMLPLAN
}
-
limit_item
-
{ SQLTEXT [ = n] |
{ SUMMARY = n1, n2, n3 | THRESHOLD [ = n ] }
[ CPUTIME | CPUTIMENORM | ELAPSEDSEC | ELAPSEDTIME | IOCOUNT ]
}
-
on_items
-
{ { ALL | user_name } [ ACCOUNT = { 'account_string' | ('account_string' [,...]) } ] |
{ user_name | database_name }[,...] |
APPLNAME = { 'application_name' | ('application_name' [,...])
}
}