- To view active session details, execute the following procedure.
EXECUTE INUSER.IN_DB_UTIL.IN_CONTEXT_PRINT
- To view a report on uptime progress, execute the following procedure.
EXECUTE INUSER.IN_DB_UPGRADE.UPTIME_GET_STATUS
- To view a report on downtime progress, execute the following procedure.
EXECUTE INUSER.IN_DB_UPGRADE.DOWNTIME_GET_STATUS
- To view a report on synchronization events, execute the following procedure.
EXECUTE IN_DB_UPGRADE.SYNC_GET_STATUS('IN_DOC')
- To view the current state of synchronization, execute the following query. This table is queried
by the SYNC_GET_STATUS procedure.
SELECT * FROM INUSER.SYNC_STATE_DOC;
- To view the history of synchronization activity, execute the following query. This table is
queried by the SYNC_GET_STATUS procedure.
SELECT * FROM INUSER.SYNC_HIST_DOC ORDER BY SYNC_DATETIME;
- To view the history of synchronization errors, execute the following query. This table is
queried by the SYNC_GET_STATUS procedure.
SELECT * FROM INUSER.SYNC_ERROR_DOC ORDER BY ACTION_DATETIME;
- To view the control table for synchronization default values, execute the following
query.
SELECT * FROM INUSER.IN_DB_UPGRADE_CONTROL_SYNC;
- To view the control table for upgrade default values, execute the following
query.
SELECT * FROM INUSER.IN_DB_UPGRADE_CONTROL_UPGRADE;
- The INUSER.IN_DB_UTIL_LOG table contains a log of any exceptions that occur during the execution of the IN_DB_UTIL and IN_DB_UPGRADE packages. It also contains a log of calls to the IN_SESSION_SET, and IN_SESSION_CLEAR, and IN_SESSION_CLEAR_ALL stored procedures.
- To view the contents of the IN_DB_UTIL_LOG table execute the following query.
SELECT * FROM INUSER.IN_DB_UTIL_LOG ORDER BY LOG_TIME;
- For more in-depth troubleshooting see the Debugging section below to enable the debug option.