SQL   enables logging of the following:

• START DATABASE statements
• STOP DATABASE statements
• STOP SERVER statements
• Statement preparation and execution
• EXECUTE IMMEDIATE statement
• Option settings
• COMMIT statements
• ROLLBACK statements
• PREPARE TO COMMIT operations
• Connects and disconnects
• Beginnings of transactions
• DROP STATEMENT statements
• Cursor explanations
• Cursor open, close, and resume
• Errors

PLAN   enables logging of execution plans (short form). Execution plans for procedures are also recorded if logging of procedures (PROCEDURES) is enabled.

HOSTVARS   enables logging of host variable values. If you specify HOSTVARS, the information listed for SQL is also logged.

PROCEDURES   enables logging of statements executed from within procedures and user-defined functions.

TRIGGERS   enables logging of statements executed from within triggers.

OTHER   enables logging of additional request types not included by SQL, such as FETCH and PREFETCH. However, if you specify OTHER but do not specify SQL, it is the equivalent of specifying SQL+OTHER. Including OTHER can cause the log file to grow rapidly and could negatively affect server performance.

BLOCKS   enables logging of details showing when a connection is blocked and unblocked on another connection.

REPLACE   at the start of logging, the existing request log is replaced with a new (empty) one of the same name. Otherwise, the existing request log is opened and new entries are appended to the end of the file.

ALL   logs all supported information. This setting is equivalent to specifying SQL+PLAN+HOSTVARS+PROCEDURES+TRIGGERS+OTHER+BLOCKS. This setting can cause the log file to grow rapidly and could negatively affect server performance.

NO or NONE   turns off logging to the request log.