RDBPROD: Are record changes made in my previous READ WRITE transaction visible in my new READ ONLY transaction? (Doc ID 1592384.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.0.1 and later
HP OpenVMS Itanium
HP OpenVMS Alpha

Goal

Rdb provides additional concurrency by using snapshot copies, stored in separate files, but how up-to-date is the data in a READ ONLY transaction? For example, if I perform a series of updates in a READ WRITE transaction will these be available when I start a READ ONLY immediately after?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms