Architectural changes in Seed Data Tables with AD/TXK Delta 8

 Architectural changes in Seed Data Tables with AD/TXK Delta 8

What are the architectural changes in Seed Data Tables introduced with 

AD/TXK Delta 8

1) Starting with AD & TXK Delta 8, a new feature "Enhanced Seed Data Management" is introduced that greatly increases the speed and efficiency with which seed data is synchronized as part of an online patching cycle.

2) This is the Dual Row Set Seed Data Synchronization model.

3) With this change, the ZD_EDITION_NAME column for the Seed Data Tables will replaced by "SET1" or "SET2"

4) No additional storage is required, and seed data tables are upgraded on demand to the new architecture.

5) How are the SET1 & SET 2 created:

a) When a Seed Data Table is prepared during the apply phase of adop, SET1 is created and "V_YYYYMMDD_HHMM" is replaced.

b) When the same Seed Table is prepared in the next apply phase, SET2 is created.

6) Once you see SET1 & SET2 for Seed Tables, it indicates that the table is now fully migrated to dual row set model and only the delta (difference in rows) between SET1 & SET2 are synchronized in subsequent prepares of the table.

7) Useful query to identify the same:

select zd_edition_name, count(1) from <owner_name>.table_name group by zd_edition_name;

8) Once the table is converted to the Dual Row Set mode, a new column is seen "ZD_SYNC". This column indicates if the seed data sync was done successfully.

Doc id - 2283796.1