This procedure allows you to request XPLAIN style processing
of runtime statistics. When XPLAIN style is used, the runtime
statistics are written to the SYSXPLAIN_* database tables, so
that you can analyze the statistics by running queries against
the tables.
See "Working with RunTimeStatistics" in the
Turn xplain style on by calling this procedure with a non-empty argument. Turn xplain style off by calling the procedure with an empty argument.
The argument that you provide must be a legal schema name, and
you should use this argument to indicate the schema in which
runtime statistics should be captured. If the schema that you
specify does not already exist, it will be automatically created.
If the XPLAIN tables do not already exist in this schema, they
will be automatically created. Runtime statistics information about
statements executed in this session will then be captured into
these tables, until runtime statistics capturing is halted by either
calling
If authentication and SQL authorization are both enabled, only the
To cause