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