REPLACE 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' [,...])
}
}