Controls whether debugging information for remote data access appears in the database server messages window.

Allowed values

0, 7

Default

0

Scope

Can be set for an individual connection or for the PUBLIC group.

Remarks

This option controls whether information about how queries are executed on a remote database appears in the database server messages window when using remote data access. Set this option to 7 to see debugging information in the database server messages window. When this option is set to 0 (the default), debugging information for remote data access does not appear in the database server messages window.

Once you have turned on remote tracing, the tracing information appears in the database server messages window. You can log this output to a file by specifying the -o server option when you start the database server. See -o server option.