My Oracle Support Banner

BUG : 12689047 Excessive time required for create Active/Standby pair or CREATE REPLICATION (Doc ID 1362746.1)

Last updated on JUNE 05, 2019

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1.8.0 and later
Information in this document applies to any platform.

Symptoms

Excessive time is required for creating an Active/Standby pair or a CREATE REPLICATION when a large number of tables is involved.

Example:
create table TABLENAME (
C0 FLOAT(126) NOT NULL,
C1 FLOAT(126),
C2 FLOAT(126),
C3 FLOAT(126),
C4 FLOAT(126),
C5 FLOAT(126),
C6 FLOAT(126),
C7 FLOAT(126),
C8 FLOAT(126),
C9 FLOAT(126),
C10 FLOAT(126),
C11 FLOAT(126),
C12 FLOAT(126),
C13 FLOAT(126),
C14 FLOAT(126),
C15 FLOAT(126),
C16 FLOAT(126),
C17 FLOAT(126),
C18 FLOAT(126),
C19 FLOAT(126),
C20 FLOAT(126),
C21 FLOAT(126),
C22 FLOAT(126),
C23 FLOAT(126),
C24 FLOAT(126),
C25 FLOAT(126),
C26 FLOAT(126),
C27 FLOAT(126),
C28 FLOAT(126),
C29 FLOAT(126),
C30 FLOAT(126),
C31 FLOAT(126),
C32 FLOAT(126),
C33 FLOAT(126),
C34 FLOAT(126),
C35 FLOAT(126),
C36 FLOAT(126));

create unique index <USERNAME>.I_0000 on TABLENAME (C0);

... repeat create table above 5180 times...


CREATE ACTIVE STANDBY PAIR <DataStoreName> on <"host">, <DataStoreName>on <"host"> RETURN TWOSAFE;

Execution time (SQLExecute) = 609.465027 seconds.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.