Not much today, this is just a place holder as we evaluate conflict resolution schemes for ATG and Golden Gate. Out of the box, it uses an application based sequence generator (DAS_ID_GENERATOR table). You can (and are encouraged to) prepend a string, such as the data center location to the application provided ID. The application fetches a set iof ID’s and incrementas the counter in DAS_ID_GENERATOR. I don’t know if it does a “SELECT FOR UPDATE” when it fetches the next range. If it doesn’t, and the fetch is done at the same time, it could get the same range on two different applciation servers.
RAC contention could be an issue (monotonically increasing sequences can be problematic in RAC). Since we will prepend the data center to the string, we shouldn’t have many conflicts, if any.
ATG primary key data types…
select count(*),dc.table_name,data_type
from dba_constraints dc
inner join dba_cons_columns dcc on dc.constraint_name = dcc.constraint_name
and dc.owner = dcc.owner
inner join dba_tab_columns dtc on dcc.column_name = dtc.column_name
and dcc.table_name = dtc.table_name
and dcc.owner = dtc.owner
where dc.owner like 'ATG%'
and constraint_type = 'P'
and dc.table_name not like 'BIN$%'
group by dc.table_name,data_type;