CREATE TEMPORARY TRACE EVENT statement

CREATE [ OR REPLACE ] TEMPORARY TRACE EVENT trace-event-name 
[ WITH SEVERITY {
 0-255
 | ALWAYS
 | CRITICAL
 | ERROR
 | WARNING
 | INFORMATION
 | DEBUG } ]
[ field-name field-type [ , ... ] ]

trace-event-name Specify a user trace event name. User trace event names cannot start with the prefix SYS_. System trace event names cannot be specified.
OR REPLACE clause Create a new trace event, or replace an existing trace event with the same name.

WITH SEVERITY clause If the severity level is not specified, the default severity level (DEBUG) is used. User trace events are owned by the database that the user was connected to when the trace event was created. The supported severity values are:

Level	Severity value range
ALWAYS	0
CRITICAL	1-50
ERROR	51-100
WARNING	101-150
INFORMATION	151-200
DEBUG	201-255

field-name The field that gathers information of a specific type from the user trace event. The field must be a valid identifier.
field-type You can use any data type that is supported for a column except an array type.

A trace event is stored in memory and is dropped when the database server stops if it has not been dropped explicitly.

You must have the MANAGE ANY TRACE SESSION system privilege.

None

SQL/2008 Vendor extension.

The following statement creates a user trace event:

CREATE TEMPORARY TRACE EVENT my_event( id INTEGER, information LONG VARCHAR );

CREATE TEMPORARY TRACE EVENT statement

Syntax

Parameters

Remarks

System privileges

Side effects

See also

Standards and compatibility

Example