Saturday, March 12, 2022

Trace flag (events) set during the Oracle impdp execution

 During the data pump impdp execution, the import session has been set with following events. It can be observed by impdp with sqlfile parameter.

ALTER SESSION SET EVENTS '10150 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10904 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '25475 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10407 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10851 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '22830 TRACE NAME CONTEXT FOREVER, LEVEL 192 ';

Below are the detail explanations:

ALTER SESSION SET EVENTS '10150 TRACE NAME CONTEXT FOREVER, LEVEL 1';

10150, 00000, "import exceptions"
// *Document: NO
// *Cause:
// *Action:   This should never be set by users.  It is used by import to
//            allow certain commands to succeed, when for normal users they
//            would fail.  An example is to allow grants on invalid views.


ALTER SESSION SET EVENTS '10904 TRACE NAME CONTEXT FOREVER, LEVEL 1';

10904, 00000, "Allow locally managed tablespaces to have user allocation"
// *Cause: N/A
// *Action: THIS IS NOT A USER ERROR NUMBER/MESSAGE.  THIS DOES NOT NEED TO BE
//          TRANSLATED OR DOCUMENTED. IT IS USED ONLY BY IMPORT CODE.
ALTER SESSION SET EVENTS '25475 TRACE NAME CONTEXT FOREVER, LEVEL 1';

// 25475 is reserved for debug mode
25476, 00000, "use pre-5523578 behaviour when looking up enabled roles"
// *Cause:  N/A
// *Action: Derive the enabled roles under the rules engine using the old
//          method that existed before the fix to bug 5523578.
/
ALTER SESSION SET EVENTS '10407 TRACE NAME CONTEXT FOREVER, LEVEL 1';

10407, 00000, "enable datetime TIME datatype creation"
// *Cause:
// *Action:  set this event to enable datetime datatype creation
// *Comment: This event is set when the user wants to create
//           a datetime datatype column.  The compatible=8.1.0.0.0 parameter
//           must also be set.
ALTER SESSION SET EVENTS '10851 TRACE NAME CONTEXT FOREVER, LEVEL 1';

10851, 00000, "Allow Drop command to drop queue tables"
// *Document: NO
// *Cause: re-enable SQL Drop DDL for queue tables.
// *Action: last resort to drop queue table if all other options fail. The
//          user have to manually cleanup AQ's metadata after this operation.

ALTER SESSION SET EVENTS '22830 TRACE NAME CONTEXT FOREVER, LEVEL 192 ';

22830, 00000, "Event enabling VARRAYs columns to be created as OCTs"
// *Document: NO
// *Cause:    N/A
// *Action:   Enables all VARRAY columns to be created as Ordered
//            Collection in Tables (ie with table storage)

No comments:

Post a Comment