This is a description of roquicks7.gif. Using the SQL statements in the figure, the image shows the following row inserted into the oratt.readtab cached Oracle table:
keyval str 3 Welcome
The row where keyval=2 is deleted from the oratt.readtab cached Oracle table. The row where keyval=1 in the oratt.readtab cached Oracle table is updated such that the value in the str column is changed to Hi.
After the INSERT, DELETE and UPDATE statements have been committed on the cached Oracle table, they are automatically refreshed into the oratt.readtab cache table in the readcache read-only cache group within the TimesTen database. As a result, the TimesTen cache table and the cached Oracle table contain the following rows:
keyval str 1 Hi 3 Welcome
End of description.