show_all.txt
This file contains the output of the Dbvisit Replicate command 'Show all'. This command shows the values of all of the Dbvisit variables. This information may useful when looking to troubleshooting problems.
Sample file:
*.APPLY_CASE_CONVERT = UPPER *.APPLY_COLUMN_NAMES_MAP = *.APPLY_DATABASE = *.APPLY_DATABASE_DBID = *.APPLY_DATE_FORMAT = AUTO *.APPLY_DBI_ARRAY_BIND = YES *.APPLY_DBI_ARRAY_BIND_ROWS = 500 *.APPLY_DBI_CACHE_STATEMENTS = YES *.APPLY_DBI_PIPELINE = 25 *.APPLY_FILEOUT_FILESYSTEM = FS *.APPLY_FILEOUT_FILE_BATCH_SIZE = 0 *.APPLY_FILEOUT_FILE_CSV_COMMA = *.APPLY_FILEOUT_FILE_CSV_NEWLINE = *.APPLY_FILEOUT_FILE_FORMAT = OFF *.APPLY_FILEOUT_HDFS_NAMENODE = localhost:9000 *.APPLY_FILEOUT_STAGING_DIR = OFF *.APPLY_FILEOUT_TARGET_DIR = OFF *.APPLY_IGNORE_ERROR_CODES = 10655 *.APPLY_LISTEN_INTERFACE = undefined:1 *.APPLY_LOOP_PREVENTION = YES *.APPLY_MSSQL_USER_DB = *.APPLY_PARALLEL_LOAD_DBI = YES *.APPLY_PASSWORD = ***** *.APPLY_PEER = APPLY * *.APPLY_POSTPONE_LAST_LCR = YES *.APPLY_RDBMS = ORACLE *.APPLY_REMOTE_INTERFACE = undefined:1 *.APPLY_SCHEMA = *.APPLY_SCHEMA2 = *.APPLY_SET_TRIGGER_FIRE_ONCE = AUTO *.APPLY_STAGING_DIR = *.APPLY_TRACE = OFF *.APPLY_USER = *.APPLY_USE_PK_ONLY = NO *.CHECKVARS = ON *.DDC_BACKUP_DIR = *.DDC_DATABASE = unitsrc * *.DDC_DATABASE_DBID = 961058349 * *.DDC_ID = 1 *.DDC_NAME = repstage * *.DDC_PASSWORD = ***** *.DDC_SCHEMA = dbvrep * *.DDC_USER = dbvrep * *.DDL_IGNORE_USER = *.DDL_REPLICATE_GRANTS = NO *.DEBUG_LEVEL = 0 *.DELETE_OBSOLETE_PLOGS_AGE = 3d *.DELETE_OBSOLETE_PLOGS_GZIP = YES *.DELETE_OBSOLETE_PLOGS_SIZE_MB = 1024 *.DELETE_OBSOLETE_RLOGS_AGE = 1d *.DELETE_OBSOLETE_RLOGS_GZIP = YES *.DELETE_OBSOLETE_RLOGS_SIZE_MB = 1024 *.DISKSPACE_CHECK_BYTE_LIMIT = 1073741824 *.DISPLAY_ALL_OBJECTS_IN_LIST_PROGRESS = NO *.DISPLAY_TABLE_NAME_IN_LIST_PROGRESS = BOTH *.DML_IGNORE_USER = *.DPUMP_EXCLUDE_STATS = NO *.DROP_SUPPLEMENTAL_LOG_DATA = YES *.FETCHER_DATABASE = *.FETCHER_DATABASE_DBID = *.FETCHER_ENABLED = NO *.FETCHER_LISTEN_INTERFACE = undefined:1 *.FETCHER_PASSWORD = ***** *.FETCHER_PEER = *.FETCHER_REMOTE_INTERFACE = undefined:1 *.FETCHER_SCHEMA = *.FETCHER_THREADS = ALL *.FETCHER_USER = *.FILE_MASK_ALLOW_VARIANTS = NO *.IGNORE_APPLY_DDL_DIFFERENCES = NO *.INSTANTIATE_SCN = NOW *.LICENSE_BAR = ON *.LICENSE_KEY = HKNEU-41J8K-FVN4A-7W3SV-V188Y-I44WV-VC88W * *.LOG_FILE = *.LOG_FILE_COUNT = 2 *.LOG_FILE_DATE_ROTATE = OFF *.LOG_FILE_SIZE = 104857600 *.LOG_FILE_TRACE = *.LOG_OBSOLETE_AGE_PLOG = 0 *.LOG_OBSOLETE_AGE_RLOG = 0 *.LOG_PACKAGE_CSV_MAX_AGE = 10 *.LOG_PACKAGE_TRC_MAX_AGE = 30 *.MAILCFG_AUTH_PASSWD = ***** *.MAILCFG_AUTH_USER = OFF *.MAILCFG_FROM = nobody@example.com *.MAILCFG_PORT = 25 *.MAILCFG_SMTP_SERVER = localhost *.MAILCFG_USE_SSL = NO *.MEMORY_LIMIT_APPLY_MB = 2048 *.MEMORY_LIMIT_MINE_MB = 2048 *.MINE_ARCH_DEST = *.MINE_ARCH_DEST_FORMAT = *.MINE_ASM = *.MINE_CONVERT_TZ_TO_UTC = NO *.MINE_DATABASE = *.MINE_DATABASE_DBID = *.MINE_DISK_USAGE_LIMIT_MB = 0 *.MINE_HEARTBEAT_TIME = 10 *.MINE_LISTEN_INTERFACE = undefined:1 *.MINE_LOOP_PREVENTION = NO *.MINE_PASSWORD = ***** *.MINE_PEER = MINE * *.MINE_PLOG = *.MINE_REMOTE_INTERFACE = undefined:1 *.MINE_SCHEMA = *.MINE_STAGING_DIR = *.MINE_TRACE = OFF *.MINE_TRUNCATE_WITHOUT_DDL = YES *.MINE_UNIQUE_ID = *.MINE_USER = *.NCHARSET = AL16UTF16 *.NETWORK_QUALITY = LAN *.NETWORK_TRAFFIC_KEY = 9a3be17c883cf49ff773495632065e6e * *.NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252 * *.NOTIFY_ALERT_EMAIL = OFF *.NOTIFY_ALL_EMAIL = OFF *.NOTIFY_CONFLICT_CURRENT_PAUSE = YES *.NOTIFY_CONFLICT_CURRENT_RETRY = 2 *.NOTIFY_CONFLICT_THRESHOLD = 100 *.NOTIFY_DAILY_LIST_PROGRESS_TIME24 = 0700 *.NOTIFY_EXCEEDED_CYCLE_NUM = 2 *.NOTIFY_INCIDENT_LIMIT = 10 *.NOTIFY_INTERVAL_BETWEEN_CHECK = 5m *.NOTIFY_ON_DDL = YES *.NOTIFY_PEER_DOWN = ALL *.NOTIFY_PROGRESS_DIFFERENCE_PERC = 10 *.NOTIFY_SCN_DIFFERENCE = 10000 *.NOTIFY_SEND_HEARTBEAT_TIME24 = 0800:1300 *.NOTIFY_SEQUENCE_DIFFERENCE = 10 *.NOTIFY_SUCCESS_EMAIL = OFF *.NOTIFY_TIME_DIFFERENCE = 300 *.OCI_COMMIT_MODE = DEFAULT *.ON_ERROR = SKIP *.ON_WARNING = SKIP *.ORACLE_HOME = *.ORACLE_SID = *.PLOG_TRACE_SQL_FORMAT = NOBIND *.PREPARE_CHECK_APPLY = NO *.PREPARE_CHECK_MINE = YES *.PREPARE_CHECK_MINE_TABLE_TYPE = YES *.PREPARE_SCHEMA_EXCEPTIONS = NONE * *.PROCESS_TYPE = OFF *.PROFILER = OFF *.REDO_READ_METHOD = REDOFIRST *.REPLICATE_INTERNAL_TABLES = YES *.RETRY_TIME = 5 *.SETUP_SCRIPT_PATH = *.SIMPLE_CONFIG = YES *.SNMP_INDEX = 0 *.SNMP_TRAP_COMMUNITY = ***** *.SNMP_TRAP_DESTINATION = OFF *.SOURCE_OS_TIMEZONE = UNKNOWN *.SOURCE_TIMEZONE = +00:00 *.SQL_QUOTE_IDENTIFIERS = AUTO *.SQL_TRACE = NO *.STATUS_BAR = STATUS+LIST * *.STATUS_BAR_ACTIVE_TABLES = AUTO *.STATUS_BEAT_LCR = 10000 *.STATUS_BEAT_TIME = 120 *.STATUS_SHOW_PAST_CONFLICTS = NO *.STATUS_SORT = *.THREAD_PROFILER_DUMP_ON_PLOG_SWITCH = YES *.THREAD_PROFILER_DUMP_ON_PLOG_SWITCH_ENTRIES = 10 *.THREAD_PROFILER_ENABLED = YES *.THREAD_PROFILER_HISTORY = 10 *.TNS_ADMIN = /u01/app/oracle/product/12.1.0.2/db_1/network/admin * *.TWO_TASK = *.WATCHDOG_NOBIND_SQL = NO *.WATCHDOG_TIMEOUT = 30 *._ADD_SUPLOG = AUTO *._APPLY_CHECK_LOOKAHEAD_CONFLICTS = YES *._APPLY_CONNECTION_POOL_DECAY = 10 *._APPLY_CONNECTION_POOL_SIZE = 10 *._APPLY_COUNT_LOOKAHEAD_READ = 100000 *._APPLY_COUNT_LOOKAHEAD_READ_FASTFAIL = 50 *._APPLY_DELETE_OBSOLETE_LOGINFO = YES *._APPLY_DRIVER = AUTO *._APPLY_DUMP_NLS_VER = 0 *._APPLY_ERRORPLOG = NO *._APPLY_FILEOUT_COL_OBJNO = 0 *._APPLY_FILEOUT_REGISTER_FILES = YES *._APPLY_IGNOREALL_LOG = YES *._APPLY_IGNORE_SKIPPED_SAVEPOINTS = YES *._APPLY_INCLUDE_CONFLICT_IN_PROGRESS = YES *._APPLY_LOCK_IN_ONLINE_TRANSFER = NO *._APPLY_LOG_LOOKAHEAD_CONFLICTS = NO *._APPLY_LOOKAHEAD_SPAN_PLOGS = YES *._APPLY_MAX_RETRY_COUNT = 20 *._APPLY_MSSQL_CAST_CHARS_AS_NVARCHAR = YES *._APPLY_MSSQL_CONVERT_DATETIME_TYPE = DATETIME2 *._APPLY_MYSQL_CFG = *._APPLY_MYSQL_WAIT_TIMEOUT = 2147483 *._APPLY_OCI_NAMES_UPDATE_SECONDS = 3 *._APPLY_OCI_PASSTHROUGH_TYPES = YES *._APPLY_OCI_STATS_UPDATE_SECONDS = 1 *._APPLY_PESSIMISTIC_COMMIT = NO *._APPLY_PLOG_CHECK_FATAL = YES *._APPLY_SERIAL_COMMIT = AUTO *._APPLY_STATEMENT_ROLLBACK_WHEN_TOO_MANY = YES *._APPLY_STORE_CURSCN_IN_STATS = 63 *._APPLY_TFO_10205 = AUTO *._APPLY_TFO_11202 = AUTO *._APPLY_TFO_PKG = YES *._APPLY_THREAD_MEM_ACCOUNTING = NO *._APPLY_THREAD_MEM_ACCOUNTING_ON_APPLIER_SHUTDOWN = NO *._APPLY_TRANSLATE_NONSTORAGE_COLUMNS = YES *._APPLY_TRY_UNSTUCK = NO *._ASYNC_LISTENER = YES *._ASYNC_LISTENER_ADD_SPAWN = 2 *._ASYNC_LISTENER_PRESPAWN = 5 *._AUTO_UNPREPARE_RESYNC_COUNTERS = YES *._BT_ON_SCREEN = NO *._CONNECTION_CACHED = YES *._CONSOLE_PAGING_ENABLED = YES *._CREATE_MISSING_DIRECTORIES = YES *._DDC_BACKUP_ENABLED = YES *._DDL_REPLICATE_CTAS = YES *._DDL_REPLICATE_PARTITIONS = NO *._DEBUG_FETCHER_LOOP = 0 *._DEBUG_LIST_CONFLICT = NO *._DEBUG_MINE_REDOLOG_HIST = NO *._DEBUG_MINE_THREAD_MERGING = NO *._DEBUG_PEH_LEAKS = NO *._DEFAULT_HANDLER_DELETE_ERROR = RETRY *._DEFAULT_HANDLER_DELETE_NO_DATA = RETRY *._DEFAULT_HANDLER_DELETE_TOO_MANY = RETRY *._DEFAULT_HANDLER_INSERT_ERROR = RETRY *._DEFAULT_HANDLER_TRANSACTION_ERROR = RETRY *._DEFAULT_HANDLER_UPDATE_ERROR = RETRY *._DEFAULT_HANDLER_UPDATE_NO_DATA = RETRY *._DEFAULT_HANDLER_UPDATE_TOO_MANY = RETRY *._DELETE_CTAS_PLOGS = YES *._DELETE_OBSOLETE_DEBUG = NO *._DELETE_OBSOLETE_PLOGS = YES *._DELETE_OBSOLETE_PLOGS_ENABLED = YES *._DELETE_OBSOLETE_PLOGS_MAX_HIST = 1000 *._DELETE_OBSOLETE_RLOGS = YES *._DELETE_OBSOLETE_RLOGS_ENABLED = YES *._DELETE_OBSOLETE_RLOGS_MAX_HIST = 1000 *._DELETE_OLD_PLOGS_ON_FIRST_STARTUP = NO *._DELETE_OLD_RLOGS_ON_FIRST_STARTUP = NO *._DISABLE_CONSTRAINT_DICT = NO *._DISABLE_DBGPRINTF = NO *._DISABLE_IOT = NO *._DISABLE_IOT_BY_UPGRADE = NO *._DISCONNECTED_APPLY_PLOG_OBSOLETE = NO *._DISKSPACE_CHECK_TIMEOUT = 300 *._DPUMP_MAX_LIST_LENGTH = 100000000 *._DPUMP_SKIP_MODE_ENABLED = YES *._DUMP_OPEN_CURSORS = NO *._ENABLE_5_19_PARSE = YES *._FATAL_ON_C_ERROR = 0 *._FIRST_PLOG = 0 *._FORCE_LD_PATH_ALL = NO *._FORCE_LD_PATH_SYSDBA = NO *._FORCE_NONPERL_SIGHANDLERS = NO *._GZIP_TRC_FILE = YES *._INIT_DICTIONARY_LOAD_AS_OF_SCN = YES *._IS_UNICODE_DB = AUTO *._LAG_STARTUP_WAIT = 300 *._LAG_STATS_ENABLED = YES *._LIST_PREPARE_SHOW_DDL_PLSQL = YES *._LIST_PROGRESS_SHOW_APPLY = YES *._LOAD_REQUEST_CHECK_PRIVILEGES = ONLINE *._LOB_APPLY_OCI = YES *._LOB_ENABLE = YES *._LOG_ERRORS_TO_DATABASE = YES *._LWN_REORDER = AUTO *._MINE_9I_REDO_BLOCK_SIZE = 512 *._MINE_ADD_RBA_TO_PLOG = YES *._MINE_ADD_ROWID_TO_PLOG = NO *._MINE_ADD_TRAILING_NULLCOLS = YES *._MINE_ADD_TRAILING_NULLCOLS_ON_UPDATE_FORCE = NO *._MINE_ASM_USE_OCI = YES *._MINE_AUTO_PREPARE_BY_NAME_STORE = NO *._MINE_AUTO_PREPARE_BY_NAME_USE = NO *._MINE_CHARSET_CONVERSION = KEEP *._MINE_CHARSET_ID = 0 *._MINE_CHECK_ORACHECKSUM = YES *._MINE_CHOOSE_LOGS = 31 *._MINE_DEBUG_TRACE_ON_LOGSWITCH = NO *._MINE_DELETE_OBSOLETE_AUDIT = YES *._MINE_DELETE_OBSOLETE_LOGINFO = YES *._MINE_DETECT_DUPLICATES_IN_ASSEMBLY = NO *._MINE_DETECT_IDLE_THREAD_FETCHER = OFF *._MINE_DIRECTIO_ARCH = NO *._MINE_DIRECTIO_ONLINE = NO *._MINE_EXCLUDE_SYSTEM_COLUMNS_DDL = YES *._MINE_EXCLUDE_SYSTEM_COLUMNS_PREPARE = YES *._MINE_FILEREAD_SETVBUF = IOFBF *._MINE_FIX_INVALID_DATA = 1 *._MINE_FIX_INVALID_DATE_NEW_VALUE = *._MINE_FORCE_LOGSWITCH_IDLE_TIME = 180 *._MINE_FORCE_SCN_UPDATE_IDLE_COUNT = 0 *._MINE_IGNORE_RECURSIVE_DDL = YES *._MINE_INFER_LOB_LEN = YES *._MINE_KEY_IMAGE_ON_PK_UPDATE = YES *._MINE_KEY_IMAGE_PREFER_SUPLOG = NO *._MINE_KEY_IMAGE_WITH_ALL_LOGGING = YES *._MINE_LAST_OBSOLETE_SUPPRESS_QUERY_THRESHHOLD = 3 *._MINE_LAST_OBSOLETE_SUPPRESS_TIMEOUT = 300 *._MINE_LCRLIST_SPILL_BLOCK_SIZE = 500000 *._MINE_LCRLIST_SPILL_ENABLED = YES *._MINE_LCRLIST_SPILL_KEEP_IN_MEMORY = 50000 *._MINE_LCRLIST_SPILL_SIZE_TO_START = 1000000 *._MINE_LOAD_COMMIT_BLOCK_SIZE = 10000 *._MINE_LOAD_PARALLEL_APPLY = 10 *._MINE_LOBCHARSET_CONVERSION = KEEP *._MINE_LOB_ASSEMBLY_SIZE = 1000000 *._MINE_LOST_WRITE_DETECT = 0 *._MINE_MAX_GET_REDO_LOOP_COUNT = 0 *._MINE_NCHARSET_CONVERSION = KEEP *._MINE_PESSIMISTIC_COMMIT = NO *._MINE_PLOG_SEND_ONLINE_PLOG = YES *._MINE_PRINT_OPEN_TRANSACTIONS = NO *._MINE_RAC = AUTO *._MINE_RAC_SKIP_THREADS = OFF *._MINE_RBA_UPDATE_MIN_INTERVAL = 1 *._MINE_RECURSIVE_DML_IN_DDL = YES *._MINE_REPORT_INVALID_DATA = 1 *._MINE_RETIRE_OBSOLETE_TRANSACTIONS = NO *._MINE_SKIP_UNNEEDED_CHANGES = YES *._MINE_THREADED_PLOG_WRITE = YES *._MINE_THREADED_REDO_READ = YES *._MINE_TRACE_DICT_SQL = NO *._MINE_TRACE_FORMAT_51_KTUBL_PARENTHESIS = AUTO *._MINE_TRACE_FORMAT_LWN_RBA = YES *._MINE_TRACE_FORMAT_ORACLE_VERSION = AUTO *._MINE_TRACE_FORMAT_RBA_HEADER = AUTO *._MINE_TRACE_LOB_INFO = YES *._MINE_TRACE_OVERFLOW_SEGMENT = YES *._MINE_UNPACK_ARCH_TMP_FILEMASK = *._MINE_UPDATE_PLOG_MAP_INCOMPLETE = YES *._MINE_UPDATE_RBA_ON_VOID = NO *._MINE_UPDATE_TABLIST_ON_SWITCH_ONLY = NO *._MINE_WAIT_FOR_DATA_SECONDS = 2 *._MINE_WAIT_FOR_MISSING_ARCHLOGS_SECONDS = 10 *._MINE_WAIT_FOR_MISSING_ARCHLOGS_SECONDS_ON_SUCCESS = 60 *._MINE_WAIT_ON_INCOMPLETE_ARCHLOG = 30 *._MINE_WRONG_ORDER_FATAL = NO *._MSSQL_BEGIN_TRAN_AS_INSERT = NO *._NETWORK_CHUNKSIZE = 10000000 * *._NETWORK_COMPRESSION = NONE *._NETWORK_FASTTRACK_FILESEND = YES *._NETWORK_KEEPALIVE = YES *._NETWORK_TRAFFIC_DEBUG = 0 *._NETWORK_TRAFFIC_KEY_ALLOWED = 1 *._NETWORK_TRAFFIC_KEY_ALLOWED_PLOG = 01 * *._NETWORK_TRAFFIC_KEY_USE = 1 *._NETWORK_TRAFFIC_KEY_USE_PLOG = 0 * *._NOTIFY_ENABLE = YES *._NOTIFY_QUEUE_TIMEOUT = 180 *._NOTIFY_SMTP_DEBUG = 0 *._NOTIFY_VERBOSE_DEBUG = 0 *._PACKAGE_ON_CONFLICT = NO *._PERLDB_RETRY_COUNT = 3 *._PERLDB_RETRY_SLEEP = 1 *._PERL_CARP = 0 *._PLOG_DICT_CACHING = YES *._PLOG_DICT_CACHING_APPLY_GC = AUTO *._PLOG_DICT_JSON = NO *._PLSQL_PROGRESS_LIMIT = 10 *._PREPARE_SUPLOG_TYPE = PK *._PREPARE_WAITS_FOR_SCN_FLIP = AUTO *._QUERYMODE_PARSE_SQL = NO *._QUEUE_SPIN_WORKAROUND = NO *._RAC_BYPASS_IDLE_THREADS = YES *._RAC_BYPASS_PAST_SECONDS = 10 *._RATE_STATS_ENABLED = YES *._RATE_STATS_ROLLUP_DAYS = 7 *._RD_TRACE = NO *._REDO_SWITCH_REREAD_ARCH = NO *._SET_APPLY_PKG_ALWAYS = NO *._SET_APPLY_PKG_AUDIT = YES *._SET_APPLY_PKG_CONFLICT = YES *._SHORTEN_CDC_COLNAMES = YES *._SPARE_N1 = 0 *._SPARE_N2 = 0 *._SPARE_S1 = *._SPARE_S2 = *._SPARE_YN1 = YES *._SPARE_YN2 = YES *._SUBPROFILER = NO *._TCP_CONNECT_TIMEOUT = 60 *._TCP_RECEIVE_TIMEOUT = 60 *._TCP_SEND_TIMEOUT = 60 *._THREADED_OCI = AUTO *._THREAD_PROFILER_ENABLED_STOPSTART = NO *._TRACE_ROWID_FILENAME = OFF *._WIZARD_ALLOW_MULTIPLE_REPLICATIONS = YES *._WIZARD_WINDOWS_PAUSE_ALLBAT = YES *._WIZARD_WINDOWS_USE_SERVICES = YES *.__AHU_EDITION = NO *.__CDC = *.__FILTER_CONDS = *.__INSTANTIATION_TYPE = *.__INSTANTIATION_TYPE_KAHITI = *.__INSTANTIATION_TYPE_LOAD = *.__INSTANTIATION_TYPE_NONORA = *.__INTEGER = *.__PLATFORM = *.__PREPARE_TYPE = *.__RDBMS = Oracle *.__RDBMS_AND_FILES = Oracle *.__YN = NO