Hi OTN community,
I have a question and appreciate the input.
We inserted multiple rows into few tables created with "rowdependencies" (Oracle DB 11.2.0.3). All new rows were committed altogether.
We expect to have single SCN assigned to all committed rows. When we read our inserted records later, we see that ora_rowscn pseudo column does not have the same scn for all inserted rows. Scn_to_timestamp for some rows shows the time close to commit time, for other rows it shows much later time, could be 30 minutes later or more. The rows were not updated or read after commit.
Is it possible to have different SCN number in records from single commit? Is it possible to have SCN timestamp much later than actual commit? Why it is happening?
Thank you for your response,
Vera